create a macro variable uisng proc sql in a pass thru facility rsubmit/endrsubmit

[Santt0sh]

Hi All,

I am not sure if this can be done. Kindly suggest me on this. I am trying to create a macro variable in a Pass thru.

RSUBMIT;

proc sql noerrorstop;
connect to teradata (user="xxxxxxxxxx" PASS="xxxxxxxxx" TID=xxxxxxxx mode=teradata);
execute(
SELECT COUNT( DISTINCT  a_DT) INTO:a_DT
FROM xxxxxa1.xxxxxdays;
) by Teradata;
DISCONNECT FROM teradata;
QUIT;

ENDRSUBMIT;

[Santt0sh · Accepted solution]

Hi All,

Thank you !!
I have found a way to create the Macro variables.
RSUBMIT;
libname lib1 teradata server='xxxxxxxxxx.com' schema='ddddcccccvvvvv3' user="********" password="******";
proc sql noerrorstop;
connect to teradata (user="xxxxxxxxxx" PASS="xxxxxxxxx" TID=xxxxxxxx mode=teradata);
execute(
/*--------------ST DATE---------------*/
create table lib1.xxxxxTdays as (
SELECT distinct a_DT as a_DT
FROM xxxxxa1.xxxxxdays;
)with data
) by Teradata;
DISCONNECT FROM teradata;
QUIT;
proc sql noprint;
select MIN(a_DT ) into:STrDATE from lib1.xxxxxTdays;
quit;
%SYSRPUT STrDATE= &STrDATE.;
ENDRSUBMIT;



Thank you!