BookmarkSubscribeRSS Feed
camilleanais_a
Calcite | Level 5

I can't put the results of this procedure in a SAS database. Can you please help me ? Thank you.

 

proc glm DATA= &table. plots=none;
   class &target.;
   model &variable.=&target.;
   ods select FitStatistics;
  run; QUIT;

1 REPLY 1
Reeza
Super User

https://blogs.sas.com/content/iml/2017/01/09/ods-output-any-statistic.html

You didn't specify exactly what you want to save and store in a data set. I'm assuming you mean data set, not database, if you want to load this to a DB somewhere this doesn't answer that directly. The blog post above has instructions on saving any table outputted. 

You should also look at the OUTPUT statement on the PROC to see what statistics you can store without having it displayed. 

And the OUTSTAT= option on the PROC statement.

 


@camilleanais_a wrote:

I can't put the results of this procedure in a SAS database. Can you please help me ? Thank you.

 

proc glm DATA= &table. plots=none;
   class &target.;
   model &variable.=&target.;
   ods select FitStatistics;
  run; QUIT;


 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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