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

[lmtamina]

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

[RW9]

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;

[lmtamina]

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;

[kiranv_]

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;

 

[RW9 · Accepted solution]

Yep.

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

[lmtamina]

Perfect. Thank you all!