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:
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 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.