The following is an example of an external file that contains data: Truncover - It assigns the raw data value to the variable even if the value is shorter than the length that is expected by the INPUT statement.
Instead, MISSOVER setsvariables to missing. Missover -When the MISSOVER option is used on the INFILE statement, the INPUT statement does not jump to the next line when reading a short line. Difference between Missover and Truncover tells SAS to read the number121713as the date December 17, 2013.įormat - To tell SAS how to print the variables. Informat - To tell SAS that a number should be read in a particular format.įor example: the informat mmddyy6. Informats read the data while Formats write the data. In the example shown above, ID and SEX are numeric variables and Name a character variable.Ģ. Note : The variable name, followed by $ (dollar sign), idenfities the variable type as character. The INFILE statement is used to identify an external file while the INPUT statment is used to describe your variables. The questions cover a wide range of topics, from simple theoretical concepts to tricky interview questions for both freshers and experienced SAS programmers. This will give you the confidence to crack your SAS interview. Below are the most frequently asked SAS interview questions, along with answers.