Hello,
Quick question for you guys: I basically want to create a macro variable called syserr1 that if greater than 0 will give me an error message in an other code.
Now, the code below creates my macro variable no problem, I was just wondering if it was possible to create ONLY one macro variable in my procedure instead of 3? (AKA no need to create &nobs and &nuniqid
proc sql;
select count(distinct ID) as Nuniq, count(*) as Nobs, calculated Nobs - calculated Nuniq as diff
into :nobs, :nuniqid, :syserr1
from Have
;
quit;
Thank you
proc sql;
select count(*) - count(distinct ID) into :syserr1
from Have
;
quit;
I really don't understand your question. If you only want one macro variable, then only select one data item:
proc sql;
select count(distinct ID)
into :nobs
from Have;
quit;
proc sql;
select count(*) - count(distinct ID) into :syserr1
from Have
;
quit;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.