Exporting file from SAS

[Jianan_luna]

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

[PaigeMiller]

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.

[Kurt_Bremser]

Maxim 1: Read the Documentation 

[ballardw]

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).