Hi Tom. I took the data and re-created the table in excel to get the values and formulas to derive the calculated fields. I needed to create helper fields such as NumberDays1 and BegAmount1 to get the final results. In the code below, the grouping is necessary so that the calculated NumberDays1 stops decreasing when their is a change in NumberDays as this distiguishes the different froup within ID. Thanks.      data have; format ID ShowAmount NumberDays NumberDaysMonth NumberDaysBeg NumberDaysEnd BegAmount best12.; infile datalines4 dlm='7F'x missover dsd; input ID ShowAmount NumberDays NumberDaysMonth NumberDaysBeg NumberDaysEnd BegAmount : best32.; datalines4; 152 . 36 28 0 28 3650 152 . 36 8 0 8 36500 152 . 85 14 0 14 4100 152 . 85 31 0 31 4100 152 700 85 30 10 20 4100 152 . 85 10 0 10 41000 152 . 71 19 0 19 4650 152 450 71 29 28 1 4650 152 . 71 23 0 23 4650 152 . 85 25 0 25 4650 152 . 85 36 0 31 4650 152 . 85 29 0 29 4650 ;;;; data have; set have; if ShowAmount = . then ShowAmount = 0; run; data want; set have; by ID NumberDays notsorted; if first.ID then do; BegAmount1 = BegAmount; EndAmount = (BegAmount + ShowAmount); NumberDays1 = NumberDays; MonthlyAmount = (((NumberDaysBeg/NumberDays1)*BegAmount1) + ((NumberDaysEnd/NumberDays1)*EndAmount)); EndAmount1 = (EndAmount - MonthlyAmount); end; if not first.ID then do; BegAmount1 = BegAmount - lag(BegAmount) + lag(EndAmount1); EndAmount = (BegAmount - lag(BegAmount) + ShowAmount + lag(EndAmount1)); NumberDays1 = lag(NumberDays1) - lag(NumberDaysMonth); MonthlyAmount = (((NumberDaysBeg/NumberDays1)*BegAmount1) + ((NumberDaysEnd/NumberDays1)*EndAmount)); EndAount1 = (EndAmount - MonthlyAmount); end; run;   Want: ID ShowAmount NumberDays NumberDays1 NumberDaysMonth NumberDaysBeg NumberDaysEnd BegAmount BegAmount1 EndAmount MonthlyAmount EndAmount1 152 0 36 36 28 0 28 3650 3650 3650 2839 811 152 0 36 8 8 0 8 3650 811 811 811 0 152 0 85 85 14 0 14 4100 450 450 74 376 152 0 85 71 31 0 31 4100 376 376 164 212 152 700 85 40 30 10 20 4100 212 912 509 403 152 0 85 10 10 0 10 4100 403 403 403 0 152 0 71 71 19 0 19 4650 550 550 147 403 152 450 71 52 29 28 1 4650 403 853 233 620 152 0 71 23 23 0 23 4650 620 620 620 0 152 0 85 85 25 0 25 4650 0 0 0 0 152 0 85 60 31 0 31 4650 0 0 0 0 152 0 85 29 29 0 29 4650 0 0 0 0           ... View more

Hi....I having problem getting the output I want when it comes to calculating "Total". I would like to only sum up the "ShowAmount" if the "Start" date is missing. Any suggestions.....Thanks.     data Have; length ID 8 TransDate $ 8 ShowAmount 8 Date $ 8 start $ 8 end $ 8; format ID best12. TransDate $char8. ShowAmount DOLLAR20.2 Date $char8. start $char8. end $char8.; infile datalines4 dlm='7F'x missover dsd; input ID : best32. TransDate : $char8. ShowAmount : best32. Date : $char8. start : $char8. end : $char8. ; datalines4; 15220000720155020000720 15220000804155020000804 1522014080745020140807 1522014082710020140827 152 .201409032014090320140930 152 .201410012014100120141008 1522015082745020150827  152 .201509172015091720150930 152 .201510012015100120151031 15220151111700201511112015110120151130 152 .201512012015120120151210 1522016010855020160108  152 .201601132016011320160131 15220160229450201602292016020120160229 152 .201603012016030120160323 152 .201604062016040620160430 152 .201605012016050120160531 152 .201606012016060120160629 ;;;; data want; set have; by ID TransDate notsorted; if first.ID then Total = 0; Total + ShowAmount; if not missing(Start) then Output; run; Want: ID TransDate ShowAmount Date start end Total 152 20140903 20140903 20140930 3650 152 20141001 20141001 20141008 3650 152 20150917 20150917 20150930 4100 152 20151001 20151001 20151031 4100 152 20151111 $700.00 20151111 20151101 20151130 4800 152 20151201 20151201 20151210 4800 152 20160113 20160113 20160131 4650 152 20160229 $450.00 20160229 20160201 20160229 4650 152 20160301 20160301 20160323 4650 152 20160406 20160406 20160430 4650 152 20160501 20160501 20160531 4650 152 20160601 20160601 20160629 4650 ... View more

Hi...I am trying to do a running total for each amount. The BegRevenue is the previous records EndRevenue and the current record's EndRevenue is the records BegRevenue plus the Show Amount. I can't seem to get this to work. Any suggestions....thanks.   data have; length ShowAmount 8 ; format ShowAmount Dollar20.2 ; informat ShowAmount Dollar20. ; infile datalines4 dlm='7F'x missover dsd; input ShowAmount: best32. ; datalines4; 1550 -1550 1550 -1550 -1550 1550 1775 975 100 -1850 -900 -100 ;;;; data want(drop=_EndRevenue); set have; retain _EndRevenue; if _n_=1 then do; BegRevenue = 0; EndRevenue = ShowAmount; _EndRevenue = EndRevenue; end; else do; BegRevenue = _EndRevenue; EndRevenue = (BegRevenue+ShowAmount); BegRevenue = _EndRevenue; end; run; ShowAmount BegRevenue EndRevenue $1,550.00 0 1550 -$1,550.00 1550 0 $1,550.00 1550 3100 -$1,550.00 1550 0 -$1,550.00 1550 0 $1,550.00 1550 3100 $1,775.00 1550 3325 $975.00 1550 2525 $100.00 1550 1650 -$1,850.00 1550 -300 -$900.00 1550 650 -$100.00 1550 1450 ... View more

Hi....I am trying to create multiple graphs for each Month and would like to have more than one graph on each page. In order to know which Month that each graph represents, I have included the bygroup in the title statement. Because I want to allow more than one graph on the same page, only the first graph on the page has a title for that graph. Is there another way to have the bygroup label each graph so that the appropriate month can be displayed for each graph. Thanks     ods rtf file="I:\Reports\file.rtf" startpage=no ; options nobyline; Axis1 style=1 width=1 minor=none label=(height=9pt font="arial/bold" angle=90 "Percent") value=(height=9pt font="arial" "0%" "10%" "20%" "30%" "40%" "50%" "60%" "70%" "80%" "90%" "100%") order=0 to 100 by 10; Axis2 style=1 width=2 label=(height=9pt font="arial/bold" "Response") value=(height=9pt font="arial"); Axis3 label=(height=9pt font="arial/bold" "Intake") value=(height=9pt font="arial"); proc gchart data=Have; title1 "Month: #byval(Month)"; by Month; vbar Response / discrete group=Intake type=percent inside=percent outside=freq nolegend g100 coutline=black raxis=axis1 maxis=axis2 gaxis=axis3 woutline=1 patternid=midpoint width=20 autoref clipref cref=graycc ; run; quit; title1; ods rtf close; ods listing close; ods _all_ close; ... View more

Hi....I am trying to format variables after the correlation matrix is derived so that the output table would have the formatted names. I get an error message. Any suggestions on how to format the variables...thanks   proc corr data=have plots=none spearman vardef=df fisher(alpha=0.05 biasadj=yes rho0=0 type=twosided); var Q15_1 Q15_2 Q15_3 $QuestionCharB.; run; ... View more