topic How to numerate values into a list of macro variables in SAS Programming

How to numerate values into a list of macro variables

lichee — Fri, 06 Dec 2024 13:36:02 GMT

Hi all,

I have a list of values as below and want to assign macro variables (num_val&i.) like num_val1 for 0.5, num_val2 for 0.9, ... num_val5 for 2. Can anyone help me out? Thank you!

data have;
infile datalines truncover dsd;
input num_val;
datalines;
0.5
0.9
1.1
1.5
2
;
run;

Re: How to numerate values into a list of macro variables

PeterClemmensen — Fri, 06 Dec 2024 13:42:00 GMT

Try this

proc sql noprint;
   select num_val into :num_val1 -
   from have
   ;
quit;

%put &=num_val1.;
%put &=num_val2.;

Re: How to numerate values into a list of macro variables

PaigeMiller — Fri, 06 Dec 2024 13:44:36 GMT

In general, I am skeptical that this is a good approach. Can you please share with us what you will do with these macro variables once they are created, that cannot be done using data set HAVE?

Anyway, here is the code you want.

data _null_;
    set have;
    call symputx(cats('num_val',_n_),num_val);
run;