background preloader

SAS

Facebook Twitter

Www.lexjansen.com/mwsug/2009/sas101/MWSUG-2009-B04.pdf. Www2.sas.com/proceedings/sugi29/068-29.pdf. Www.lexjansen.com/wuss/2006/SAS_essentials/ESS-Carroll.pdf. SAS FAQ: What are some common options for the infile statement? SAS FAQ What are some common options for the infile statement in SAS? This page was adapted from a FAQ (FAQ #92) developed by The University of Texas at Austin Statistical Services, and thank them for permission to use their materials in developing our FAQs for our web site. There are a large number of options that you can use on the infile statement. This is a brief summary of commonly used options. You can determine which options you may need by examining your raw data file e.g., in Notepad, Wordpad, using more (on UNIX) or any other command that allows you to view your data. Let's start with a simple example reading the space delimited file shown below.

The example program shows how to read the space delimited file shown above. DATA cars; INFILE 'space1.txt' ; INPUT mpg weight price; RUN; PROC PRINT DATA=cars; RUN; As you can see in the output below, the data was read properly. Infile options For more complicated file layouts, refer to the infile options described below. Www.nesug.org/proceedings/nesug99/st/st251.pdf. Support.sas.com/techsup/technote/ts673.pdf.