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!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.