SAS Date and time

[Vaibhav_Kalra]

Hi

I am facing a problem to convert the numeric function to the date part

my data  is

515

529

540

545

600

In the above 515 means 5:15

529 means 5:29

Please advise

Thanks

[RW9]

This "I am facing a problem to convert the numeric function to the date part" doesn't really make sense as the data you give and logic is for time?  I would be cautious about converting just a number like that to a time.  You could simply:

data want;
  input num;
  tmp=strip(put(num,best.));
  tmp=cats(char(tmp,1),":",substr(tmp,2,2));
datalines;
515
529
;
run;

But I suspect thats not really your problem, and your issue includes dates as well.  Perhaps provide fuller information, provide what you have as test data in the form of a datastep and what you want out at the end.

[Kurt_Bremser]

You need to fix such issues at the point where data enters your SAS environment.

Show how you imported the data into SAS. Just using the correct format there will remove the problem.

[Ksharp]

data want;
  input num;
  want=hms(int(num/100),mod(num,100),0);
  format want hhmm5.;
datalines;
515
529
;
run;

[Haikuo]

Or:

data want;
  input num;
  want=input(put(num,z4.),hhmmss4.);
  format want hhmm5.;
datalines;
515
529
;
run;