Selecting multiple variables in PROC SQL, but only creating one macro variable with into clause

[x2PSx]

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

[RW9]

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;

[x2PSx]

The macro variable that I need is the difference between the unique observations and the total number of observations. My third variable in the select clause creates this variable and is the only one that I need.

[Reeza · Accepted solution]

proc sql;
	select count(*) - count(distinct ID) into :syserr1
		from Have
	;
quit;

[x2PSx]

I knew it was gonna be easy... Wow. Thank you very much for response time, Good day to you!