Hi   I'm trying to emulate something like:   proc gchart data=sashelp.baseball;   hbar team / asc sumvar=natbat; run;   in a proc template.  I can get the vertical bars to come out but not in ascending sequence by the sum of the response variable.  How can I get it to come out in order?   Current code: proc template;     define statgraph bb;   begingraph;   layout overlay /;      barchart response=natbat category=team;   endlayout;   endgraph;   end; run;   proc sgrender data=sashelp.baseball template=bb; run;   Thanks!   --Ben ... View more

Hi,   I'm chasing my tail on what should be a simple macro and getting nowhere.  Given the following code:   %macro stlist(vars,q=%str( ), c=%str( ));   %let i=1;   %do %while (%scan(&vars,&i) ^= );   %let sv = %scan(&vars,&i);   %if &i ^= 1 %then &c;   %let res=&q.&sv.&q; &res   %let i= %eval(&i+1);   %end; %mend stlist;   %let tvars=cat dog pig;   data _null_; * Goal: produce the following statement... array t(3) $ a b c ('cat' 'dog' 'pig');   array t(3) $ a b c ( %stlist(&tvars, q=%str(%')) ); r="%stlist(&tvars, q=%str(%'))"; put r=; stop; run;   If I run this as-is, SAS throws a syntax error.  If I comment out the array statement and let the result of the macro invocation be assigned to the variable r, it give me what I want for the intial values for a b and c in the array statement.     What am I missing?     Thanks!   --Ben ... View more

Hi,   Running the code: proc tabulate data=sashelp.baseball formchar='           ' ;    class league team;    table league*(all team), n colpctn; run; Gives back (in part):                                                            N         ColPctN  League at the End of 1986 All                              175.00        54.35  American                  Team at the End of 1986                            Baltimore                         15.00         4.66                            Boston                            10.00         3.11                            California                        13.00         4.04                            Chicago                           13.00         4.04     What I'd like to see is %s at the Team level where the All is at 100% and the team name is a % of the total for that league.  So it would look like:                                                              N         ColPctN  League at the End of 1986 All                              175.00       100.00  American                  Team at the End of 1986                            Baltimore                         15.00         8.57                            Boston                            10.00         5.71                            California                        13.00         7.42     What can I use for the PCTN value to achieve that, or some other combination?  Thanks!   --Ben ... View more

Hi,   A coworker of mine had an automated process send out a bunch of emails and got a little over 1,000 bouncebacks for various reasons.  I was asked if there was any way to extract the email body from Outlook and put them in a file or something usable.   I have no idea.  I did look at a msg file Outlook produced and it is pretty obtuse.  Anyone have any suggestions on this one?   The emails aren't in MSG format yet but could be exported to that if needed.   Thanks!   --Ben ... View more

Hi,   Given a set of values, say A B and C, I need to generate the following from it:   A B C A B A C B C A B C   I've looked at the permutation functions that those don't seem to fit.  Not sure about Proc Plan either.  Data step would be prefereable but not required.   Thanks!   --Ben ... View more