create varnames in proc iml

panda — Fri, 07 Jul 2017 19:54:15 GMT

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):

proc iml;
c = j(24, 120, 0);
varNames = "A0" : "A59"; 
varNames = "B0" : "B59";
create data from c [colname = varNames];
append from c;
close data;

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

Re: create varnames in proc iml

WarrenKuhfeld — Fri, 07 Jul 2017 22:26:16 GMT

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;

topic Re: create varnames in proc iml in SAS/IML Software and Matrix Computations

create varnames in proc iml

Re: create varnames in proc iml