If your dataset is reasonably small, for example, less than 100 observations and fewer than 10 variables (columns), then the most convenient way to access your data is to copy it into your SAS program.
To copy your data into SAS:
Open your data file (format of file doesn't matter: could be a spreadsheet, text file, etc.).
Highlight the data values and copy (Ctrl-C).
Open a new SAS Editor Window (File New Program; Ctrl-N) and paste (Ctrl-V).
Alternatively, you can type your data directly into the SAS Editor Window.
Always be sure to save your work: Ctrl-S.
SAS statements to read the data:
SAS needs to be told three things: a SAS name for the dataset, names for each of your variables, and any special format for those variables. These are accomplished with two SAS statements:
The DATA statement starts this process by naming the dataset, for example DATA one;
SAS statements always start with a keyword and end with a semicolon.
The INPUT statement names the variables and describes how they should be read in.
Finally, a DATALINES statement tells SAS that the data values follow.
\\\6 or 7 Examples (snagits)