Hi,
I try to do something very easy:
I have a global variable c and a SAS table A.
This is working:
data WORK.B; set WORK.A (firstobs= 2 obs= &c.); run;
This is not...
data WORK.B; set WORK.A (firstobs= 2 obs= &c.-1); run;
Isn't it possible to do it without creating another new variable??
Thanks for reply
Use
set WORK.A (firstobs= 2 obs=%eval(&c.-1));
This lets the macro processor do the calculation and hands a simple number over to the dataset option.
Use
set WORK.A (firstobs= 2 obs=%eval(&c.-1));
This lets the macro processor do the calculation and hands a simple number over to the dataset option.
Thanks Kurt, it is indeed working. Have a good day
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.