topic Re: Proc ds2 macro in SAS Programming

Proc ds2 macro

langalife — Sun, 25 Jul 2021 10:07:50 GMT

Good day

I am new to sas ds2. I kindly request an assistance.

I have been trying to create a macro variable using 2 methods.

using select into: and call symput but both does not work

proc ds2;
data _null_;
method run();
SET {select interest_rate into :rate from elookup.interest_rate where
information_date in (select max(information_date) from
elookup.interest_rate) where infomation_date=max(infomation_date)};
end;
enddata;
run;
quit;

i am getting this error below.

ERROR: Compilation error.
ERROR: Syntax error at or near ":"
ERROR: Line 79: Unable to prepare SQL query (rc=0x80fff802U).

Re: Proc ds2 macro

Tom — Sun, 25 Jul 2021 15:04:53 GMT

You cannot have an SQL SELECT statement that both returns its results as a dataset and also generates macro variables.

Since you are using the SELECT statement to return data to your DS2 data step remove the INTO clause from the SQL.

Or if you just want to set macro variables then use PROC SQL instead of PROC DS2 to run the SELECT statement.

Re: Proc ds2 macro

langalife — Mon, 26 Jul 2021 05:56:40 GMT

I have tried Fedsql I didn't come right.

Re: Proc ds2 macro

ChrisNZ — Mon, 26 Jul 2021 06:07:07 GMT

Why won't you use proc sql?

Re: Proc ds2 macro

langalife — Mon, 26 Jul 2021 06:10:38 GMT

hi there is a thin line between sas and sas ds2, which in my mind proc sql is being replaced by fedsql.

Re: Proc ds2 macro

ChrisNZ — Mon, 26 Jul 2021 06:39:43 GMT

> proc sql is being replaced by fedsql.

No at all. Different tools for different purposes.

Likewise DS2 does not replace the data step. DS2 is better some some tasks (heavy multithreading on distributed platforms) and much slower on the wrong hardware.