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;
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;
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: