Hi all,
data have;
input pid dt $22.;
cards;
100 08 NOV 2013
100 09 DEC 2014
100 28 JAN 2014
;
run;
for dt variable format is $22. and informat is $22.
i need to create a new variable , dt converted in to numeric date
want:
pid dt newdt
100 08 NOV 2013 19645(these are rough values)
100 09 DEC 2014 19685(these are rough values)
100 28 JAN 2014 19825(these are rough values)
Hi all
i got the required output
sorry to post
CODE:
_dt=compress(dt);
newdt=input(_dt,date9.);
thanks
Sam
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Latest 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.
Browse our catalog!