DATA Step, Macro, Functions and more

passing quoted date to DB2

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

passing quoted date to DB2

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


Accepted Solutions
Solution
‎01-22-2015 03:54 AM
Super User
Posts: 3,100

Re: passing quoted date to DB2

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

View solution in original post


All Replies
Solution
‎01-22-2015 03:54 AM
Super User
Posts: 3,100

Re: passing quoted date to DB2

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

Super User
Posts: 5,254

Re: passing quoted date to DB2

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

Data never sleeps
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 196 views
  • 0 likes
  • 3 in conversation