Hi all -
I want to create a matrix with 24 rows and 120 columns, the ideal dataset looks like this:
A0 A1 A2 A3 ....A59 B0 B1 B2 B3 ... B59
0 0 0 0 0 0 0 0 0 0
RIght now cannot figure out how to name the columns, my code is attached here (this code does not work):
c = j(24, 120, 0);
varNames = "A0" : "A59";
varNames = "B0" : "B59";
create data from c [colname = varNames];
append from c;
Create A columns and B columns and merge them together might help but eventually I want to create a matrix from A to Z, which has 1440 columns, so that approach might not be good enough.
Any idea? Thanks!!
Just concatenate your name vectors:
proc iml;c = j(24, 120, 0);varNames = ("A0" : "A59") || ("B0" : "B59");create data from c [colname = varNames];append from c;close data;quit; proc contents varnum; ods select position; run;
View solution in original post
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Submit your idea!
Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.
Find more tutorials on the SAS Users YouTube channel.