topic Re: Selecting a Hardcoded Date in SAS Programming

Selecting a Hardcoded Date

Jyuen204 — Fri, 26 Mar 2021 13:47:14 GMT

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!

Re: Selecting a Hardcoded Date

andreas_lds — Fri, 26 Mar 2021 14:01:47 GMT

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;

Re: Selecting a Hardcoded Date

Jyuen204 — Fri, 26 Mar 2021 14:04:10 GMT

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