topic Re: SAS Date and time in SAS Programming

SAS Date and time

Vaibhav_Kalra — Mon, 06 Aug 2018 08:41:17 GMT

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

Re: SAS Date and time

RW9 — Mon, 06 Aug 2018 09:11:27 GMT

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.

Re: SAS Date and time

Kurt_Bremser — Mon, 06 Aug 2018 10:03:31 GMT

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.

Re: SAS Date and time

Ksharp — Mon, 06 Aug 2018 12:37:03 GMT

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

Re: SAS Date and time

Haikuo — Fri, 10 Aug 2018 17:35:33 GMT

Or:

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