Which statement is true regarding the following program?
ods excel file="c:/temp/weather.xlsx";

proc freq data=mydata.weather;
    table RainType;
run;

proc means data=mydata.weather mean sum;
    var Rain Snow;
run;

ods excel close;

Practice More Questions From: Exporting Results

Q:

Which statement is false concerning the options for the PROC EXPORT statement?

Q:

Which statement is true concerning the options for the PROC EXPORT statement?

Q:

Assume you have an existing Excel file sales.xlsx. You would like to export the sales SAS table and overwrite sales.xlsx. Which options must be added to the PROC EXPORT statement? Select all that apply. proc export data=mydata.sales;

Q:

Which PROC EXPORT step contains valid syntax?

Q:

Which PROC EXPORT step contains incorrect syntax?

Q:

Which PROC EXPORT step contains valid syntax?

Q:

What does the following program create? libname sales xlsx ‘c:mydatamidyear.xlsx’;data sales.q1_2018; set sasdata.qtr1_2018;run;data sales.q2_2018; set sasdata.qtr2_2018;run;

Q:

What is the name of the Excel workbook in this program? What does the following program create? libname grades xlsx ‘c:mydatamidyear.xlsx’;proc means data=mydata.school; output out=grades.summary;run;proc freq data=mydata.school; table age / out=grades.ageDist;run;

Q:

Which of the following statements is false regarding exporting data to an Excel workbook?

Q:

The following statement disassociates the data libref. clear data;

Q:

Which statement has correct syntax for disassociating the cars libref?

Q:

Which statement disassociates the sales libref? libname sales xlsx ‘c:mydatamidyear.xlsx’;

Q:

What type of output file does this program create? libname mylib xlsx “s:/workshop/output/test.xlsx”; data class_list; set sashelp.class; run;

Q:

Which of the following statements or options are required to generate an Excel file with the Output Delivery System?

Q:

This program creates a Microsoft Excel XLSX file. libname testxlsx xlsx “s:/workshop/school_data/avg_scores.xlsx”;data class; set sashelp.class;run;

Q:

Which of the following can be used to produce a .xlsx file in a SAS program? Select all that apply.

Q:

Which of these programs creates a Microsoft Excel file?

Q:

Which of the following programs successfully creates an Excel file? Select all that apply.

Q:

Which of the following is not a valid ODS statement?

Q:

Which of the following is not an ODS destination?

Q:

Which of the following is a valid ODS statement? Select all that apply.

Q:

Which statement needs to be added to the end of this program? ods pdf file=’c:tempmyfile.pdf’; proc print data=sashelp.class; run;

Q:

Which statement needs to be added to the end of this program? ods rtf file=’c:tempmyfile.rtf’;proc print data=sashelp.class;run;

Q:

The following program will successfully export the results to PowerPoint. ods file=’c:tempmyfile.pptx’; proc print data=sashelp.class;run; ods powerpoint close;

Q:

Which statements are true regarding this SAS program? Select all that apply. ods csvall file=”c:/temp/survey.csv”;proc print data=data.survey; format Date mmddyy8.;run;ods csvall close;

Q:

Which of the following options in an ODS PDF statement controls the level of the expansion of the table of contents in PDF documents?

Q:

Which statement is false concerning the options for the ODS statement?

Q:

Which statement contains valid syntax for specifying a worksheet name?

Q:

Which statement is true regarding the following program? ods excel file=”c:/temp/weather.xlsx”;proc freq data=mydata.weather; table RainType;run;proc means data=mydata.weather mean sum; var Rain Snow;run;ods excel close;

Q:

Which statement or option will name the worksheet in weather.xlsx as Rain Summary?

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments