topic Re: get an output in work lib in SAS Programming

get an output in work lib

Antoine44 — Mon, 06 Jul 2020 03:21:04 GMT

Hi everyone,

I'm using the following:

proc reg data = evtrets2;
by evtdate;
model ret1=mktrf smb hml rmw cma umd wti / r cli clm;
run;

After that I get the SAS ouput but instead I'd like to get a table in the work lib, so under explorer and not under results (hope that makes sense).

Could anyone tell me how to do that? I'm guessing I might need to add something in the above code but not sure what.

Let me know if you need clarifications. Thanks for your help!

Tom — Mon, 06 Jul 2020 03:33:05 GMT

First thing is to read the documentation. Do you want the OUTest= option?

Antoine44 — Mon, 06 Jul 2020 04:16:21 GMT

Thank you for that.

From this link: https://support.sas.com/documentation/cdl/en/statug/63033/HTML/default/viewer.htm#statug_reg_sect034.htm
I would you like figure 73.33 as a dataset.

I believe OUTest gives me figure 73.32 only (if I'm not mistaken).

ChrisNZ — Mon, 06 Jul 2020 05:03:35 GMT

If you need to capture procedure outputs, ODS TRACE and ODS OUTPUT are the statements you should get acquainted with. See here for example.

Antoine44 — Mon, 06 Jul 2020 06:25:25 GMT

Ok I'll go through the examples, thanks for that.

On a side note, what's a good way to properly learn how to use SAS? Book, website, etc...

ChrisNZ — Mon, 06 Jul 2020 07:01:34 GMT

> what's a good way to properly learn how to use SAS?

Solve all the problems you have! 🙂

Also, reading all the questions and solutions provided here.

Antoine44 — Tue, 07 Jul 2020 01:17:02 GMT

Alright, thanks 🙂