Help using Base SAS procedures

Creating a SAS table from Excel file with data in sheet1 and Variable Labels in Sheet2

Reply
Occasional Contributor
Posts: 9

Creating a SAS table from Excel file with data in sheet1 and Variable Labels in Sheet2

[ Edited ]

Hi SAS coders,

 

I'm a new learner of SAS, trying to create a SAS data set from excel file where data is in sheet 1 and Variable Labels are in sheet 2 in the following format:-

 

SHEET1:                                                           SHEET 2

Capture11.PNG      Capture12.PNG

Like this there are 20 columns and their variable labels. Is there a way I can create a data set without manually entering the Variable Labels using Label command? (Using SAS studio)

 

 

Super User
Super User
Posts: 7,942

Re: Creating a SAS table from Excel file with data in sheet1 and Variable Labels in Sheet2

Not sure this is a good example for learner to try and do.  What you want is to dynamically create code based on some metadata which is a more advanced topic.  However here is some code, first read in both sheets to datasets:

data _null_;
  set label_dataset end=last;
  if _n_=1 then call execute('data data_dataset; set data_dataset; label');
  call execute(' ',strip(variable),'="',strip(variable_label),'"');
  if last then call execute(';run;');
run;

What the above does is create a datastep with the label <variable>="<variable label>" for each row of your metadata sheet.  So saves you typing it all.  Again though, it is a more advanced topic, and the questions you should be asking is: is excel the best medium for data transfer, and why are column information on a different sheet?

Occasional Contributor
Posts: 9

Re: Creating a SAS table from Excel file with data in sheet1 and Variable Labels in Sheet2

Thanks for the help! Smiley Happy
Ask a Question
Discussion stats
  • 2 replies
  • 228 views
  • 1 like
  • 2 in conversation