call variables using a macro

Sir_Highbury — Mon, 14 Nov 2016 07:30:50 GMT

Dear Expert,

I should do a calculation calculate the difference between two variables:

- dataset_201610

- dataset 201609

starting from the point that:

&current.=201610

&prev.=201609

How can I flexibly specify the columns using something like:

data_set_"&current."-data_set_"&prev."?

Thanks a lot in advance,

Re: call variables using a macro

PeterClemmensen — Mon, 14 Nov 2016 07:41:45 GMT

Like this? Have simply dropped the ""..

data have;
input dataset_201610 dataset_201609;
datalines;
10 5
20 1
;

%let current = 201610;
%let prev    = 201609;

data want;
   set have;
   newvar = dataset_&current-dataset_&prev;
run;

topic Re: call variables using a macro in SAS Programming

call variables using a macro

Re: call variables using a macro