topic Re: How to use a sas variable in select statement in proc sql in SAS Programming

How to use a sas variable in select statement in proc sql

adisal — Thu, 04 Jun 2020 16:01:14 GMT

I want to use the month and year from today's date and use that as a column in SQL table .

Below is the code that I am using to get the month and year :

data _null_;
CUR_MONTH =today();
format CUR_MONTH yymmn6.;
put CUR_MONTH;
run;

Now , I want to use the variable CUR_MONTH in SELECT statement , something like :

PROC SQL;

SELECT

&CUR_MONTH , ID , NAME FROM ABC;

But , I get Error ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant,
a missing value, (, *, +, -, ALL, BTRIM, CALCULATED, CASE, DISTINCT, EXISTS, INPUT, NOT, PUT, SUBSTRING, TRANSLATE,
UNIQUE, USER, ^, ~.

Can someone please guide . Thanks.

Re: How to use a sas variable in select statement in proc sql

mklangley — Thu, 04 Jun 2020 16:18:12 GMT

Try:

data _null_;
    call symputx('CUR_MONTH', put(today(), yymmn6.));
run;

This will initialize CUR_MONTH as a macro variable, which you can use in the subsequent PROC SQL statement.

Re: How to use a sas variable in select statement in proc sql

adisal — Thu, 04 Jun 2020 16:40:06 GMT

Thanks. It works