Could you not use the substr function in the passthru sql and bring back the long string in parts? ... View more

Thanks Scott. The HLO option does the trick. Shown below. data CPL4DelCd end=last; set _4CPLDELAYCODES ; fmtname='$CPL4Dly'; Label=AMDelayCd1||AMDelayCd2; Start=Dly_Class_Cd||Dly_Type_Cd||Dly_Reason_Cd; output; if last then do; hlo='O'; /* upper case letter O */ label='Othr'; output; end; run; edit by Bill 14May2009 14:19 EDT Message was edited by: Bill ... View more

for the macro variable to resolve, you need to use double quotes (instead of the single quote) on this put statement PUT "\\netapp01\users\Merchants_General\db_year\sasoutputs\db_report_year &data_date..xls" ; ... View more

and this option doesn't work for you? attach=("c:\temp\test.xls" ct="application/octet-stream"); ... View more

how about data _null_; call system ('copy c:\temp\Orig.xls c:\temp\Copy.xls'); run; ? ... View more

Could you post a few rows of data to go along with your code? Then others can play too. ... View more

please post your code ... ... View more

Although your example is not clear to me, maybe I can help. SAS can't write any data to the pivot table that isn't contained in the data set. If you want to display a zero month in the pivot table, you need to build a zero month in the SAS data set first, e.g. 200902 TX Dallas 0 ... View more

Try using a format statement ... ... View more

You can also run a proc gplot with a symbol i=rl statement. The slope / intercept info is posted in the log window. 86 data test; 87 input a b; 88 datalines; NOTE: The data set WORK.TEST has 4 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 93 ; 94 95 goptions dev=win; 96 symbol1 i=rl; 97 proc gplot data=test; 98 plot a*b=1; 99 run; NOTE: Regression equation : a = 1.311793 + 0.483037*b. 100 quit; ... View more

I missed the fact that you would also be cycling through the colours list. Add c=blue to symbol1 and then it will only be used once. You can remove the r= option. Revised code below. data a; INPUT obs i; i_sum+i; %let a=0.001; %let b=0.2; %let p1=0.1; %let p2=0.2; %let q=log(&p2*(1-&p1)/&p1*(1-&p2)); %let h1=log(&b/(1-&a))/&q; %let h2=log((1-&b)/&a)/&q; q=&q; h1=&h1; h2=&h2; s=log((1-&p1)/(1-&p2))/&q; d1=&h1+s*obs; d2=&h2+s*obs; CARDS; 1 1 2 0 3 1 4 1 5 0 6 0 7 0 8 1 9 0 10 1 ; run; goptions reset=all dev=win; title 'test'; symbol1 i=stepjl c=blue; symbol2 i=join; proc gplot data=a; plot i_sum*obs=1 (d1 d2)*obs=2 /overlay; run; quit; ... View more

add repeat=1 to the symbol statement to only use it once ... View more

If you have SAS/QC, then proc pareto will do this for you. ... View more

Jman; per the document referenced earlier, I would understand that a png file would be best for rtf. ... View more