A SEARCH on the SAS support website http://support.sas.com/ yielded several DOC and technical paper hits to consider. You may also find that the SAS 9.2 DOC has some applicability on this topic, even though you may be running an earlier SAS version (consider the link below). Also, a Google advanced search using the argument below was quite fruitful with gems to review: optimize oracle performance site:sas.com Also, keep aware of SAS HOTFIX maintenance, given the SAS support problem note listed below. Scott Barry SBBWorks, Inc. SAS/ACCESS for Oracle: Maximizing Oracle Performance http://support.sas.com/documentation/cdl/en/acreldb/59618/HTML/default/a003113611.htm Problem Note 20712: Decreased performance might occur when you use bulk loading in SAS/ACCESS® Interface to Oracle http://support.sas.com/kb/20/712.html ... View more

Subtract 10 years with the following constant generated using the SAS MDY function, which creates a SAS-internal number representing 10 years, given that 1/1/1960 is a value of 0: MDY(1,1,1970) Scott Barry SBBWorks, Inc. ... View more

There are several sample code examples at the SAS support website http://support.sas.com/ when using either website's SEARCH facility or with using the example Google advanced search argument listed below: drop variables all missing values site:sas.com Scott Barry SBBWorks, Inc. ... View more

I found this document (link below) on the SAS support website http://support.sas.com/ using the SEARCH facility. You may also want to involve your site's SAS System Administrator for guidance. Scott Barry SBBWorks, Inc. Diagnosing SAS® Enterprise Guide® Connectivity Problems Using the SAS Integration Technologies Utility http://support.sas.com/techsup/technote/ts790.pdf ... View more

SAS support website http://support.sas.com/ has a specific problem note I found using the SEARCH facility on their website - title/link provided below. Scott Barry SBBWorks, Inc. Problem Note 32003: Text searches return different results in PDF files created by ODS PDF http://support.sas.com/kb/32/003.html ... View more

The SAS support website http://support.sas.com/ has both SAS-hosted documentation and also supplemental technical papers and Sample Programs, one of which I found with using the website's SEARCH facility. A link to this paper is listed below. Scott Barry SBBWorks, Inc. Sample 33918: Read and convert multiple transport (XPORT) files to SAS data sets http://support.sas.com/kb/33/918.html BONUS ITEM: Sample Google advanced search argument - limited to the SAS.COM website: +read +multiple +transport +files site:sas.com ... View more

Another Google advanced search argument opportunity listed below - found several related documents on the topic: sort swapping performance memsize site:sas.com Also, suggest you create a new post for each new query / question / problem. Scott Barry SBBWorks, Inc. ... View more

Not sure if it applies to your problem specifically, but there is a SAS HOTFIX E9D213 which may address your error. Also, the SAS support website http://support.sas.com/ contains useful supplemental reference material and SAS-hosted DOCUMENTATION. Using the SEARCH facility, I found a topic-related technical document (see link below) which also may be useful. Scott Barry SBBWorks, Inc. SAS/ACCESS® 9.1.x Interface to DB2 on the Mainframe Using the LIBNAME Engine http://support.sas.com/resources/papers/accessdb2.pdf ... View more

A few options to gain some technical reference items: 1) a Google advanced search below, strictly against the SAS.COM domain/website: +REALMEMSIZE site:sas.com 2) the SAS support website http://support.sas.com/ and its SEARCH facility - you will find SAS-hosted DOC and additional technical reference information on the topic. Scott Barry SBBWorks, Inc. ... View more

One option is to enclose your %LET SC = assignment statement with %STR( ) -- rather than on the macro invocation statement. Scott Barry ... View more

An approach I used frequently is to drive a macro execution with a DATA step and CALL EXECUTE. An oversimplified example: %MACRO X(VALUE); %PUT >INFO> MACRO X INVOKED WITH VALUE: &VALUE; %MEND X; DATA _NULL_; DO I=1 TO 41; IF I IN (1,15) OR (18 LE I LE 40) THEN CONTINUE; CALL EXECUTE('%X(' !! I !! ')'); END; RUN; As has been conveyed, the %IF / %END is not equal to the DO / END behavior and syntax within the SAS language, and so there are ways to work within the current system. Scott Barry SBBWorks, Inc. ... View more

With the 2nd code example, the LEAVE "statement" (not variable) will allow you to exit the two nested DO loops immediately, once you have an assigned value for your current observation. The implied understanding is that you are inputting and outputting once per observation. Using the PUTLOG with a suffix, allows you to code multiple PUTs (or PUTLOGs) and know which is being executed with you are displaying _ALL_ variables to the log. I would expect you need to analyze the processing both inside and outside the DO loops to totally understand what's going on in your DATA step. Scott Barry SBBWorks, Inc. Sample "very simplified" SAS program to demonstrate using PUTLOG for diagnosis: OPTIONS SOURCE SOURCE2 MACROGEN SYMBOLGEN MLOGIC; DATA _NULL_; DO I=1 TO 10; PUTLOG '>DIAG-01' / _ALL_; DO J=1 TO 3; IF J = 2 THEN PUTLOG '>DIAG-02' / _ALL_; END; END; PUTLOG '>DIAG-99' / _ALL_; RUN; ... View more

Your interior DO / END loop is executing 9 times, regardless of the fact that you have assigned your new variable. I would suggest setting one of the following: 1) use the LEAVE statement to exit your DO loops, when appropriate. 2) assign both of your DO/END looping variables when you want to continue / iterate to the next observations, using the DIM(i) function in your assignment statement (better than assigning an explicit max value). Also, adding some PUTLOG " " / _ALL_; statements will help you see the processing -- consider setting up multiple PUTLOGs and use a unique "nn" value for each distinct statement, for easier identification. Scott Barry SBBWorks, Inc. ... View more

Also, consider sending a post-reply with a DATA step that creates an example WORK.TRIAL1 SAS file, using instream DATALINES and an INPUT statement. That way you keep focus on the forum subscribers by submitting "sample data" for your original post. Scott Barry SBBWorks, Inc. ... View more