topic Re: Generating SAS Program in SAS Programming

Generating SAS Program

SASSLICK001 — Sun, 02 Sep 2018 14:36:30 GMT

Hi All

I have the following dataset

pgmname

adae

adsl

adcm

I need to generate a sas program from the above dataset with the code:

%run(dataset=adsl);

%run(dataset=adae);

%run(dataset=adcm);

How can i achieve this? Any thoughts, thanks in advance!

Re: Generating SAS Program

Kurt_Bremser — Sun, 02 Sep 2018 15:33:41 GMT

Use

data _null_;
set have;
call execute('%nrstr(%run(dataset='!!trim(pgmname)!!'))');
run;

@SASSLICK001 wrote:

Hi All

I have the following dataset

pgmname

adae

adsl

adcm

I need to generate a sas program from the above dataset with the code:

%run(dataset=adsl);

%run(dataset=adae);

%run(dataset=adcm);

How can i achieve this? Any thoughts, thanks in advance!

Re: Generating SAS Program

SASSLICK001 — Sun, 02 Sep 2018 15:10:51 GMT

thanks Kurt for the quick reply, may i know where these records are being written, I wanted to write to a file for example : temp.sas

Re: Generating SAS Program

Kurt_Bremser — Sun, 02 Sep 2018 15:32:49 GMT

@SASSLICK001 wrote:
thanks Kurt for the quick reply, may i know where these records are being written, I wanted to write to a file for example : temp.sas

According to your own post, you wanted to run a macro repeatedly with values from a dataset you already have. That is what I gave you. There is NO word there about writing a file. Please make up your mind BEFORE posting a question.

Re: Generating SAS Program

SASSLICK001 — Sun, 02 Sep 2018 15:37:02 GMT

sorry I was not clear earlier, I actually wanted to the sas statements to .sas file

Re: Generating SAS Program

Tom — Sun, 02 Sep 2018 15:37:04 GMT

Your variable name does not seem appropriate for the code you are generating, but here you go.

data _null_;
  set have ;
  file 'myprogram.sas';
  put '%run(dataset=' pgmname ');' ;
run;

It would be even easier if the variable was named DATASET to match how you are using it in the generated code.

data _null_;
  set have ;
  file 'myprogram.sas';
  put '%run(' dataset= ');' ;
run;

Re: Generating SAS Program

Reeza — Sun, 02 Sep 2018 17:34:56 GMT

@SASSLICK001 wrote:
sorry I was not clear earlier, I actually wanted to the sas statements to .sas file

You can use CALL EXECUTE to call the macro directly. An older style of programming has a user write the commands to a file and then %INCLUDE the file, but CALL EXECUTE or DOSUBL are newer options that are more efficient since your program is fully dynamic/data driven.

Re: Generating SAS Program

Kurt_Bremser — Sun, 02 Sep 2018 17:37:16 GMT

@SASSLICK001 wrote:
sorry I was not clear earlier, I actually wanted to the sas statements to .sas file

Not necessary. See @Reeza's post.