About upadhi

upadhi · ‎09-21-2020

hello Greg, I am talking about the logs generated by LSF (LS_TOP/log/) the issue is we do not have any sample logs and client is taking time to give sanitized version of logs. For scanning the logs, we wanted to create a python script, hence asked if some one can help me with the format. So that i can start working on the script. Thanks!

upadhi · ‎09-21-2020

hello All, I have scheduled some SAS codes visa LSF and want to scan the same. i want to know the format and structure of LSF logs. Can anyone please share sample LSF logs generated?

upadhi · ‎09-21-2020

hello, The code is working as expected. However i have some exceptions. eg. reading _ and & as part of want. example: string = "my aim is to find every word after bank_beg.upa_&kok for every bank_beg.&Kok in this line bank_beg.upa_&dd._kok(keep=x)"; want= upa_&kok %kok upa_&dd._kok Basically the delimiters is limite to " ;)" rest all character should be read as part of want.

upadhi · ‎09-17-2020

hi team, i want to extract single word coming before and after dot(.) for example: string : find all words before and after dot.like this; select lib.tab , lib1.tab1; Output: dot.like lib.tab, lib1.tab1 The idea is to extract lib_name.table_name from sas code line

upadhi · ‎09-17-2020

hey. yes we thought so, hence, for now dropping that idea. One last thing here.. can i get the output in below manner: string : find all words before and after dot.like this; select lib.tab , lib1.tab1; Output: dot.like lib.tab, lib1.tab1

upadhi · ‎09-17-2020

Thank you so much for your help. apologies if i am asking too much. but i also need to find out if table we detected was input/output. for example: here for row 1, UPA11 is output table. for row-7, FSK_HEADER is an input table. , row-8, FSK_Scenario is input table and so on is there a possible solution to find this out

upadhi · ‎09-17-2020

I am using SAS 9.4 M5 version. There is a variety of SAS artifacts scheduled- E-miner projects, DI jobs, SAS files etc.

upadhi · ‎09-17-2020

hello Bart, The code works as expected. However, next challenge i faced was, the word i was searching for has an "_" Example: word="bank_beg" string: "my aim is to find every word after bank_beg.upa for every bank_beg.xx in this line bank_beg.ff" The output i get is beg

upadhi · ‎09-17-2020

When scheduled SAS jobs run, which SAS logs are updated. The requirement is we want to scan and understand the CPU time and real time, and tables written by SAS code. and hence would need the SAS logs. my jobs are scheduled. Which logs would be updated from where i can get above info.

upadhi · ‎09-17-2020

string: my aim is to find every word after BANK.upa for every bank.xx in this line bank.ff output: upa xx ff How can i achieve the same

upadhi · ‎09-17-2020

thanks for your reply. ideally i have to scan all procs and data steps. i want something like this: string: my aim is to find every word after BANK.upa for every bank.xx in this line bank.ff output: upa xx ff how can i extract the same

upadhi · ‎09-16-2020

Hi team, I have scanned a SAS code and able to able the proc sql statements in a table for example: Line proc sql; create table x as select * from lib1.tab1 , lib2.tab2 where a=b; create table x as select * from lib1.tab1 left join lib2.tab2 on a=b; quit; Next is i want to extract the library and table names from each of these line items. I understand we would need a recursive code as there can be multiple tables in from. Can anyone help me here

upadhi · ‎09-16-2020

When a user executes a SAS E-Miner project in interactive mode where are the default log output of such an execution generated and placed. Also is just 1 single log file generated for the entire project execution or are multiple logs generated. In case the response to the query varies basis scenarios, can you please help provide some reference scenarios for further understanding. When a user executes a SAS E-Miner Project in scheduled mode where are the default log output of such an execution generated and placed. Also is just 1 single log file generated for the entire project execution or are multiple logs generated. In case the response to the query varies basis scenarios, can you please help provide some reference scenarios for further understanding. Can you please share some sample SAS E-Miner projects

upadhi · ‎09-16-2020

When a user executes a SAS EG project in interactive mode where are the default log output of such an execution generated and placed. Also is just 1 single log file generated for the entire project execution or are multiple logs generated. In case the response to the query varies basis scenarios, can you please help provide some reference scenarios for further understanding. When a user executes a SAS EG Project in scheduled mode where are the default log output of such an execution generated and placed. Also is just 1 single log file generated for the entire project execution or are multiple logs generated. In case the response to the query varies basis scenarios, can you please help provide some reference scenarios for further understanding.

upadhi · ‎09-10-2020

When we deploy any SAS artifact on the SAS grid environment. do we get a keyword or extension to specify that this has been deployed on Grid.

Online Status	Offline
Date Last Visited	3 weeks ago

Re: LSF Logs

LSF Logs

Re: Scan a string to find word after a specific word

Scan first word from left and right after a specific character

Re: Scan a string to find word after a specific word

Re: Scan a string to find word after a specific word

Re: When scheduled SAS jobs run, which SAS logs are updated.

Re: Scan a string to find word after a specific word

When scheduled SAS jobs run, which SAS logs are updated.

Scan a string to find word after a specific word

Re: Scan a string to find word after a specific word

Re: Scan a string to find word after a specific word

Re: Scan a string to find word after a specific word

Glad to be here -- willing to help

Re: How to import report items from a different report in SAS VA 8.2

Additional information section of alert detail window in AML 7.1

Re: Drop down in SAS VA

Re: LSF Logs

LSF Logs

Re: Scan a string to find word after a specific word

Scan first word from left and right after a specific character

Re: Scan a string to find word after a specific word

Re: Scan a string to find word after a specific word

Re: When scheduled SAS jobs run, which SAS logs are updated.

Re: Scan a string to find word after a specific word

When scheduled SAS jobs run, which SAS logs are updated.

Scan a string to find word after a specific word

Re: Scanning of SAS Code to find out input/output tables

Scanning of SAS Code to find out input/output tables

Need some help with regards to identification of Logs.

Need some help with regards to identification of Logs. Need some help ...

Deployment on Grid