As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Reading job logs

From sasCommunity
Jump to: navigation, search

A Work in Progress

Download the Reading-job-logs.zip file containing minimal documentation: Fehd-reading-job-logs.pdf

Log Header

This log header is written by program SaveLogs.sas; it is available in the .zip on page: http://www.sascommunity.org/wiki/Saving_Job_Information

NOTE: InitStmt processing beginning; file is '!SavePrgrms\SaveLogs.sas'
PASS-INFO FullStimer=10=FULLSTIMER
PASS-INFO DateTime  =0=41D6E5FF58C6A7F0
PASS-INFO Host      =1=RJF2-179107
PASS-INFO SysId     =2=40180
PASS-INFO UserId    =3=RJF2
PASS-INFO SysScpL   =4=XP_PRO
PASS-INFO SysVlong  =5=9.02.01M0P020508
PASS-INFO MemSize   =6=1823623680
PASS-INFO SortSize  =7=67108864
PASS-INFO SumSize   =8=0
PASS-INFO SysIn     =9=C:\SAS-logs\sas-ReadLogs\ReadAltlog-Test.sas #
NOTE: InitStmt processing completed.

Transactions

Composite key:

  • Host char(20),
  • DateTime num format=DATETIME20.2,
  • SysId char(5),
  • UserId char(10),


Jobs

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           2.46 seconds
      user cpu time       0.29 seconds
      system cpu time     0.62 seconds
      Memory                            4325k
      OS Memory                         5368k
      Timestamp            9/10/2008  5:37:41 PM
NOTE: SQL table WORK.JOB was created like:

create table WORK.JOB( bufsize=16384 )
  (
   Host char(20),
   DateTime num format=DATETIME20.2,
   SysId char(5),
   UserId char(10),
   SysScpL char(6),
   MemSize char(20),
   SortSize char(20),
   SumSize char(20),
   SysIn char(80),
   TimeReal num,
   TimeUser num,
   TimeSys num,
   Memory num,
   MemoryOS num
  );

Notes

Contains Errors and Warnings, but not miscellaneous Notes, yet.

See ToDo for Autoexec.

ERROR: Physical file does not exist, C:\SAS-logs\sas-ReadLogs\test-read-many.log.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements. 
This may cause NOTE: No observations in data set.
WARNING: The data set WORK.JOB may be incomplete.  
When this step was stopped there were 0 observations and 14 variables.
309                  describe table Work.Notes;
NOTE: SQL table WORK.NOTES was created like:

create table WORK.NOTES( bufsize=12288 )
  (
   Host char(11),
   DateTime num format=DATETIME20.2,
   SysId char(5),
   UserId char(10),
   LineNmbr num,
   Line char(94)
  );

Reads

NOTE: There were 96 observations read from the data set WORK.PSYCH.;
310                  describe table Work.Reads;
NOTE: SQL table WORK.READS was created like:

create table WORK.READS( bufsize=8192 )
  (
   Host char(11),
   DateTime num format=DATETIME20.2,
   SysId char(5),
   UserId char(10),
   LineNmbr num,
   InData char(42),
   InObs num
  );

Steps

NOTE: The data set LIBRARY.JOBS10SEP08 has 0 observations and 0 variables.
NOTE: PROCEDURE APPEND used (Total process time):
      real time           0.09 seconds
      user cpu time       0.01 seconds
      system cpu time     0.03 seconds
      Memory                            953k
      OS Memory                         5084k
      Timestamp            9/10/2008  5:37:41 PM
308                  describe table Work.Steps;
NOTE: SQL table WORK.STEPS was created like:

create table WORK.STEPS( bufsize=12288 )
  (
   Host char(11),
   DateTime num format=DATETIME20.2,
   SysId char(5),
   UserId char(10),
   LineNmbr num,
   StepNmbr num,
   StepName char(12),
   OutData char(42),
   OutObs num,
   OutVars num,
   TimeReal num,
   TimeUser num,
   TimeSys num,
   Memory num,
   MemoryOS num
  );

Files

implemented on 2008-Sep-12

scan for

  • file
  • filename=
  • fileref=
  • libref

this gets the following

AutoExec

NOTE: AUTOEXEC processing beginning; file is C:\SAS-logs\sas-ReadLogs\autoexec.sas.

note: this could be put in Notes

Filename and FileRef

NOTE: The file "ztest.txt" is:
      Filename=C:\SAS-logs\sas-ReadLogs\ztest.txt,

NOTE: Fileref= TEMPFILE
      Physical Name= C:\SAS-logs\sas-ReadLogs\ztest.txt

Includes

NOTE: %INCLUDE (level 1) file SITEINCL(DeleteFile) is file C:\SAS-logs\includes\deletefile.sas.

Libname

NOTE: Libref LIBRARY was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\SAS-logs\sas7b

but not, yet:

ToDo

Macros

  • Of course!
  • Why Not?!
%macro genvar(colno,var,min,max);
%macro mdo(no,var,min,max);
MPRINT(GENVAR):   data Work.tomtom;
MPRINT(MDO):   do col1=1 to 10;


References

-- created by User:Rjf2 14:58, 11 September 2008 (EDT)

--Ronald_J._Fehd macro.maven == the radical programmer