Varaiables and observations in another Text

[R_Win]

I have a 300 variables in one text doument and the observations for this variables are in Excel how can i read both these variables in a single dataset.

[sbb]

SAS can provide several different approaches, for example, use a DATA step (with INFILE and INPUT statements) to read each external file, generating a SAS member, and then use PROC IMPORT to input the Excel file, generating a second SAS member, and a third DATA step with a SET statement to combine the two SAS member together.

Scott Barry
SBBWorks, Inc.

http://support.sas.com/documentation/onlinedoc/base/index.html


SUGI/SGF papers on DATA STEP processing:
http://www2.sas.com/proceedings/sugi30/134-30.pdf

http://support.sas.com/rnd/base/datastep/dsods-sugi.pdf

SUGI/SGF paper on PROC IMPORT:
http://www2.sas.com/proceedings/sugi26/p159-26.pdf