224 SASTRACELOC= System Option Chapter 11
Output 11.2 SAS Log Output from the SASTRACE= and SASTRACELOC= System Options
50 data work.winter_birthdays;
51 input empid birthdat date9. lastname $18.;
52 format birthdat date9.;
53 datalines;
NOTE: The data set WORK.WINTER_BIRTHDAYS has 3 observations and 3 variables.
NOTE: DATA statement used:
real time 0.08 seconds
cpu time 0.03 seconds
...
57 ;
58 run;
59
60 libname mydblib oracle user=testuser password=XXXXX schema=bday_dat;
NOTE: Libref MYDBLIB was successfully assigned as follows:
Engine: Oracle
Physical Name:
61
62 options sastrace=’,,,d’ sastraceloc=saslog;
63 data mydblib.snow_birthdays;
64 set work.winter_birthdays;
65 run;
DEBUG: Open Cursor - CDA=2060054152 49 923702189 orusti 296 DATASTEP
DEBUG: PREPARE SQL statement: 50 923702189 orprep 63 DATASTEP
SELECT * FROM SNOW_BIRTHDAYS 51 923702189 orprep 64 DATASTEP
DEBUG: Close Cursor - CDA=2060054152 52 923702189 orustt 365 DATASTEP
DEBUG: PHYSICAL connect. 53 923702190 orcon 372 DATASTEP
DEBUG: USER=testuser 54 923702190 orcon 373 DATASTEP
DEBUG: Open Cursor - CDA=2057325192 55 923702190 orusti 296 DATASTEP
DEBUG: Open Cursor - CDA=2057332360 56 923702190 orusti 296 DATASTEP
NOTE: SAS variable labels, formats, and lengths are not written to DBMS
tables.
DEBUG: EXECUTE SQL statement: 57 923702190 orexec 75 DATASTEP
CREATE TABLE SNOW_BIRTHDAYS(empid NUMBER ,birthdat DATE,lastname VARCHAR2
(18)) 58 923702190 orexec 76 DATASTEP
DEBUG: PREPARE SQL statement: 59 923702190 orins 330 DATASTEP
INSERT INTO SNOW_BIRTHDAYS (empid,birthdat,lastname) VALUES
(:empid,TO_DATE(:birthdat,’DDMONYYYY’,’NLS_DATE_LANGUAGE=American’),:lastnam
e) 60 923702190 orins 331 DATASTEP
NOTE: There were 3 observations read from the dataset WORK.WINTER_BIRTHDAYS.
DEBUG: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* 61 923702190 orforc 102 DATASTEP
NOTE: The data set MYDBLIB.SNOW_BIRTHDAYS has 3 observations and 3
variables.
DEBUG: *-*-*-*-*-*-* COMMIT *-*-*-*-*-*-* 62 923702190 orforc 102 DATASTEP
DEBUG: Close Cursor - CDA=2057325192 63 923702190 orustt 365 DATASTEP
DEBUG: Close Cursor - CDA=2057332360 64 923702190 orustt 365 DATASTEP
DEBUG: PHYSICAL disconnect. 65 923702190 ordcon 445 DATASTEP
DEBUG: USER=testuser 66 923702191 ordcon 446 DATASTEP
NOTE: DATA statement used:
real time 1.30 seconds
cpu time 0.18 seconds
SASTRACELOC= System Option
Prints SASTRACE information to a specified location
Valid in: OPTIONS statement, configuration file, SAS invocation
Default value: stdout
