Selecting a Hardcoded Date

[Jyuen204]

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!

[andreas_lds · Accepted solution]

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;

[Jyuen204]

Ah, I over thought it. Thank you so much!