cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Filipvdr
‎01-17-2024
  • 342 Posts
  • 7 Likes Given
  • 4 Solutions
  • 19 Likes Received
About
Started as a SAS consultant in July 2010. SAS Stored Processes / CSS / HTML / Jquery

Programming Logic

by Pyrite | Level 9 in SAS Programming
‎04-02-2012 08:59 AM
‎04-02-2012 08:59 AM
thanks Hai.kuo , your reply is comes close to what I really needed ... View more

Re: gchart: controlling hbar order

by Pyrite | Level 9 in Graphics Programming
‎04-02-2012 08:58 AM
‎04-02-2012 08:58 AM
thanks DanH, i was looking for your answer a long time ... View more

Programming Logic

by Pyrite | Level 9 in SAS Programming
‎04-02-2012 06:27 AM
‎04-02-2012 06:27 AM
yes, that is what i needed more or less. I forgot to say that I need a name as well for the group. SEPT,OKT and NOV should become something like SEPT-NOV I will try to figure it out, thanks already ... View more

Programming Logic

by Pyrite | Level 9 in SAS Programming
‎04-02-2012 05:25 AM
‎04-02-2012 05:25 AM
Hello, I have a dateset which looks like this: Month          Value A          Value B         MAR2011     10%                 20            APR2011     11%                 20     JUN2011      10%                 27     JUL2011       10%                 22    AUG2011      15%                 20     SEPT2011    12%                 25    OKT2011      10%                 23    NOV2011      10%                21     The macro variable disp_bin is the number of months that I have to summarize on. For example if the disp_bin is 3 then SEPT,OKT en NOV should be one row with the average of value A and value B as new value A and B AUG JUL en JUN should be one row with the average of value A and value B as new value A and B MAR and APR should be one row (so actually i have to start at the last month) with the average of value A and value B as new value A and B I hope it is clear like this, Thanks ... View more

Re: creating D02-D05 from D02;D03;D04;D05 and more complicated things

by Pyrite | Level 9 in SAS Programming
‎03-23-2012 08:33 AM
‎03-23-2012 08:33 AM
the - reflects the size of the gap, so for each number that is not in the row there is a - ... View more

Re: creating D02-D05 from D02;D03;D04;D05 and more complicated things

by Pyrite | Level 9 in SAS Programming
‎03-23-2012 05:12 AM
‎03-23-2012 05:12 AM
thanks for all your answers I have to calculate a second variable now: I have the same strings: D01;D02;D03;D04;D05;                                           should become DDDDD D01;D02;D03;D05;                                                  should become DDD-D D10;D11;D12;D13;D17;D20;D21;D22                        should become ---------DDDD---D--DDD; ... View more

creating D02-D05 from D02;D03;D04;D05 and more complicated things

by Pyrite | Level 9 in SAS Programming
‎03-22-2012 11:01 AM
‎03-22-2012 11:01 AM
Hello, i have a variable separated by ; Examples : D01;D02;D03;D04;D05;                                           should become D01-D05 D01;D02;D03;D05;                                                  should become D01-D03;D05 D10;D11;D12;D13;D17;D20;D21;D22                        should become D10-D13;D17;D20-D22; Any help to get me on my way? Thanks!  ... View more

What graph do I need?

by Pyrite | Level 9 in Graphics Programming
‎03-21-2012 10:18 AM
‎03-21-2012 10:18 AM
Thanks, this comes quite near of what i have to use... Can you tell me how I can sort on date? axis1 label=('Volume (%)') order=(0 to 200 by 50) minor=none; axis2 label=('Tat (DAYS)') order=(0 to 7 by 1) minor=none; axis3 label=('Month'); axis3 order=("01JAN2010"d to "01MAR2011"d by month); proc gbarline data=graph;    bar month / discrete       sumvar=RQPV raxis=axis1 maxis=axis3       width=15 des='' name="Test" ;    plot /       sumvar=TAT raxis=axis2; run; ... View more

Re: calculating averages on floating period

by Pyrite | Level 9 in SAS Procedures
‎03-21-2012 07:06 AM
‎03-21-2012 07:06 AM
Thanks both for your quick reply. I will have a look at Ksharp his code to understand it and implement it. ... View more

Re: calculating averages on floating period

by Pyrite | Level 9 in SAS Procedures
‎03-21-2012 06:56 AM
‎03-21-2012 06:56 AM
Well i did not.. i went on with the code of Keith. If there is no answer within the code of Keith I will have to take yours ... View more

Re: calculating averages on floating period

by Pyrite | Level 9 in SAS Procedures
‎03-21-2012 06:22 AM
‎03-21-2012 06:22 AM
thanks for both answers, it helped me a lot in my coding though i experience an other difficulty at the moment: %let default_size_definition=70; proc summary data=finished_requests nway; class date / mlf order=data; format date roll_mth_calc.; var quota; output out=TQS (drop=_:) p&default_size_definition.=TQS; run; this will not work as proc summary uses only 75 and not 70 so i found i can use proc univariate but the format does not work here? any help? proc univariate data = finished_requests noprint; class date / mlf order=data; format date roll_mth_calc.; var quota; output out = caprate pctlpts = 10 to 100 by 10 pctlpre = pct_; run; ... View more

What graph do I need?

by Pyrite | Level 9 in Graphics Programming
‎03-21-2012 04:43 AM
‎03-21-2012 04:43 AM
Hi, i'm new to creating graphs in SAS. I have to create a graph which looks like this: On x-ax: months I need two Y-axes: on the left measure A, on the right measure B. I need bars for measure A, a line with at each month a square for Measure B. I need a dotted line for the median of measure B. At last i need an average of measure A for the last year which is also represented as a bar in the graph. Is this possible in the graph or better to calculate up front? So my main question is: what kind of graph do I have to start with? An example would be nice. Thanks Filip ... View more

Re: calculating averages on floating period

by Pyrite | Level 9 in SAS Procedures
‎03-19-2012 09:12 AM
‎03-19-2012 09:12 AM
Indeed Keith, your solution works perfectly. Thanks both for your help. ... View more

Re: calculating averages on floating period

by Pyrite | Level 9 in SAS Procedures
‎03-19-2012 06:43 AM
‎03-19-2012 06:43 AM
Unfortunate.. something is going wrong when I test it on my data: This is the table want (with N kept). I get for APR2011 106 rows=n? With a mean which is always different.. any idea? APR2011 12.382727273 106 APR2011 12.300052083 106 APR2011 12.17015873 106 APR2011 12.363972603 106 APR2011 12.268622754 106 APR2011 11.871 106 APR2011 12.1575 106 APR2011 12.1575 106 APR2011 12.241363636 106 APR2011 11.871 106 APR2011 12.426490385 106 APR2011 11.968776978 106 APR2011 12.219783784 106 APR2011 12.27355 106 APR2011 12.23695122 106 APR2011 11.886891892 106 EDIT: I think the problem is that, in comparison with your datalines the real numberic value of month is different here.. I tried to replace it with month_char but it does not work ... View more

Re: calculating averages on floating period

by Pyrite | Level 9 in SAS Procedures
‎03-19-2012 06:21 AM
‎03-19-2012 06:21 AM
Ksharp, thanks a lot. This will help me a lot already. A question that pops into my mind: how to do percentile 70 for example in sql? Median is just an other function but does their exist a percentile function as well?  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-17-2024 08:59 AM
Likes given to
Likes from
Quick links