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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.