topic Re: Exporting file from SAS in New SAS User

Exporting file from SAS

Jianan_luna — Sat, 11 Jul 2020 21:04:09 GMT

When I learn exporting file from SAS, I have some questions about some statements. Like:

ods noproctitle;

options orientation=landscape;

ods excel file=;

when we add those statement at the beginning of the code. We always need add some statements like:

ods proctitle;

options orientation=portrait;

ods excel close; at the end of program. Why we need to add those statements at end of the program? Thanks so much

Re: Exporting file from SAS

PaigeMiller — Sat, 11 Jul 2020 21:31:45 GMT

You don't have to add the statements at the end of the program.

If there is more to the program (not shown), you might want to (or you might not want to) turn the options back to the other setting, for further use in the progam. That's why they are "options", they are optional, you can set them or not set them as you please.

Re: Exporting file from SAS

Kurt_Bremser — Sun, 12 Jul 2020 05:12:23 GMT

Maxim 1: Read the Documentation

Re: Exporting file from SAS

ballardw — Sun, 12 Jul 2020 15:19:53 GMT

Options, such as Orientation are like car doors. If you open a car door then it stays open until you close it. So options once set remain in effect until until you change them.

The ODS statement sets options related to ODS destinations. The ODS Graphics sets options related to ODS graphics. The Options statement sets options for the system.

Simple concept.

If you need to know more about options in effect at a given part of your program Proc Options can tell you that (read the log).