Base SAS Missover | Truncover | Flowover | Stopover | Scanover | Pad
In Base SAS programming, one uses MISSOVER option when you are reading a file that has records of different length and has missing values at the end of a record. The TRUNCOVER option acts similarly to MISSOVER, and in addition, will take partial values to fill the first unfilled variable. The FLOWOVER option is the default option on INFILE. Here, when the INPUT statement reaches the end of non-blank characters without having filled all variables, a new line is read into the Input Buffer and INPUT attempts to fill the rest of the variables starting from column one. STOPOVER option in SAS causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement. SCANOVER option causes the INPUT statement to scan the input data records until the character string that is specified in the @'character-string' expression is found. PAD option in SAS controls whether SAS pads the records that are read from an external file with blanks to the length that is specified in the LRECL= option.
Chapters:
0:00 Introduction
0:19 Flowover
3:19 Stopover
5:07 PAD
7:18 Truncover
10:08 Scanover
#sasprogramming #analytics #dataanalysis #basesas #sasprogrammingtutorial #analyticsschool
