topic Re: proc sql in SAS Programming

proc sql

rajat1 — Mon, 23 Oct 2017 18:29:52 GMT

Import smb usage data into sas and provide labels from "Churners and label ' file . (9999 OBSERVATIONS AND 400 VARIABLES )

I am only able to import the file

Re: proc sql

Reeza — Mon, 23 Oct 2017 18:34:31 GMT

I think the answer is the same as this question.

https://communities.sas.com/t5/Base-SAS-Programming/proc-sql/m-p/406565

Re: proc sql

rajat1 — Mon, 23 Oct 2017 18:39:25 GMT

this is the second data file

Re: proc sql

RW9 — Mon, 23 Oct 2017 18:39:47 GMT

Sorry, the title of your post bears no resemblance to your post. You have not provided any clear indication on what your question is. It appears you have copied part of a question from some test and expect a response. Please review the guidance on how to post a question to get a good response - from the main page, or by the Post button. At a guess - as I wouldn't download Excel files from the web, you have data in one tab and labels in another. If so read in both datasets, then using the one with labels generate a statement to label the data, e.g.:

data _null_;
  set labelstab end=last;
  if _n_=1 then call execute('data want;  set have;');
  call execute('label ',varfromtab,'="',label,'";');
  if last then call execute(';run;');
run;

Alternatively, convert the file into two CSV files - far better data format, then read the labels one into SAS first using a datastep import, then use that data, much like the above, to write the datastep import for the second set of data. That way you can read the second in directly without need for post processing.

Re: proc sql

RW9 — Mon, 23 Oct 2017 18:39:48 GMT

data _null_;
  set labelstab end=last;
  if _n_=1 then call execute('data want;  set have;');
  call execute('label ',varfromtab,'="',label,'";');
  if last then call execute(';run;');
run;