Module 11: Creating Output with ODS and Exporting Data From SAS

Question 1

What are the 3 main methods of exporting data from SAS programaically?

Answer 1

1) Using ODS
2) In a PROC EXPORT step
3) In a DATA step, using PUT statements

Question 2

Write the general syntax for PROC EXPORT.

Answer 2

proc export data=dataset;
outfile = file-path\file-name.file-type
dbms = deliminator-type
replace;
run;

Question 3

In PROC EXPORT, how do you specify the file extension?

Answer 3

Put the file extension that you want to use in the file name.
Ex. file-path*file-name*.csv

This example specifics a csv is to be explorted

Can also do xlsx, dta, txt, etc.

Question 4

In PROC EXPORT, what does the dbms satement do?

Answer 4

Specifies the type of delimiter to use.

Question 5

T/F: Using the dbms option takes precedence over the file extension when exporting data.

Answer 5

True: Will override the delimiter type normally used in the file extension.

Question 6

T/F: Formats are not exported for delimited files in PROC EXPORT.

Answer 6

False: Formats are exported

Question 7

Explain the lines in the following code.

1) data -null-;
2) set one;
3) file ‘file-path-and-extension’;
4) if -n-=1 then put @01 “EMPID” @10 “GENDER” @20 “RACE;
5) put @01 empid @10 gender @20 race;
run;

Note: - = underscore

This is for tab delimited files

Answer 7

1)Creates an automatic null dataset and is used so no additional datasets are created, only external file
2)Using data from one
3)Creates new file
4)Puts headers for data
5)Creating variable columns starting at line 1, 10, and 20

Note: make sure columns are ‘wide’ enough for header and data

Question 8

Explain the lines in the following code.

1) data -null-; set one;
2) file ‘file-path-and-extension’ dlm = ‘,’;
3) if -n- = 1 then put ‘EMPID’ ‘,’ ‘GENDER’ ‘,’ ‘RACE’ ‘,’;
4) put empid gender race;
run;

Note: - = underscore

This is for comma delimited files

Answer 8

1)Creates automatic null dataset using data from one
2)Creates new file
3)Specifies row 1 as header row, seperated variables by commas
4)specifies the order of data for columns

Question 9

T/F: HTML is the default destination for SAS Studio, the SAS windowing environment, and UNIX.

Answer 9

True

Question 10

Why do we use the ODS TRACE statement?

Answer 10

Helps us find the names of output obejects that can then be used as regular SAS datasets.

Question 11

How do you turn ODS TRACE on and off?

Answer 11

ods trace on;
ods trace off;

Question 12

Write the general code to specify the datasets you want SAS to create in ODS.

Answer 12

ods output output-object = dataset-name;

Question 13

Where do you put the ODS OUTPUT statement in SAS?

Answer 13

Ex. proc glm data=one;
by flsa;
class eeogroup;
model = specified-model;
ods output output-object = dataset;
run;

After proc statement, but before next run, proc , or data statement

Question 14

Explain the lines in the following code.

1) ods csv file= ‘file-path\filename.csv’;
2) proc print data=allresults noobs;
3) title1 ‘model output’;
run;
4) ods csv close;

Answer 14

1) creates exporting path and filename, specifying its a csv
2) specifies what to put in new file, excluding observation numbers
3) Creates a title for file
4) closes csv file.

Question 15

T/F: ODS output is created in the windowing mode.

Answer 15

False: Writes in an output window