Please find the details. I am invoking SAS on Unix Environment. We are using ODBC for connecting to BQ . tgt - > our Unix directory path . It has enough space to store data. bq-> libref to the BQ path.   /*25k observations read succesfully both fully and partially*/    5? Data tgt.n_25k; set bq.N_25;run; NOTE: There were 25000 observations read from the data set       BQ.RAW_CDU_CDU060_CUSTCUSTRELN_25. NOTE: The data set TGT.N_25K has 25000 observations and 14 variables. NOTE: DATA statement used (Total process time):       real time           14.98 seconds       cpu time            3.53 seconds /*50k observations read succesfully both fully and partially*/   6? Data tgt.n_50k; set bq.N_50 ;run; NOTE: There were 50000 observations read from the data set       BQ.RAW_CDU_CDU060_CUSTCUSTRELN_50. NOTE: The data set TGT.N_50K has 50000 observations and 14 variables. NOTE: DATA statement used (Total process time):       real time           27.94 seconds       cpu time            6.70 seconds /*0.1 million observations read succesfully both fully and partially*/     7? Data tgt.n_01m; set bq.N_01M ;run; NOTE: There were 100000 observations read from the data set       BQ.RAW_CDU_CDU060_CUSTCUSTRELN_01M. NOTE: The data set TGT.N_01M has 100000 observations and 14 variables. NOTE: DATA statement used (Total process time):       real time           56.67 seconds       cpu time            13.03 seconds   /*0.5 million observations read succesfully fully but NOT PARTIALLY */     4?  Data tgt.n_05m  ; set bq.RAW_CDU_CDU060_CUSTCUSTRELN_05M ;run; NOTE: There were 500000 observations read from the data set       BQ.RAW_CDU_CDU060_CUSTCUSTRELN_05M. NOTE: The data set TGT.N_05M has 500000 observations and 14 variables. NOTE: DATA statement used (Total process time):       real time           3:39.75       cpu time            1:02.70        options fullstimer nostsuffix sastrace=',,,d' sastraceloc=saslog ;    17? Data tgt.n_05m;set bq.N_05M (obs=5);run; ODBC_1: Prepared: on connection 0 SELECT * FROM GCP.N_05M                       /* GCP is schema name here*/ ODBC_2: Executed: on connection 0 Prepared statement ODBC_1 NOTE: There were 5 observations read from the data set       BQ.N_05M.System Aborting Status=803fc21e   Control comes out of SAS session to Unix prompt. at the backend we see that lck file remains.   ---------------------------     Please advise further.   ... View more

Thank you @JuanS_OCS . I shall seek advice from SAS Tech. ... View more

Thank you @JuanS_OCS for your quick response. I will initially work with our monitoring team to develop this idea further.   -Mark ... View more

The above did not work. This time we get error the table cannot be found. Pls help ... View more

Hi Timmy, thanks for responding. We use Platform Process Manager . I need to get it from metadata itself. I am trying to find the way as we need a report for audit purpose. ... View more

I have abt 30 flows and am looking at about 900 deployed jobs in all of them.Yes,9.4 is still not live. We do not want to redo the whole thing again - its too much !.  It is because, after we export to 9.4, there is a need to check and realign the timeevent in every flow to that of the new env which takes time.   So, if not a manual process of checking almost every job; I want to come up with a program for this detail which infact can be very useful to check if the latest version of codes are present in both the environments at any point of time.  I am trying to find my luck if one of the macros contain the sas file name detail as well somewhere in them. Its just that we need to dig them out. ... View more