Statistical programming, matrix languages, and more

read the values, how to read the obs from the dataset

Accepted Solution Solved
Reply
Super Contributor
Posts: 328
Accepted Solution

read the values, how to read the obs from the dataset

I need to read the values of the dependent variable y from the sas data I created into an n * K matrix, where n is the number of obs in each group and k is the number of levels of my cateogrial variable.   i need first to write k statements to read the obs from the dataset into k column vectors of dimension nX1, then needd to write a statment that horizontally concatenates these k columns vectors to form the n * k matrix

 

w


Accepted Solutions
Solution
‎05-25-2016 02:57 PM
SAS Super FREQ
Posts: 3,234

Re: read the values, how to read the obs from the dataset

If you look at my last message, you will see that there are no hard-coded values anywhere.  It should solve the problem as you have explained it.

View solution in original post


All Replies
Frequent Contributor
Posts: 122

Re: read the values, how to read the obs from the dataset

You may need to supply some more details on how the SAS data set is structured to get better help.  However, my feeling is that you would be better to read the variable y into one vector, and then manipulate this is IML.  For example look at the SHAPE function which can be used to turn a vector into a matrix.

Super Contributor
Posts: 328

Re: read the values, how to read the obs from the dataset

a SAS data set that contains one continuous variable (y) and one categorical variable (x) with at least three levels. These are to be used as my continuous dependent variable and categorical independent variable in my single factor ANOVA model

then i will need to do sas iml

 

i have three groups, each has 11 obs

Frequent Contributor
Posts: 122

Re: read the values, how to read the obs from the dataset

My suggestion to use SHAPE works as long as all the groups have the same size and the SAS data set is sorted by group.   Then you could use code like this:

 

  use mydata;
  read all var {y} into y;
  z = t( shape(y, 3, 11) );
  print z;

 

Super Contributor
Posts: 328

Re: read the values, how to read the obs from the dataset

Thanks

SAS Super FREQ
Posts: 3,234

Re: read the values, how to read the obs from the dataset

or even simpler:

 

z = shapecol(y, 11);

Super Contributor
Posts: 328

Re: read the values, how to read the obs from the dataset

thanks

Super Contributor
Posts: 328

Re: read the values, how to read the obs from the dataset

Then I realize I might need alternative code, that is, do not use 11, 3, but use a more general code, so that it can be fit for other similiar kind of dataset as well.

 

My question is, if others have simiar dataset, but instead of 11 obs, they have 20 obs, five categories, another dataset have 50 obs, four categories, can I have a more general code so that the code can be used for other datasets as well, "one size fits all"?

 

Thanks

SAS Super FREQ
Posts: 3,234

Re: read the values, how to read the obs from the dataset

You need to know either how many categories or how many obsevations.  You also need to make sure that each group has the same number of elements.

 

The best situation is if you have a categorical variable that tells you the group that each observations is associated with. Then you could do something like this

 

read all var {Group y};

numGroups = ncol(unique(Group));

z = shapecol(y, 0, numGroups);

 

If you don't have a GROUP variable, you'll have to input the numGroups value manually.

Super Contributor
Posts: 328

Re: read the values, how to read the obs from the dataset

I do have a variable "Tem", it is a charactor not a numeric. It has three catogories

 

proc iml;

reset print;

use have;

read all var {tem y};

numGroups = ncol(unique(tem));

z = shapecol(y, 0, numGroups);

ERROR: Y is not in the scope of variables for the data set.

does it mean that I have to convert the charactor to numeric variable?

SAS Super FREQ
Posts: 3,234

Re: read the values, how to read the obs from the dataset

No, the error is saying that you do not a variable named 'Y'.

 

Here is some data that shows you how it works:

data have;
do tem = 'A', 'B', 'C';
   do i = 1 to 5;
      y = rand("uniform");
      output;
   end;
end;

proc iml; 
use have;
read all var {tem y};
numGroups = ncol(unique(tem));
z = shapecol(y, 0, numGroups);
print z;

By the way, you mistakenly choose your own post as the solution. :-)

 

Super Contributor
Posts: 328

Re: read the values, how to read the obs from the dataset

Thank you very much. This does show me how it works. . But my question remained unsolved, if I need a general code, rather than to type the number 3 and 11

Solution
‎05-25-2016 02:57 PM
SAS Super FREQ
Posts: 3,234

Re: read the values, how to read the obs from the dataset

If you look at my last message, you will see that there are no hard-coded values anywhere.  It should solve the problem as you have explained it.

Super Contributor
Posts: 328

Re: read the values, how to read the obs from the dataset

That is so good. Great learning experience! Thanks.

Post a Question
Discussion Stats
  • 13 replies
  • 569 views
  • 8 likes
  • 3 in conversation