Help using Base SAS procedures

char date to numeric date

Reply
Regular Contributor
Posts: 168

char date to numeric date

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)

;

Regular Contributor
Posts: 168

Re: char date to numeric date

Hi all

i got the required output

sorry to post

CODE:

_dt=compress(dt);

newdt=input(_dt,date9.);

thanks

Sam

Ask a Question
Discussion stats
  • 1 reply
  • 180 views
  • 0 likes
  • 1 in conversation