Depends whether your dates are like a, b or c in the following example
data test;
a = 201506; /* YYYYMM as a number */
b = '01JUN2015'd; /* SAS date value with YYYYMM format */
format b yymmn6.;
c = "201506"; /* char version of the YYYYMM date */
run;
proc print; run;
proc sql;
select
mdy(mod(a, 100), 1, int(a/100)) as date_a format=yymmdd6.,
b as date_b format=yymmdd6.,
input(c, yymmn6.) as date_c format=yymmdd6.
from test;
quit;
Result:
FORMAT= as a column option in either SELECT or CREATE statement,
Here you go:
data have;
informat date mmddyy10.;
format date mmddyy10.;
input date;
cards;
10/01/2015
;
run;
proc sql;
create table want as
select date format = date9.
from have;
Depends whether your dates are like a, b or c in the following example
data test;
a = 201506; /* YYYYMM as a number */
b = '01JUN2015'd; /* SAS date value with YYYYMM format */
format b yymmn6.;
c = "201506"; /* char version of the YYYYMM date */
run;
proc print; run;
proc sql;
select
mdy(mod(a, 100), 1, int(a/100)) as date_a format=yymmdd6.,
b as date_b format=yymmdd6.,
input(c, yymmn6.) as date_c format=yymmdd6.
from test;
quit;
Result:
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.