BookmarkSubscribeRSS Feed
sam369
Obsidian | Level 7

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)

;

1 REPLY 1
sam369
Obsidian | Level 7

Hi all

i got the required output

sorry to post

CODE:

_dt=compress(dt);

newdt=input(_dt,date9.);

thanks

Sam

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1001 views
  • 0 likes
  • 1 in conversation