03-31-2024
upadhi
Quartz | Level 8
Member since
07-21-2014
- 92 Posts
- 9 Likes Given
- 1 Solutions
- 2 Likes Received
-
Latest posts by upadhi
Subject Views Posted 2126 09-21-2020 12:15 PM 2187 09-21-2020 06:34 AM 3657 09-21-2020 03:56 AM 858 09-17-2020 12:42 PM 3734 09-17-2020 12:19 PM 3770 09-17-2020 08:56 AM 1572 09-17-2020 08:50 AM 3800 09-17-2020 07:42 AM 1630 09-17-2020 04:56 AM 3853 09-17-2020 04:30 AM -
Activity Feed for upadhi
- Posted Re: LSF Logs on Administration and Deployment. 09-21-2020 12:15 PM
- Liked Re: Scan a string to find word after a specific word for Ksharp. 09-21-2020 12:11 PM
- Posted LSF Logs on Administration and Deployment. 09-21-2020 06:34 AM
- Posted Re: Scan a string to find word after a specific word on SAS Programming. 09-21-2020 03:56 AM
- Liked Re: Scan a string to find word after a specific word for ballardw. 09-21-2020 03:52 AM
- Posted Scan first word from left and right after a specific character on SAS Programming. 09-17-2020 12:42 PM
- Posted Re: Scan a string to find word after a specific word on SAS Programming. 09-17-2020 12:19 PM
- Posted Re: Scan a string to find word after a specific word on SAS Programming. 09-17-2020 08:56 AM
- Posted Re: When scheduled SAS jobs run, which SAS logs are updated. on Administration and Deployment. 09-17-2020 08:50 AM
- Liked Re: Scan a string to find word after a specific word for yabwon. 09-17-2020 08:21 AM
- Posted Re: Scan a string to find word after a specific word on SAS Programming. 09-17-2020 07:42 AM
- Posted When scheduled SAS jobs run, which SAS logs are updated. on Administration and Deployment. 09-17-2020 04:56 AM
- Posted Scan a string to find word after a specific word on SAS Programming. 09-17-2020 04:30 AM
- Posted Re: Scanning of SAS Code to find out input/output tables on SAS Programming. 09-17-2020 04:29 AM
- Posted Scanning of SAS Code to find out input/output tables on SAS Programming. 09-16-2020 03:03 PM
- Posted Need some help with regards to identification of Logs. on SAS Data Science. 09-16-2020 11:17 AM
- Posted Need some help with regards to identification of Logs. Need some help with regards to identification on SAS Enterprise Guide. 09-16-2020 11:16 AM
- Posted Deployment on Grid on Administration and Deployment. 09-10-2020 07:39 AM
- Posted LSF Scheduling - EG Projects on Administration and Deployment. 09-10-2020 07:37 AM
- Posted SAS 9 Content Assessment Tool on Administration and Deployment. 09-10-2020 07:35 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 05-22-2019 01:28 AM 1 04-22-2019 06:46 AM
09-21-2020
12:15 PM
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!
... View more
09-21-2020
06:34 AM
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?
... View more
09-21-2020
03:56 AM
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.
... View more
09-17-2020
12:42 PM
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
... View more
09-17-2020
12:19 PM
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
... View more
09-17-2020
08:56 AM
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
... View more
09-17-2020
08:50 AM
I am using SAS 9.4 M5 version.
There is a variety of SAS artifacts scheduled- E-miner projects, DI jobs, SAS files etc.
... View more
09-17-2020
07:42 AM
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
... View more
09-17-2020
04:56 AM
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.
... View more
09-17-2020
04:30 AM
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
... View more
09-17-2020
04:29 AM
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
... View more
09-16-2020
03:03 PM
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
... View more
09-16-2020
11:17 AM
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
... View more
09-16-2020
11:16 AM
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.
... View more
09-10-2020
07:39 AM
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.
... View more