Create SAS parameters from values in data set

Ronein — Sun, 26 Aug 2018 05:23:50 GMT

Hello

I have an external input data set with varaible "YYMM" that includes in this example 4 rows.

The target is to create 4 parameters called: m1,m2,m3,m4.

parameter &m1 will recieve value of varaible "YYMM" in row 1.

parameter &m2 will recieve value of varaible "YYMM" in row 2.

parameter &m3 will recieve value of varaible "YYMM" in row 3.

parameter &m4 will recieve value of varaible "YYMM" in row 4.

I am trying to it but I don't receive the requested result.

Please find the code.

thanks

Ron

DATA Raw_tbl;
INPUT YYMM;
CARDS;
1807
1806
1712
1707
;
RUN;


Data tbl2;
SET Raw_tbl;
VAR_NAME='m'||strip(_N_);
call symputx('VAR_NAME',VAR_NAME);
Run;

%put &m1; 
%put &m2; 
%put &m3; 
%put &m4;

Re: Create SAS parameters from values in data set

PeterClemmensen — Sun, 26 Aug 2018 05:35:26 GMT

Just to be clear, what you are trying to create are macro variables, not parameters. Change your data step to

Data tbl2;
SET Raw_tbl;
VAR_NAME='m'||strip(_N_);
call symputx(VAR_NAME,YYMM);
Run;

topic Re: Create SAS parameters from values in data set in SAS Programming

Create SAS parameters from values in data set

Re: Create SAS parameters from values in data set