Date: Fri, 10 Oct 1997 17:31:19 -0400
Reply-To: jupiterbowl <scot@WAM.UMD.EDU>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: jupiterbowl <scot@WAM.UMD.EDU>
Organization: University of Maryland, College Park
Subject: reading in a correlation matrix
Hi,
I'm trying to read in a correlation matrix I have and create a SAS data
set from it to then run a principal components analysis. I thought proc
iml would be a good way to start, but when the 'create' statement runs, I
get a message stating there are no observations in the dataset.
I've included a log showing my attempts. Any suggestions for running this
program more effectively, or more generally, how to read in a correlation
matrix into a sas dataset would be appreciated.
Thanks
Scot
***begin log*****
49 proc iml;
IML Ready
50 x =
51 {1 .8514 .9083 .6219 .2950 .6194 .2532 .2573,
52 .8514 1 .9015 .6086 .3455 .6266 .2293 .2900,
53 .9083 .9015 1 .6224 .2771 .6203 .2175 .2987,
54 .6219 .6086 .6224 1 .4330 .7417 .3943 .4772,
55 .2950 .3455 .2771 .4330 1 .5131 .2450 .1432,
56 .6194 .6266 .6203 .7417 .5131 1 .4052 .5054,
57 .2532 .2293 .2175 .3943 .2450 .4052 1 .5770,
58 .2573 .2900 .2987 .4772 .1432 .5054 .5770 1 } ;
59
60
61 col='x1':'x8' ;
62 z='x1':'x8' ;
63
64
65 print x col z;
66
67 libname ssd 'c:\scotdiss\data';
NOTE: Libref SSD was successfully assigned as follows:
Engine: V612
Physical Name: c:\scotdiss\data
68
69
70 create edms6572 from x [colname=col /*rowname=z*/] ;
71
72 quit;
Exiting IML.
NOTE: The data set WORK.EDMS6572 has 0 observations and 8 variables.
NOTE: The PROCEDURE IML used 0.11 seconds.
****end log****
--
\----/ \----/ \----/
|||| Scot McNary |||| scot@wam.umd.edu ||||
|||| Graduate Student, UMCP |||| (bethany too) ||||
/----\ /----\ /----\
|