Hi ,
Currently am having the date field EFFDAT and it displaying as
10012010
9012010
and its type is 'number' and format is 'BEST12.' AND informat is 'BEST32.'
I need to display it as 20101001
20100912
Please let me know.
Thanks,
Would something like the following suffice?
data have;
format datefield best12.;
format datefield best12.;
input datefield;
cards;
10012010
9012010
;
options datestyle=mdy;
data want;
set have;
format datefield yymmddN8.;
datefield=input(put(datefield,best12.),anydtdte.);
run;
you can use something like this :
data x;
input dt ;
cards;
10012010
9012010
;
run;
data y;
set x;
dt1 = input(put(dt,z8.),mmddyy8.);
format dt1 date9.;
run;
I would change your format to yymmddN8. so that the value will display in YYMMDD form without any separators between YY and MM and DD.
Note that these solutions are storing a SAS date. This is different than storing the numeric value of 20100901.
Art, The format I suggested (i.e., yymmddN8.) also displalys without any separators.
Art,
You are correct. I was obviously not paying attention.
Art
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.