Scatterplot matrix from ODS in PROC CORR
in [SAS]
|
Prev: Dividing a table in to smaller tables
Next: PROC COMPARE checking unique records irrespective of position
From: Paul on 26 Mar 2010 10:59 Hi there, I'm trying to generate a scatterplot matrix using ODS in Proc Corr. Works fine except that not all the variables appear in the matrix. It seems capped at 5X5 when it should appear as a 9X9 matrix. From the code below the scatterplot matrix that is generated by ODS includes only (a_GLUCOSE_0, c_AMYLOID, e_CRP, f_HDL, g_INSULIN_0) however the PROC CORR output includes all 9 variables... ODS GRAPHICS ON; PROC CORR DATA=MERGED PLOTS=scatter(ellipse=none) ; VAR a_GLUCOSE_0 c_AMYLOID e_CRP f_HDL g_INSULIN_0 h_LDL i_TG j_VDBP k_VITD25 ; TITLE 'Correlation calculations using PROC CORR'; RUN; ODS GRAPHICS OFF; any suggestions? Am I missing something? thank you.
From: Paige Miller on 26 Mar 2010 12:47
On Mar 26, 10:59 am, Paul <parora...(a)gmail.com> wrote: > Hi there, > > I'm trying to generate a scatterplot matrix using ODS in Proc Corr. > Works fine except that not all the variables appear in the matrix. It > seems capped at 5X5 when it should appear as a 9X9 matrix. From the > code below the scatterplot matrix that is generated by ODS includes > only (a_GLUCOSE_0, c_AMYLOID, e_CRP, f_HDL, g_INSULIN_0) however the > PROC CORR output includes all 9 variables... > > ODS GRAPHICS ON; > PROC CORR DATA=MERGED PLOTS=scatter(ellipse=none) ; > VAR a_GLUCOSE_0 > c_AMYLOID > e_CRP > f_HDL > g_INSULIN_0 > h_LDL > i_TG > j_VDBP > k_VITD25 ; > TITLE 'Correlation calculations using PROC CORR'; > RUN; > ODS GRAPHICS OFF; > > any suggestions? Am I missing something? > > thank you. You need to look up and then use the NVAR and NWITH options. -- Paige Miller paige\dot\miller \at\ kodak\dot\com |