About Saurabh13

Saurabh13 · ‎05-30-2017

I need to use proc Printto only. Because same process runs for various scenarios parallely . So in that case by default log would overwritten. So i din check without Proc Printto.

Saurabh13 · ‎05-30-2017

I am facing a weird problem. I have sas program like that. Proc printto log = "path" new; run; signon s1 server details; rsubmit statements; Break input dataset of 20 millions records into 4 datasets in 4 threads. and addithional processing. endrsubmit; signoff ; wait forall threeads; data Final; set ds1 ds2 ds3 ds4; run; Program is executing fine without errors. But the logs are not in sequence as the statement executes. Some part of thread 1 then thread 2 and thred 1 again like this. Is there any option to arrange the log into the thread sequqnce. Please suggest.

Saurabh13 · ‎05-15-2017

Use %do%while loop witth %scan function. It's very easy.

Saurabh13 · ‎05-09-2017

Tried but in 2 steps. data x_wo_step(keep= text ds_name ds_count real_time ) w_step(keep=ds_name step_used); infile inn truncover end=eof; input text $1000. ; retain ds_name ds_count ; if indexw(text,"NOTE: The data set") eq 1 then do; ds_name = scan(text,5," "); ds_count = scan(text,7," "); output x_wo_step; end; else if indexw(text,"NOTE: Table") eq 1 then do; ds_name = scan(text,3," "); ds_count = scan(text,6," "); output x_wo_step; end; else if indexw(text,'real') eq 1 then do; real_time = scan(text,3," "); output x_wo_step; end; else if indexw(text,'used') gt 1 then do; step_used = scan(text,2," ")||""|| scan(text,3," "); /*--It's data/proc step --*/ output w_step; end; else do; delete; end; run; data x_wo_step_1; set x_wo_step; if real_time eq '' then delete; run; data Final_stats(drop=text); merge x_wo_step_1(in=a) w_step(in=b); by ds_name; run;

Saurabh13 · ‎05-09-2017

25 data A; 26 s=2; 27 run; NOTE: The data set WORK.A has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 765.00k OS Memory 18340.00k Timestamp 05/09/2017 12:41:45 AM Step Count 2 Switch Count 29 Page Faults 0 Page Reclaims 425 Page Swaps 0 Voluntary Context Switches 67 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 304 28 29 data B; 30 set A; 31 x=3; 32 run; NOTE: There were 1 observations read from the data set WORK.A. NOTE: The data set WORK.B has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds 2 The SAS System 00:41 Tuesday, May 9, 2017 system cpu time 0.00 seconds memory 1030.53k OS Memory 18600.00k Timestamp 05/09/2017 12:41:45 AM Step Count 3 Switch Count 39 Page Faults 0 Page Reclaims 314 Page Swaps 0 Voluntary Context Switches 92 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 320 33 34 proc sql; 35 create table XYZ as select * from B; NOTE: Table WORK.XYZ created, with 1 rows and 2 columns. 36 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 5419.12k OS Memory 23464.00k Timestamp 05/09/2017 12:41:45 AM Step Count 4 Switch Count 29 Page Faults 0 Page Reclaims 149 Page Swaps 0 Voluntary Context Switches 67 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 304

Saurabh13 · ‎05-09-2017

I have a sas log . For example : NOTE: The data set WORK.A has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds user cpu time 0.01 seconds system cpu time 0.01 seconds memory 764.06k OS Memory 18596.00k Timestamp 05/08/2017 11:26:34 PM Step Count 6 Switch Count 30 Page Faults 0 Page Reclaims 351 Page Swaps 0 Voluntary Context Switches 73 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 312 28 29 data B; 30 set A; 31 x=3; 32 run; NOTE: There were 1 observations read from the data set WORK.A. NOTE: The data set WORK.B has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds 2 The SAS System 23:11 Monday, May 8, 2017 system cpu time 0.00 seconds memory 1032.62k OS Memory 18856.00k Timestamp 05/08/2017 11:26:34 PM Step Count 7 Switch Count 40 Page Faults 0 Page Reclaims 297 Page Swaps 0 Voluntary Context Switches 111 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 328 33 34 proc sql; 35 create table XYZ as select * from B; NOTE: Table WORK.XYZ created, with 1 rows and 2 columns. 36 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds After Each data step or Proc step there is statistics of real time and CPU time. I want to parse and create dataset which will have dataset name and real time . Like Table Time records Work.A 0.01 1 Work.B 0.00 1 Work.XYZ 0.00 1 I am trying like this but not able to capture Table /dataset name . filename in "log_path"; data x; infile inn missover truncover; input text $1000. ; b=strip(text); x=compress(text); c=substr(x,1,8); zz=compress(x,'realtime'); if text eq '' then delete; if c='realtime'; run; could someone please help ? Thanks,

Saurabh13 · ‎11-02-2016

Thanks for the explanation . I have also read some documents about the hash.

Saurabh13 · ‎11-02-2016

Thanks a lot for the reply and solution. I have never used hashing in SAS so could you please explain a little about the soultion. 1. In second hash you have kept only key so that we can search from this key. 2. could you please explain about 3rd and 4th hash ? Why are they created ? 3. all.definekey('n'); what is n here ? 4. please explain about do while loop which i think is most important piece in the solution? I also want to learn so could you please explain a bit that would be great for me and my learning .

Saurabh13 · ‎11-01-2016

Hi, Flag is there for stop criteria. I need to stop where child has no same parent and FLAG ='Y' . Yes, Its a deep first algo.

Saurabh13 · ‎11-01-2016

I have a simple problem . My dataset has 3 column Child , Parent, Flag I need to search the child into the parent column and check the flag if flag is N ( New node) or Z we need to again check the child of that parent and continue till we don't get the parent of the child and flag='Y'. child parent flag 1 . I 2 1 Z 3 1 Z 4 2 N 5 4 Z 6 4 Z 7 4 Z 8 3 N 9 8 Z 10 8 Z 11 10 N 12 11 Z 13 11 Z 14 13 N 15 14 Z 16 14 Z 17 12 N 18 17 Z 19 17 Z 20 18 N 21 20 Z 22 20 Z 23 19 N 24 23 Z 25 23 Z 36 5 Y 37 6 Y 38 7 Y 39 9 Y 40 21 Y 41 22 Y 42 24 Y 43 25 Y 44 15 Y 45 16 Y My macro variable list should be generated as : Tree_List = 1, 2, 4, 5, 36, 6, 37, 7, 38, 3, 8, 9, 39, 10, 11, 12, 17, 18, 20, 21, 40, 22, 41, 19, 23, 24, 42, 25, 43, 13, 14, 15, 44, 16, 45 Am not able to get the idea how to start coding . Any help would be great help for me. Thanks.

Online Status	Offline
Date Last Visited	‎05-30-2017 06:50 PM

Re: Multi-threads statements log is not in sequence.

Multi-threads statements log is not in sequence.

Re: compare a macro variable with macro variable list

Re: Parse SAS Log file

Re: Parse SAS Log file

Parse SAS Log file

Re: Generate a list of macro variable .

Re: Generate a list of macro variable .

Re: Generate a list of macro variable .

Generate a list of macro variable .

Re: Generate a list of macro variable .

Re: Multi-threads statements log is not in sequence.

Multi-threads statements log is not in sequence.

Re: compare a macro variable with macro variable list

Re: Parse SAS Log file

Re: Parse SAS Log file

Parse SAS Log file

Re: Generate a list of macro variable .

Re: Generate a list of macro variable .

Re: Generate a list of macro variable .

Generate a list of macro variable .