MailLib Concept – Topics

MailLib! A New Experience. Test the Concept for Free.

Exercise 1

Summing all the variables in a series of variables, from prefix1 to prefixn, where n is the number of your choice

Exercise 2

Listing all the variables present between two given variables

Exercise 3

Including or excluding missing values in the computation of a sum

Exercise 4

Selecting observations using the operator like

Exercise 5

Dealing with an empty dataset when extracting the number of observations using a data step

Exercise 6

Creating a character variable from another character variable using the function put: Avoiding truncation due to values not available in the format

Exercise 7

Creating a numeric variable from a character variable: avoiding unexpected matches

Exercise 8

Creating a numeric variable from another character variable: Avoid unforeseen numbers

Exercise 9

Creating a character variable from another character variable using the function put: Avoid truncation due to format label width/variable length problems

Exercise 10

Getting the lagged values of a variable by group of observations in a data step

Exercise 11

Transposing data based on variables in the by statement rather than on the position of the observation

Exercise 12

Avoiding an implicit retain while merging two data sets in a data step

Exercise 13

Avoiding overwriting the values of one variable with those of another when merging two datasets

Exercise 14

Creating a character variable from another character variable using the function putc: Avoid truncation

Exercise 15

Extracting the list of variable labels from the metadata