noderest.blogg.se - R squared global macro management pdf

R SQUARED GLOBAL MACRO MANAGEMENT PDF HOW TO

The same applies to the cValue2 and nValue2 columns. The columns cValue1 and nValue1 represent the same information, except that the cValue1 is a character column whereas nValue1 is a numerical column. The data set also contains columns that contain the raw numerical values and the (formatted) character values of the statistics. The data set contains non-printing columns (like Model and Dependent) that do not appear in the displayed table. Notice that the data set often looks different from the original displayed table. The output from PROC PRINT shows the structure of the output data set. Ods output FitStatistics= Output /* the data set name is 'Output' */ proc reg data=Sashelp.Cars plots=none /* same procedure call */ The data are the 428 vehicles in the Sashelp.Cars data set, which is distributed with SAS: The documentation for the procedure lists all ODS tables that the procedure can create, or you can use the ODS TRACE ON statement to display the table names that are produced by PROC REG. Click To Tweet Find the name of the ODS tableĪs an example, suppose that you intend to use PROC REG to perform a linear regression, and you want to capture the R-square value in a SAS data set.

R SQUARED GLOBAL MACRO MANAGEMENT PDF HOW TO

New to #SAS programming? How to get any statistic into a data set.

Read the data set to obtain the value of the statistic.

Then run the procedure to generate the table.

Use the ODS OUTPUT statement to specify the table name and a data set name.

Use ODS TRACE ON (or the SAS documentation) to find the name of the ODS table that contains the statistic that you want.

The ODS OUTPUT destination answers a common question that is asked by new programmers on SAS discussion forums: "How can I get a statistic into a data set or into a macro variable?" You can then read that value by using a SAS program. The ODS OUTPUT destination enables you to store any value that is produced by any SAS procedure. I cannot overstate the importance of the OUTPUT destination, so let me say it again: The implications of the previous statement are monumental. Consequently, you can programmatically access each element of the output. The OUTPUT destination sends a table or graph to a SAS data set. To a statistical programmer, the most useful destination is the OUTPUT destination. A very basic introduction is Olinger (2000) "ODS for Dummies."

There have been hundreds of papers and books written about ODS. You can control the style and attributes of the output, thus creating a customized report. You can use ODS to send SAS tables and graphics to various output destinations, including HTML, PDF, RTF, and PowerPoint. SAS Output Delivery System (ODS), but the truth is that ODS is a powerful feature of SAS.

The preceding paragraph oversimplifies the Then SAS said, "Let there be ODS," and there was ODS.Ĭustomers saw that ODS was good, and SAS separated the computation from the display and management of output. In the beginning, SAS created procedures and output.