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
Yep.
intnx('month',serv_from_date, 0,'e') as EOM_DOS format=mmddyy10.
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;
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;
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;
Yep.
intnx('month',serv_from_date, 0,'e') as EOM_DOS format=mmddyy10.
Perfect. Thank you all!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.