Hello everyone. As I am new to SAS, therefore I’m not sure if SAS able to produce a specific information to external file. The client that I work with requested me to produce a log file of each DI Job which contain <Job name>,<start time>,<end time>,<job status>,<error code>,<error description> The other requirement is to produce log file at specific folder and with specific file name format e.g.: LOG_<DDMMMYYYY>.txt So far what I’ve done is; I add in below code in every transformation item that I use in my job %let fileDate = %sysfunc(date(),DATE9.) ; filename genfile "\\Exception\Log_&fileDate..txt"; /* Output Text File */ data _null_ ; /* No SAS data set is created */ FILE genfile mod; PUT "1_SIT_FL_FACT_GPA,&etls_stepStartTime,& etls_endTime ,&syserr,&syscc,"; run ; is there any other way to do this?? appreciate if anyone can help me on this... thanks in advanced. regards baizura
... View more