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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.