topic Re: How to convert a SAS numeric date value to SAS date format in PROC SQL in SAS Programming

How to convert a SAS numeric date value to SAS date format in PROC SQL

lmtamina — Mon, 12 Mar 2018 15:50:24 GMT

How do I save a SAS numeric date value into SAS date format in PROC SQL. Currently, I have a DATA step to convert the variable to SAS date format using FORMAT mydate MMDDYY10. Can I directly convert the SAS numeric value to date format(mm/dd/yyyy) in PROC SQL ? Appreciate any assistance. Thank you

Re: How to convert a SAS numeric date value to SAS date format in PROC SQL

RW9 — Mon, 12 Mar 2018 15:53:05 GMT

Sure, you can use SAS functions and formats in SQL so long as your not using pass-through, e.g:

proc sql;
  create table want as
  select date_num format=mmddyy10.
  from  have;
quit;

Re: How to convert a SAS numeric date value to SAS date format in PROC SQL

lmtamina — Mon, 12 Mar 2018 16:07:57 GMT

I am creating a new variable for the end of the month of my service date , can I use the FORMAT function below? Sorry, I am a SAS newbie.

proc sql;

create table want as
select

serv_from_date,

intnx('month',serv_from_date, 0,'e') as EOM_DOS

from have;
quit;

Re: How to convert a SAS numeric date value to SAS date format in PROC SQL

kiranv_ — Mon, 12 Mar 2018 16:12:43 GMT

Just use @RW9 code within new variable as

proc sql;

 create table want as
   select

    serv_from_date,

    intnx('month',serv_from_date, 0,'e') as EOM_DOS format =mmddyy10.

   
  from  have;
quit;

Re: How to convert a SAS numeric date value to SAS date format in PROC SQL

RW9 — Mon, 12 Mar 2018 16:13:29 GMT

Yep.

intnx('month',serv_from_date, 0,'e') as EOM_DOS format=mmddyy10.

Re: How to convert a SAS numeric date value to SAS date format in PROC SQL

lmtamina — Mon, 12 Mar 2018 16:18:00 GMT

Perfect. Thank you all!