Statistical programming, matrix languages, and more

Converting each row fo data into a matrix

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Converting each row fo data into a matrix

Dear All,

I have a long time series of a covariance matrix stored in a sas dataset. For each observation, there are 7 variables variables like:

"date c11 c21 c31 c22 c32 c33"

where c11 - c33 are the lower triangle elements of the cov-matrix.

In order to make use of some matrix routines in IML, I would like to convert each row into a full matrix:

M= {   c11 c21 c31,

          c21 c22 c32,

          c31 c32 c33 }

Could someone provide some suggestions on the transformation please?

Thanks you!


Accepted Solutions
Solution
‎05-14-2013 07:33 AM
Frequent Contributor
Posts: 130

Re: Converting each row fo data into a matrix

Have a look at the SQRSYM and SQRVECH functions which are designed for doing exactly this. If you have read your six variables into the matrix x, something like:

M=sqrvech(x[i,]);

should do the trick for the ith row.

View solution in original post


All Replies
Solution
‎05-14-2013 07:33 AM
Frequent Contributor
Posts: 130

Re: Converting each row fo data into a matrix

Have a look at the SQRSYM and SQRVECH functions which are designed for doing exactly this. If you have read your six variables into the matrix x, something like:

M=sqrvech(x[i,]);

should do the trick for the ith row.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 257 views
  • 0 likes
  • 2 in conversation