Help using Base SAS procedures

Varaiables and observations in another Text

Reply
Regular Contributor
Posts: 229

Varaiables and observations in another Text

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: Varaiables and observations in another Text

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
Ask a Question
Discussion stats
  • 1 reply
  • 88 views
  • 0 likes
  • 2 in conversation