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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.