topic how to export statistics results to an external file in SAS Procedures

how to export statistics results to an external file

littlestone — Fri, 09 Sep 2011 00:59:48 GMT

I am doing some regression. All statistics result was in ouput window. Is it possible to export all those statistics results to an external file (word, html, or plain text)?

how to export statistics results to an external file

art297 — Fri, 09 Sep 2011 01:05:24 GMT

ODS. Take a look at: http://www.nesug.org/proceedings/nesug07/po/po22.pdf

how to export statistics results to an external file

littlestone — Fri, 09 Sep 2011 02:05:14 GMT

thank you. I actually tried to read that paper but it is kind of too complicated for me (i never used ODS before).

Now I just want to output one table, but the code seems to run forever (I waited a long time without any result). where am i wrong ? here is my code:

ODS OUTPUT ASSOCIATION = DATA_ASSOCIATION;

proc logistic data=new descending;

..............

run;

ODS OUTPUT CLOSE;

ODS HTML FILE='C:\Exercise\ASSOCIATION.HTML';

proc print data = data_association;

run;

ODS HTML CLOSE;

how to export statistics results to an external file

art297 — Fri, 09 Sep 2011 02:30:37 GMT

Did the proc logistic run within the expected time? You could have simply stopped there and run your proc print without the additional ods html stuff.

how to export statistics results to an external file

littlestone — Fri, 09 Sep 2011 02:41:39 GMT

the logistic regression runs ok.

weird thing is: only after I terminate sas, i got the html file; i tried several times. it might be something wrong with my sas.

anyway, thank you very much.

how to export statistics results to an external file

art297 — Fri, 09 Sep 2011 02:44:00 GMT

I've never run logistic. Is it possible that it needs a quit statement at the end?

how to export statistics results to an external file

littlestone — Fri, 09 Sep 2011 03:10:45 GMT

no, it doesn't.

It must the problem with ODS on my sas platform.

Thank you very much for your kindness.

how to export statistics results to an external file

littlestone — Fri, 09 Sep 2011 03:38:11 GMT

in case some one get interested:

I tested again: the code is working. I waited about 10 minutes before everything is done. when i looked at log, i got following:

110 ODS HTML FILE='C:\Exercise\ASSOCIATION.HTML';

NOTE: Writing HTML Body file: C:\Exercise\ASSOCIATION.HTML

111 PROC PRINT DATA = DATA_ASSOCIATION;

112 RUN;

NOTE: There were 4 observations read from the data set WORK.DATA_ASSOCIATION.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.14 seconds

cpu time 0.01 seconds

113 ODS HTML CLOSE;

I don't know why it takes 10 minutes; maybe my computer is too old :--)