create time using proc iml and loop

Accepted Solution Solved
Reply
Contributor
Posts: 30
Accepted Solution

create time using proc iml and loop

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!!!


Accepted Solutions
Solution
‎07-08-2017 11:15 AM
Super User
Posts: 10,020

Re: create time using proc iml and loop

[ Edited ]

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;

View solution in original post


All Replies
Solution
‎07-08-2017 11:15 AM
Super User
Posts: 10,020

Re: create time using proc iml and loop

[ Edited ]

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;

Contributor
Posts: 30

Re: create time using proc iml and loop

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 119 views
  • 0 likes
  • 2 in conversation