Below is a description of very useful options in SAS, if you want a look “behind the scenes” and see what SAS actually does when processing data.
options fullstimer sastrace=(,,,d) sastraceloc=saslog mprint source2 nostsuffix;
|fullstimer||The SAS System provides the FULLSTIMER option to collect performance statistics on each SAS step, and for the job as a whole and place them in the SAS log. It is important to note that the FULLSTIMER measures only give you a snapshot view of performance at the step and job level.|
|sastrace=(,,,d)||Generates trace information from a DBMS engine.
‘,,,d’ specifies that all SQL statements that are sent to the DBMS are sent to the log. Here are the applicable statements:
|sastraceloc=saslog||Prints SASTRACE information to a specified location.
In this case the log in SAS.
|mprint||Specifies whether SAS statements generated by macro execution are traced for debugging.|
|source2||Specifies whether SAS writes secondary source statements from included files to the SAS log.
SOURCE2 specifies to write to the SAS log secondary source statements from files that have been included by %INCLUDE statements.
|nostsuffix||The NOSTSUFFIX system option suppresses printing or display of trailing SASTRACE information and makes the SASTRACE log easier to read.|