Perhaps reviewing these two documents will resolve it for you https://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/base_lrconcept_9196.pdf SAS(R) 9.3 Language Reference: Concepts, Second Edition E-13 is in the range where the floating point processor can produce random errors. ... View more

This is a good argument for ditching the common user ID. A lot of SAS sessions will not have this information at all (EGuide can have an overall log turned on).  The unix admin logs may have when each user's SAS session connected to the Oracle server, but that won't tell you exactly who did the action if there were multiple logged on at once. ... View more

JHaque, Not enough information, but you are probably asking this in the wrong place. What you are asking about is how to write a unix shell script and launch it from SAS.  The launching from SAS is easy, use the "x" command (Easy, that is, unless you SAS Admin has disabled it.). How you write your shell scripts is beyond this forum.  Try a unix forum for your flavor of *nix (there are subtle, but often infuriating, differences among them).  You will need to provide them with the name of the shell you are using (probably "bash").  You may also need Perl available for some of the string processing. (I know just enough shell scripting to be dangerous, so I won't attempt a direct answer to your questions.) Doc Muhlbaier Duke ... View more

Efficiently, no. However, if you are looking for estimates, start with a random sample of transaction sets and use PROC COMPARE on the pairwise evolution.  You can output the results and summarize over time.  5,000 sets is probably enough to get a handle on what is happening on average.  If you are searching for the unique or outlier changes, you are stuck with working with the entire dataset. ... View more

for comparing the BMI Categories by sex, you would need PROC FREQ, as that is a 2x3 table. If you scored the BMI categories to get a rank, you could use NPAR1WAY, but it is much less sensitive to differences than the original scale. ... View more

What version of SAS?  We had to update SAS 9.4 to M2 to get the ODBC & SQLSVR to work together. ... View more

Reading Excel via a DATA step is painful and Excel version dependent.  You might have a chance with .xlsx files as they are stored as .xml files. When I have that problem, there are a couple of approaches to take. -- look at the SCANTEXT and TEXTSIZE options in PROC IMPORT.  They may need to be changed to control truncation. -- use SAS Enterprise Guide to read the data.  I fined it a bit more flexible than IMPORT for messy data. ... View more

SAS OnDemand for Academics only supports SAS Studio.  It does not support SAS Enterprise Guide. To get EGuide, you will need a regular SAS license. ... View more

Consider using the CLASS statement for situations like this; it addresses the overspecification issues for you. ... View more

Try this How do I create my own SAS library? ... View more

Venkata, To follow on Jaap's comments.  There are a lot of possible reasons for slow response, many are not related to SAS.  What version of EG (I think that 4.3, 5, and 6 all work with SAS 9.3).  Is the SAS Server local or or running on a different machine?  Are the data local or on a different machine? If the server or data are remote, you are likely to need to get you network people involved in solving this. ... View more