BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Sir_Highbury
Quartz | Level 8

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,

SH

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

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;

View solution in original post

1 REPLY 1
PeterClemmensen
Tourmaline | Level 20

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;
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1279 views
  • 1 like
  • 2 in conversation