topic Re: Selecting multiple variables in PROC SQL, but only creating one macro variable with into clause in SAS Programming

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

x2PSx — Thu, 23 Nov 2017 15:33:59 GMT

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

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

RW9 — Thu, 23 Nov 2017 15:38:29 GMT

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;

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

x2PSx — Thu, 23 Nov 2017 15:44:11 GMT

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.

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

Reeza — Thu, 23 Nov 2017 15:57:49 GMT

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

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

x2PSx — Thu, 23 Nov 2017 16:01:47 GMT

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