Hi all
I am trying to insert values in a table with proc sql using a macro variable like this
proc sql;
insert into dummy (a, b, c, d, date)
values (&a., &b., &c., &d., &SYSDATE9);
quit;
Is there any option to achiveve the goal?. I try too with symget'SYSDATE9' and something else without success.
Thanks in advanced.
&SYSDATE is in the date format, which is the same format as the d literal is using.
You can't evaluate a macro variable within single quotes, you need double:
"&SYSDATE9"D
&SYSDATE is in the date format, which is the same format as the d literal is using.
You can't evaluate a macro variable within single quotes, you need double:
"&SYSDATE9"D
That will not work. Note that all macro expansion is doing is replacing the macro variable reference with the text of that macro variable. In this case you are generating code like:
insert into dummy (date) value (09SEP2014)
That will not be valid syntax since 09SEP2014 is not a variable reference or a literal value.
To generate a literal date value you need to add quotes and the letter D (for date).
insert into dummy (date) value ("09SEP2014"d)
So now you have legal SAS code and you can replace the date with the macro variable reference.
insert into dummy (date) value ("&sysdate9"d)
Thanks both for your quickly answer.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.