I am running a MANOVA in proc GLM. I would like to extract the model sums of squares into a new data set. How is this done? I can do this the hard way using this code:
%macro repete (new, in=inone);
%do i=2000 %to 5000 %by 5;
data &new; Set &new;
if LeafCa le &i/1000 THEN GROUP=1; ELSE GROUP=2;
PROC Glm outstat=twos;
CLASS GROUP;
MODEL AvgStarchugdivmm2=GROUP SPAD SLAcm2divg LeafP LeafFeppm SoilBufferpH6inch;
%end;
%mend repete;
%repete(one, in=one);
run;
I can then copy and paste the results into Excel, and extract the model SS from there. While slow, I will do that if I must. It is a Cate-Nelson analysis.
Blog post to support the answer from @PaigeMiller:
ODS OUTPUT: Store any statistic created by any SAS procedure
You can use ODS OUTPUT to obtain any statistic from any SAS PROC in a SAS data set.
Blog post to support the answer from @PaigeMiller:
ODS OUTPUT: Store any statistic created by any SAS procedure
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.