topic Re: Proc SQL Query to create and store macro value in table in SAS Programming

Proc SQL Query to create and store macro value in table

nit123 — Sun, 15 May 2016 23:55:04 GMT

Hi All,

I am trying to create a macro variable using Proc SQL and store it in a table. but I am getting the above warning

WARNING: INTO clause is ignored in the CREATE TABLE statement.

proc sql;
create table t as select count(*) as c into :car from sashelp.cars;
quit;

any help would be appreciated.

Thank you,

Nitesh

Re: Proc SQL Query to create and store macro value in table

Reeza — Mon, 16 May 2016 00:17:58 GMT

You can either create a macro or store it into a table, not both in a PROC SQL step.

You can use two separate steps but it doesn't make a lot of sense given your current query, since you have a single value which is accessible in the macro variable.

proc sql noprint;
create table t as
select count(*) as c 
from sashelp.cars;

select c into :car from t;
quit;

Re: Proc SQL Query to create and store macro value in table

DimaFrank — Thu, 14 Oct 2021 07:26:09 GMT

Try this query to initialize the macro variable.

proc sql;
select count(*) as c
into :car
from sashelp.cars;
quit;

%put &car.;