I have some table inserts i an trying to do and with the insert I am wanting to include a hardcoded date.
proc sql;
select '8Mar2021'd as CAMP_DT from <TABLE>;
quit;
This comes back with a numeric date...
Tried:
datepart('8Mar2021'd) format date9. as CAMP_DT
But that came back in the correct format, wrong date (SAS Origin date 01JAN1960)
Just trying to return 08MAR2021 in this example.
Thanks!
If you want a human-readable date just attach a format, try
proc sql;
select '8Mar2021'd as CAMP_DT format=date9. from <TABLE>;
quit;
If you want a human-readable date just attach a format, try
proc sql;
select '8Mar2021'd as CAMP_DT format=date9. from <TABLE>;
quit;
Ah, I over thought it. Thank you so much!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.