SAS for R Users

10Data Output

Output is very important in analysis to show the results of data science to stakeholders. It can primarily be Excel, Powerpoint, and Word documents for data analysis. With the advent of cloud and collaboration tools, there are many ways to communicate the intermediate stages of data analysis. The following shows ways to show output in R and SAS.

10.1 Data Output in SAS

There are two ways:

1. Proc Export‐ Proc Export can export data in many formats

PROC EXPORT DATA= datasetname
      OUTFILE= "location and file name.XLS"
      DBMS=EXCEL REPLACE;
  SHEET="excel worksheet name";
RUN;

Here, replace will replace an earlier file with same name

2. ODS

ODS stands for output delivery system. It is used to format the output of a SAS program. We can output data by putting output print within ODS HTML and ODS HTML CLOSE. Here we output the PROC Means of a dataset to a different object and print it to an excel file.

ODS HTML FILE= '/home/ajay4/sasuser.v94/cars.xls';
Proc means data=mtcars; output out=carsmeans; run;
proc. print data=carsmean; run;
ODS HTML CLOSE;

3. Images

Figure 10.1 Creating plots in SAS.

Output is in the form of an HTML page which can be saved.

Figure 10.2 HTML output plot in SAS.

10.2 Data Output in R

Here we change a working directory ...