How to convert numeric value without format in Macro variable to actual date?
I have a macro variable that stores value of " 21619".
However, as we know, it has leading space and that it is a character.
script as follows.
data a; testdt=' 21619'; run; proc sql noprint; select testdt into:testdt from a; quit;
I am trying to use &testdt. to do query in another table within the same macro but it just keeps giving me errors.
my script as follows.
PROC SQL; CREATE TABLE usa AS SELECT * FROM temp.car where batchdate <= %sysfunc(put("&testdt.",date9.)); quit;
I might have overlooked some of the important steps in converting it but what is wrong here?
If the variable batchdate is a SAS date value, then the comparison is very simple:
where batchdate <= &testdt.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: