topic Re: passing quoted date to DB2 in SAS Programming

passing quoted date to DB2

Jaheuk — Thu, 22 Jan 2015 08:35:10 GMT

hi folks,

code below works, but is it possible to do it in one line :smileyconfused:

%LET dt =%sysfunc(putn(&s_date.,yymmddd10.));

%LET sd1=%bquote(')&dt%bquote(');

GreetZ,

Herman

SASKiwi — Thu, 22 Jan 2015 08:54:11 GMT

Try: %LET dt =%str(%')%sysfunc(putn(&s_date.,yymmddd10.))%str(%');

LinusH — Thu, 22 Jan 2015 08:55:38 GMT

Yes, haven't you tried it yourself...?????