topic create time using proc iml and loop in SAS Programming

create time using proc iml and loop

panda — Fri, 07 Jul 2017 15:13:11 GMT

Hi -

I want to create a time matrix using the proc iml function, the ideal output would be:

time1 time2 time3 time4 ... time 1339 time1440

0:00 0:01 0:02 0:03 .... 23:59 24:00

My current codes are like this, but does not work:

proc iml;

time = {'0:00't:'24:00't};
mattrib time format =timeampm.;

create matrix var {"Time"};
append;
close matrix;

I think looping would help but not sure what extactly to do, but writing the time for 1440 times definitely is not the solution.

Any idea?

Thanks!!!

Re: create time using proc iml and loop

Ksharp — Sat, 08 Jul 2017 05:49:02 GMT

Why not post it at IML forum ? since it is about IML question.

Fixed a problem.

proc iml; time=do('0:00't,'24:00't,'00:01't); vname='time1':'time'+char(ncol(time)); mattrib time format=hhmm5.; create want from time[c=vname]; append from time; close; quit;

Re: create time using proc iml and loop

panda — Sat, 08 Jul 2017 15:10:10 GMT

That makes sense, will do so in the future!!