topic Re: Create macro variable using the data in SAS Programming

Create macro variable using the data

Ivy — Thu, 04 Feb 2016 19:45:51 GMT

Dear friends,

I would like to create macro variable for each group to store # of pats respectively, please see below:

such as &a = 30 , &b = 20 ..... So I can use these numbers in my proc report procedure.

Group # of pats

a 30

b 20

c 2000

d 150

. .

May you let me know how I can do it ?

Thank you very much,

Ivy

Reeza — Thu, 04 Feb 2016 19:52:46 GMT

Use call symputX

data _null_;

set have;

call symputx('macrovar'||put(_n_, z2.), variable);

run;

%put &macrovar01.;
%put &macrovar02.;

Ivy — Thu, 04 Feb 2016 20:10:58 GMT

Thank you very much, worked !