SAS Output Delivery System

In the previous topic, we have learned how to use SQL queries in the data set to create, read, update, and delete table values. Now, in this topic, we are going to learn what SAS ODS- Output Delivery System is and how we can create various types of output files.

SAS Output Delivery System is used to convert the output of the SAS program into more user-friendly forms like HTML, PDF, etc. We can do that by using the ODS (Output Delivery System) statement, which is available in the SAS software.

It is preferred to format output of the SAS program for useful reports which are suitable for viewing and understanding. It also helps in sharing the output with other platforms and software goods and combines the results of multiple PROC statements in a single file.

Syntax:

ODS outputtype
PATH path name
FILE = Filename and Path
STYLE = StyleName
;
PROC some proc
;
ODS outputtype CLOSE;

Where,

PATH: It is a statement which is used to convert SAS program output into the HTML form. For other forms, we use the filename instead of the pathname.

Style: It represents the in-built styles available in the SAS environment.

We can create three types of files as output in the SAS:

HTML File Output
PDF File Output
RTF or Word File Output

Creating HTML Output

We can create an HTML file as output when we need to send the output on the web. SAS provides the ODS HTML statement to create an HTML file as an output of the SAS program. In the example, we are going to create an HTML file in our desired path. We are applying style EGDefault, which is already available in the styles library.

ODS HTML 
   PATH = '/folders/myfolders/sasuser.v94/JavaTpoint/'
   FILE = 'CARS2.html'
   STYLE = EGDefault;
proc SQL;
select make, model, invoice 
from sashelp.cars
where make in ('Audi','BMW')
and type = 'Sports'
;
quit;

proc SQL;
select make,mean(horsepower)as meanhp
from sashelp.cars
where make in ('Audi','BMW')
group by make;
quit;
ODS HTML CLOSE;

After executing the above code in SAS Studio, the output file as HTML will be generated in a mentioned path. We can download this HTML file to save it in a different environment from the SAS.

Please note that we used two PROC SQL Statement in the code; it doesn't mean that their output will be captured in two separate files; it will be captured in the same file.

Output:

Creating PDF Output

SAS provides the ODS PDF statement to create a PDF file as an output of the SAS program. In the example, we are going to create a PDF file in our desired path. We are applying style EGDefault, which is already available in the styles library.

ODS PDF 
   FILE = '/folders/myfolders/sasuser.v94/javaTpoint/CARS2.pdf'
   STYLE = EGDefault;
proc SQL;
select make, model, invoice 
from sashelp.cars
where make in ('Audi','BMW')
and type = 'Sports'
;
quit;

proc SQL;
select make,mean(horsepower)as meanhp
from sashelp.cars
where make in ('Audi','BMW')
group by make;
quit;
ODS PDF CLOSE;

After executing the above code in SAS Studio, the output will be generated as a PDF file in a mentioned path. We can download this PDF file to save it in a different environment from the SAS.

Please note that we used two PROC SQL Statement in the code; it doesn't mean that their output will be captured in two separate files; it will be captured in the same file.

Output:

Creating RTF (Word) Output

SAS provides the ODS RTF statement to create an RTF file as an output of the SAS program. In the example, we are going to create an RTF file in our desired path. We are applying style EGDefault, which is already available in the styles library.

ODS RTF 
FILE = '/folders/myfolders/sasuser.v94/TutorialsPoint/CARS.rtf'
STYLE = EGDefault;
proc SQL;
select make, model, invoice 
from sashelp.cars
where make in ('Audi','BMW')
and type = 'Sports'
;
quit;

proc SQL;
select make,mean(horsepower)as meanhp
from sashelp.cars
where make in ('Audi','BMW')
group by make;
quit;
ODS RTF CLOSE;

After executing the above code in SAS Studio, the output will be generated as an RTF file in a mentioned path. We can download this RTF file to save it in a different environment from the SAS.

Please note that we used two PROC SQL Statement in the code; it doesn't mean that their output will be captured in two separate files; it will be captured in the same file.

Output: