topic Re: create two sas macro variables using proc sql with Into statement in SAS Programming

create two sas macro variables using proc sql with Into statement

Ronein — Wed, 29 Aug 2018 10:37:11 GMT

Hello

I want to create two sas macro variables using proc sql with Into statement

What is wrong with following code syntax?

PROC SQL  noprint;
	select 	sum( SUM_Sales_Region) into:  PGrand_Total_Sales,
	                sum(Customers_Region) into :  PCustomers_Region
	from outcome1
;
QUIT;

Re: create two sas macro variables using proc sql with Into statement

FredrikE — Wed, 29 Aug 2018 10:42:59 GMT

First select variables then macro variables 🙂

Easier to read if you move the : to the macro variables.

PROC SQL  noprint;
	select 	sum( SUM_Sales_Region), sum(Customers_Region)  into :PGrand_Total_Sales, :PCustomers_Region
	from outcome1
;
QUIT;

//Fredrik

Re: create two sas macro variables using proc sql with Into statement

RW9 — Wed, 29 Aug 2018 10:44:56 GMT

proc sql;
  select count(*),sum(case when sex="M" then 1 else 0 end)
  into :v1, :v2
  from sashelp.class;
quit;

%put &v1.;
%put &v2.;