topic how to create SAS dataset in Proc iml? in SAS Procedures

how to create SAS dataset in Proc iml?

Ken_oy — Fri, 11 Nov 2011 04:15:44 GMT

------------------------------------

PROC IML;

X={2 3,

4 5};

CREATE test2 FROM x[colname={'a' 'b'}];

APPEND FROM x;

Quit;

------------------------------------

I know the above code works;

But,

How to make the code below work? Thanks

I want to have a dataset "x" as

col1 col2

1 2

NOT

col1 col2

a b

-------------code with problem -----------

---------------------------------------------------

PROC IML;

a=1;

b=2;

x={a b};

CREATE test2 FROM x[colname={'a' 'b'}];

APPEND FROM x;

Quit;

------------------------------------

Peter_C — Fri, 11 Nov 2011 08:48:21 GMT

there is a better forum for

IML

Rick_SAS — Sat, 12 Nov 2011 19:20:18 GMT

The expression x={a b} creates a character matrix with the values "A" and "B".

You want to use horizontal concatenation to create a matrix from a and b:

x = a || b;

For more information on concatenation, download the FREE chapter of my book Statistical Programming with SAS/IML Software from http://support.sas.com/publishing/authors/wicklin.html and look on p. 41.

Rick