Page 15 - SAS_manual

By observing the above program we came to know for any missing value there is a dot ( . ) Symbol
came.

3.1.2 Reading Data Values Separated by Commas

You have a challenge to read the bellow data

CARDS;
"SAS",DW,Short
"SQL",DB,Long
;
Program 3.3:

Output:

Notice the INFILE statement in this example. The DSD (delimiter-sensitive data) following the file name is
an INFILE option. It performs several functions. First, it changes the default delimiter from a blank to a
comma. Next, if there are two delimiters in a row, it assumes there is a missing value between. Finally, if
character values are placed in quotes (single or double quotes), the quotes are stripped from the value.

3.1.3 Reading Data Values Separated by Delimiters Other

Than space and comma:

The default data delimiter for list input is a blank. Using the INFILE Option DSD changes the default to a
comma. But we have a challenge that what if you have delimiters other than comma and space. You only
need to add the DLM= option to the INFILE statement.

SAS HANDBOOK | VISIT:: http://nikhilanalytics.com 15