Hi SAS expert team, I have scheduled a job (hourly) from a sas program to create new library and new table. This job ran successfully even when i'm not login sas, and after this job ran successfully, I login sas and cannot see the new library (CE_DATA)/newtable which should be created by the sas program. Can anyone please explain to me what's wrong here? Many thanks. For more information, this sas program is simply a code to: create new library 'CE_DATA' create connection to oracle create new table from sql/oracle database and then do some transpose, left join as below: /*Get data CAR credit rating from oracle*/ proc sql; libname CE_DATA "%sysfunc(pathname(work))"; connect to oracle as myconn (user="" password="" encoding="UTF8" path=''); create table CE_DATA.newtable as select * from connection to myconn ( select b.carid, b.borrowercustomercode, b.attribute, b.value from (select a.* , row_number() over (partition by a.carid order by a.carid,a.decisionid desc) row_num from app_ce_dh.dm_output_decision_history a) b where 1=1 and row_num <=32 and carid like 'CAR%' and attributegroup in ('MODEL_RESULT','DECISION') ) ; disconnect from myconn; proc transpose data=CE_DATA.newtable out=CE_DATA.newtable2; by CARID BORROWERCUSTOMERCODE ; id ATTRIBUTE ; var VALUE ; run; /*Get status of CAR from app_mhrr */ proc sql; connect to oracle as myconn (user="" password="" encoding="UTF8" path=''); create table CE_DATA.trangthai as select * from connection to myconn ( select a.application_id, a.appl_status,a.Day_id,b.finalstatus from app_mhrr.rf_dim_app_process a Left join (select application_id,max(day_id) as finalstatus from app_mhrr.rf_dim_app_process group by application_id) b on a.application_id = b.application_id and a.day_ID = b.finalstatus where b.finalstatus is not null and a.application_id like 'CAR%' group by a.application_id, a.appl_status,a.day_id,b.finalstatus ) ; disconnect from myconn; /*left join status of CAR*/ proc sql; create table final_table as select * from newtable2 as x left join trangthai as y on x.carid = y.application_id; quit; I ran this sas program mannually (without job schedule) and it is completed successfully, and then I saw the library and the table that I want like this screen:     ... View more

Hi - I'm trying to create new table with proc sql as below (I take it from sas guideline: https://documentation.sas.com/doc/ja/vdmmlcdc/8.1/sqlproc/n1ncn0pznd8wrln1tnp3xdxjz9xz.htm ) The query run successfully without no error, but when I refresh the libname 'proclib' created in the code, it keeps refreshing and hasn't stopped for 3-4 hours. Can someone please explain me what's wrong here? Many thanks Code:   libname proclib 'SAS-library'; proc sql; create table proclib.paylist (IdNum char(4), Gender char(1), Jobcode char(3), Salary num, Birth num informat=date7. format=date7., Hired num informat=date7. format=date7.); insert into proclib.paylist values('1639','F','TA1',42260,'26JUN70'd,'28JAN91'd) values('1065','M','ME3',38090,'26JAN54'd,'07JAN92'd) values('1400','M','ME1',29769.'05NOV67'd,'16OCT90'd) values('1561','M',null,36514,'30NOV63'd,'07OCT87'd) values('1221','F','FA3',.,'22SEP63'd,'04OCT94'd); title 'Proclib.Paylist Table'; select * from proclib.paylist; proc printto; run; The 'proclib' keeps refreshing:     ... View more