If you want to pass a hint to Oracle, via SQL pass-through, you need to explicity state it in the your Oracle connect statement.
If you need to integrate the ability to compress and archive files as part fo your sas code, this paper from the SAS Global Forum 2007 may help.
Stephen Hunt, SAS Golbal Foum 2007, 005-2007
Among the plethora of non-programming tasks frequently required of SAS® users is the manual compression/loadingof assorted SAS programs, logs, and output files for transfer or archival purposes. The Windows™ application most frequently recruited for this task is Winzip®. Unfortunately for SAS programmers, who are accustomed to manipulating data via a keyboard-driven programming interface, the point-and-click front-end of the Winzip application generally represents a bottleneck in the smooth flow of program development--> execution--> delivery.
This paper builds on the documented list of command-line options associated with the WinZip32 executable file and demonstrates several ways in which the adventurous programmer can operate this application in a SAS programming environment to avoid the manual tedium involved in the typical use of this popular utility.
Zipping Right Along: Push-Button SAS® Transfers via Command-Line Invocation of the WinZip32 Executab
SAS functions enable you to add powerful logic to your SAS code.
According to the SAS Online Documentation, SAS functions are defined as:
“A SAS function performs a computation or system manipulation on arguments and returns a value. Most functions use arguments supplied by the user, but a few obtain their arguments from the operating environment.”
You can see details on what SAS functions are and how they can be used at SAS Functions and Call Routines overview online documentation page.
You can also see a complete list of the functions available at the SAS Functions and Call Routines Dictionary online documentation page.
Relevant SAS Forum Papers
If you ever want to know what is licensed on a SAS server you can run this little bit of code:
proc setinit;
run;
All SAS programs consist of a sequence of "steps". There
are only two kinds of steps:
- Data Step
- PROC Step
