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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.