About bob021

bob021 · ‎05-03-2011

Hi Ksharp. Thank you for your respond. I will try to explain better. name no no2 A 20 50 A 30 80 A 60 B 20 30 B 40 50 C 20 50 C 60 80 C 70 name no no2 A 20,30 50 A 60 80 B 20 30 B 40 50 C 20 50 C 60,70 80 Every ‘name’ (A,B,C) go thought the process :‘no’ and getting there number (20,30,40,50....) and then go to the next level ‘no2’ where also getting a number (for 10,20,30 larger then at ‘no’). This process can be repeated several times. My problem is when one ‘name’ (in this case A) goes to ‘no’ twice (or more) in row (20,30) and after that to ‘no2’(50).What I want is to merge cell column ‘no’ in case like that. Only way how to determinate this is to count 20, 30 in ‘no’ and stop when find first next in ‘no2’ (50)means that A was twice in a row at ‘no’. In B process is correct 40 – 50 60 – 70 In C fist is ok but after first ‘no2’ C goes twice thought the ‘no’ and then again to ‘no2’ Thank you in advance.

bob021 · ‎05-02-2011

Hi DBailey / ballardw Thank you very much for answers. I get this results after left join two tables on name=name and CNT=CNT(first: name,no,code, cnt; second: : name,no2,code2, cnt ). If you take a look at fist two rows in result (A) you will see that no 20 and 30 are merged as well as code sc2000,sc6000. Reason for merging is because ‘code’ 20 and 30 are less than first next ‘code2’.(50) and I want to get ascending order. It could be more than two ‘no’ and ‘code’ for merging. Is it possible to write such query? Or to get result like this in left join step: A 20 sc2000 1 A 30 sc6000 2 50 TT2000 A 60 sc2000 3 80 TT0000 B 20 sc2000 1 30 TT2000 B 40 sc2000 2 50 TT0000 C 20 sc2000 1 50 TT2000 C 60 sc2000 2 C 70 sc3000 3 80 TT0000 In that case I can’t use CNT for left join. Or it is easier to merge cell after append second tab table to first and order by ‘name’ and ‘no’ (merge all ‘no’ and ‘code’ until code start with TT?) I don’t know is something like that possible. A 20 sc2000 1 A 30 sc6000 2 A 50 TT2000 A 60 sc2000 3 A 80 TT0000 B 20 sc2000 1 B 30 TT2000 B 40 sc2000 2 B 50 TT0000 C 20 sc2000 1 C 50 TT2000 C 60 sc2000 2 C 70 sc3000 3 C 80 TT0000 Then I can separate table, count again (CNT) and left joint on the end. If you have any suggestion or solutions please let me know. Thank you again.

bob021 · ‎04-29-2011

HI All Can somebody help me with this? This is my table: name no code CNT no2 code2 A 20 sc2000 1 50 TT2000 A 30 sc6000 2 80 TT0000 A 60 sc2000 3 B 20 sc2000 1 30 TT2000 B 40 sc2000 2 50 TT0000 C 20 sc2000 1 50 TT2000 C 60 sc2000 2 80 TT0000 C 70 sc3000 3 This is what I need as result. name no code CNT no2 code2 A 20,30 sc2000,sc6000 1 50 TT2000 A 60 sc2000 3 80 TT0000 B 20 sc2000 1 30 TT2000 B 40 sc2000 2 50 TT0000 C 20 sc2000 1 50 TT2000 C 60,70 sc2000,sc3000 3 80 TT0000 Thank you in advance. Bob

bob021 · ‎04-08-2011

Hi Andre My apology you were right. I followed the link you sent to me and resolved problem.(wrong path) For that matter I establish new rules for behaving on sas forum when something going wrong on SAS (at least for myself). In a attempt to find where the problem is I will start to suspect on: First – on myself (usually this working with 94 % probability) Second – on operational system (1 %) Third – on faith (1 %) Fourth – on hardware (1 %) Fifth – on word conspiracy (1 %) Sixth – sas statement (1 %) Seventh - on god (1 %) Eighth – on my forum friend, who trying to help me, because I ignored rule no. 1 (0%) Regards Bob

bob021 · ‎04-08-2011

Hi Andre Thank you for your answer. Problem is somewhere else not in the sas statement. When I open html from place where is exported everything works fine but when I try to open it in my local web page I see just a table. Probably problem is in configurations of my Apache server. Thank you Andre Thank you Dan Regards Bob

bob021 · ‎04-07-2011

Hi Dan Thank you for quick respond Problem is still there but now, with your help, I get rid of index.html. Still, on place where should be a graph gif is empty box for picture. If you have any other solution please write. Regards Bob

bob021 · ‎04-07-2011

Hi All Can somebody help me with this issue? goptions reset=ALL device=html; ods listing close; ods html path='F:\Export\' body='graph.html'; proc tabulate FIRST PROC TABULATE run; proc gchart FIRST GRAPH run; proc tabulate SECOND PROC TABULATE run; proc gchart SECOND GRAPH run; quit; ods html close; ods listing; In SAS result viewer result is : first table first graph second table second graph SAS Log: Html source written F:\Export\index.html In export folder I found index.xtml with just second graph and graph.html whit just the tables no graphs. On place where should be a graph gif is empty box for picture. Also in same folder I found two gif files with graphs. What I want to is export just to graph.html (no index.html) and to both graphs gif appears in html with tables. Can somebody tell me where I was wrong? Thank you in advance

bob021 · ‎02-24-2011

Hello Ksharp Thank you very much working like a charm. Bob

bob021 · ‎02-24-2011

Hi can somebody help me with this. Data: Name code operations CNT Bob A 20 1 Bob B 20 2 Bob B 30 3 Bob D 40 4 John A 20 1 John A 20 2 John B 30 3 John C 30 4 What I want is to connect cell in column code(comma delimited) if name and operations are same like in example below: Name code operations Bob A,B 20 Bob B 30 Bob D 40 John A,A 20 John B,C 30 Thank you in advance Bob Message was edited by: bob021

bob021 · ‎02-14-2011

Hello Marius Thank you very much. Bob

bob021 · ‎02-11-2011

Hi Marius One more thing about this solution. Is it possible to change place of actiondate and next? I mean to have on left side name next and percent and on top actiondate. Thank you in advance

bob021 · ‎02-10-2011

Hello Marius Thank you very much working like a charm. Bob

bob021 · ‎02-10-2011

Hi Can somebody help me with this. Data: Name operations next actiondate Bob A sent 11.Jan.2011 John A sent 11.Jan.2011 Bob A sent 11.Jan.2011 John A sent 11.Jan.2011 John A sent 11.Jan.2011 Bob A sent 12.Jan.2011 John A sent 12.Jan.2011 Bob A sent 12.Jan.2011 John A sent 12.Jan.2011 Bob B fail 11.Jan.2011 John B fail 11.Jan.2011 Bob B pass 11.Jan.2011 John B wait 11.Jan.2011 John B pass 11.Jan.2011 Bob B fail 12.Jan.2011 John B fail 12.Jan.2011 Bob B pass 12.Jan.2011 John B pass 12.Jan.2011 Sas statement: proc tabulate data=SVBZ01A0.user_end_debug; keylabel n = ' '; class name operations next actiondate; table name='' * operations='' * next='', actiondate='' all='Total' / misstext='0'; run; Result is table: First column name; second is split into two rows operations A and B; Third: A is always sent and B is split into fail/pass/wait; all by date What I want is to make new column percentage for fail/pass/wait of SENT for every day: Bob sent(A) 2 pc 11.Jan.2011 one is fail one is pass(B). In new colum should be fail 50% and pass 50% John sent(A) 3 pc 11.Jan.2011 one is fail,one is pass and one is wait(B) In new colum should be fail 33,3%, pass 33,3% and wait 33,3% Thak you in advance.

bob021 · ‎02-08-2011

Hi dat_null, chang, marius Thank you very much for quick responds. All solutions’ works and help me a lot. Bob021

bob021 · ‎02-07-2011

Hi can somebody can help me with this? Here is my data: NAME NO SL CNT Bob 35 a20 1 Bob 44 a22 2 Bob 28 a20 3 John 35 a20 1 John 35 a22 2 John 35 a20 3 John 35 a20 4 John 35 a22 5 Result I want : NAME NO SL CNT Bob 44 a22 2 Bob 28 a20 3 John 35 a22 2 John 35 a20 3 John 35 a22 5 I want to delete previous record based on conditions My statement should look something like: if SL=a22 then delete previous (one above) record for same NAME. I'm not sure how to do this. Thank you in advance.

Online Status	Offline
Date Last Visited	‎10-13-2015 10:49 AM

Re: New column based on count of days between two date in existing col...

New column based on count of days between two date in existing column

Re: Substring/Scan from string

Substring/Scan from string

Re: SAS 9.1 proc gplot

SAS 9.1 proc gplot

Re: SAS 9.1 proc gplot order axis

Re: SAS 9.1 proc gplot order axis

Re: SAS 9.1 proc gplot order axis

Re: SAS 9.1 proc gplot order axis

Re: New column based on count of days between two date in existing col...

Re: Substring/Scan from string

Re: Update all cell in table based on conditions

Re: Update all cell in table based on conditions

Re: Update all cell in table based on conditions

Re: Count and merge rows.

Re: Count and merge rows.

Count and merge rows.

Re: Export graph and table to html.

Re: Export graph and table to html.

Re: Export graph and table to html.

Export graph and table to html.

Re: Connect cell in column based on condition

Connect cell in column based on condition

Re: Calculating percentage

Re: Calculating percentage

Re: Calculating percentage

Calculating percentage

Re: Delete previous record based on conditions

Delete previous record based on conditions