topic Re: Read dataset into PROC IML in SAS/IML Software and Matrix Computations

Read dataset into PROC IML

SchalkBurger — Sat, 20 May 2017 20:32:50 GMT

Hello.

I want to read a dataset with two columns into proc iml, but it only prints one column when I print it.

Can someone tell me what I am doing wrong please?

proc iml;
        use data.lossdata;
	read all var {lob loss} into A[colname = varNames];
	print A;
quit;

Re: Read dataset into PROC IML

Ksharp — Sun, 21 May 2017 03:04:43 GMT

These two variables have the same type ? both are numeric or character ?

Re: Read dataset into PROC IML

SchalkBurger — Sun, 21 May 2017 05:53:34 GMT

The lob is a character and loss numeric.

Re: Read dataset into PROC IML

IanWakeling — Sun, 21 May 2017 06:52:54 GMT

@Ksharp has diagnosed the problem correctly, as matrices are either all character or all numeric. Whenever you run code, it is always good to check the SAS log for messages, as I suspect you have missed a warning message about a type missmatch.

Also check the recent thread on this forum called "Matrix with strings in IML", in particular the link that Rick gives to the Table structure.

Re: Read dataset into PROC IML

Rick_SAS — Sun, 21 May 2017 10:49:56 GMT

You can read the variables into vectors:

read all var {lob loss};

For more information about reading numeric and character variables, see

How to read data set variables into SAS/IML vectors

Reading ALL variables INTO a matrix

Re: Read dataset into PROC IML

SchalkBurger — Sun, 21 May 2017 11:53:01 GMT

Thank you all.
I appreciate the help.

There is still a lot to learn.

Re: Read dataset into PROC IML

Rick_SAS — Sun, 21 May 2017 23:07:26 GMT

Yes, there is always more to learn, but to get started you might try some of the tips at "Ten tips for learning the SAS/IML language", especially the SAS Global Forum paper "Getting Started with the SAS/IML Language" (Wicklin 2013)