Hi... I am using the following code to compute an annual rate which seems to work and wonder if there is a better or more efficient way to achieve the same results. I am working with rates for the Fall, Winter and Spring for each year and in some instances one or more rates may be missing. I ended up writing if statements for all the possible combination that could occur. Is there a better way to do the same thing. Thanks   data Want; format RetRate 12.2; set Have; if missing(Fall) and not missing(Winter) and not missing(Spring) then RetRate = ((((1+Spring)*(1+Winter))**(1/2))-1)*100; if not missing(Fall) and missing(Winter) and not missing(Spring) then RetRate = ((((1+Spring)*(1+Fall))**(1/2))-1)*100; if not missing(Fall) and not missing(Winter) and missing(Spring) then RetRate = ((((1+Fall)*(1+Winter))**(1/2))-1)*100; if not missing(Fall) and not missing(Winter) and not missing(Spring) then RetRate = ((((1+Spring)*(1+Fall)*(1+Winter))**(1/3))-1)*100; if missing(Fall) and missing(Winter) and not missing(Spring) then RetRate = (((1+Spring)**(1/1))-1)*100; if not missing(Fall) and missing(Winter) and missing(Spring) then RetRate = (((1+Fall)**(1/1))-1)*100; if missing(Fall) and not missing(Winter) and missing(Spring) then RetRate = (((1+Winter)**(1/1))-1)*100; run; ... View more

Hi...I am trying to insert subtotals after each "Degree Original" and Totals after each School. I was able to get the Grand Total and tried to include "All" after "School" and "Degree Original" in the Table statement and it didn't work. Do I need to use parenthesis to group the variables. Thanks.   proc tabulate data=List201 format=8.0 style=[bordercolor=black]; var StudentUID1 / style=[background=lightblue bordercolor=black]; var 'Completion Status1'n / style=[background=lightblue bordercolor=black]; var Graduation1 / style=[background=lightblue bordercolor=black]; class Gender / style=[background=lightblue bordercolor=black] order=unformatted; class "Season Enrolled1"n / style=[background=lightblue vjust=c bordercolor=black] order=unformatted; class School / style=[background=lightblue vjust=c bordercolor=black] order=unformatted missing; class "Initial Program"n / style=[background=lightblue bordercolor=black] order=unformatted missing; class Level / style=[background=lightblue bordercolor=black] order=unformatted missing ; class Academic_Term / style=[background=lightblue bordercolor=black] order=unformatted missing; class 'Degree Original'n / style=[background=lightblue vjust=c bordercolor=black] order=unformatted missing; classlev Gender / style=[background=lightblue bordercolor=black]; classlev "Initial Program"n / style=[background=lightblue cellwidth=11.0cm vjust=c bordercolor=black]; classlev Level / style=[background=lightblue cellwidth=3.0cm bordercolor=black]; classlev "Season Enrolled1"n / style=[background=lightblue cellwidth=3.0cm vjust=c bordercolor=black]; classlev School / style=[background=lightblue cellwidth=4.0cm vjust=c bordercolor=black]; classlev Academic_Term / style=[background=lightblue cellwidth=3.0cm vjust=c bordercolor=black]; classlev 'Degree Original'n / style=[background=lightblue cellwidth=6.0cm vjust=c bordercolor=black]; table School= 'School' * "Degree Original"n='Credential' * "Initial Program"n='Program' * Level='Level' All ={ label='Grand Total' S=[background = lightblue bordercolor=black]} *[style=[bordercolor=black]] , ((StudentUID1='Students Enrolled' * Gender=' ' * Sum=' ' ) ("Season Enrolled1"n=' ' * Gender=' ' * N=' ' ) ('Completion Status1'n='On-Time Rate (%)' * Gender=' ' * (pctsum<Gender>=""*f=8.2) ) (Graduation1='Graduation Rate (%)' * Gender=' ' * (pctsum<Gender>=""*f=8.2) )) / box=[label=' ' style=[backgroundcolor=lightblue cellwidth=10.0cm bordercolor=black]]; ; run; ... View more

Hi...I am trying to obtain each Season that is between two dates (STD & ENDT). The problem I am having is I want to have the Spring Season end on June 15 rather than June 30. I have tried the following:   end_subperiod=intnx('year.7',start_subperiod,0,'end',-15)   but that didn't work. Any suggestions.Thanks.   data Have; infile datalines dsd truncover; input STD:yymmdd10. ENDT:yymmdd10.; format std endt yymmdd10.; datalines4; 2016-06-02,2016-09-24 2016-06-15,2016-09-26 2016-06-19,2016-09-30 ;;;; data want; set have; format start_subperiod end_subperiod yymmddn8.; array month_to_season_map {12} $6 _temporary_ ('Winter','Winter','Winter' ,'Spring','Spring','Spring' ,'Summer','Summer' ,'Fall','Fall','Fall','Fall'); seasonstart=month_to_season_map{month(std)}; seasonend=month_to_season_map{month(endt)}; start_subperiod=std; do while (start_subperiod<=endt); select(month(start_subperiod)); /* Align end_subperiod */ when (9,10,11,12) end_subperiod=intnx('year.1',start_subperiod,0,'end'); when (1,2,3) end_subperiod=intnx('year.4',start_subperiod,0,'end'); when (4,5,6) end_subperiod=intnx('year.7',start_subperiod,0,'end'); when (7,8) end_subperiod=intnx('year.9',start_subperiod,0,'end'); end; end_subperiod=min(end_subperiod,endt); season=month_to_season_map{month(end_subperiod)}; output; start_subperiod=end_subperiod+1; end; run; Result:   STD ENDT start_subperiod end_subperiod seasonstart seasonend season 2016-06-02 2016-09-24 20160602 20160630 Spring Fall Spring 2016-06-02 2016-09-24 20160701 20160831 Spring Fall Summer 2016-06-02 2016-09-24 20160901 20160924 Spring Fall Fall 2016-06-15 2016-09-26 20160615 20160630 Spring Fall Spring 2016-06-15 2016-09-26 20160701 20160831 Spring Fall Summer 2016-06-15 2016-09-26 20160901 20160926 Spring Fall Fall 2016-06-19 2016-09-30 20160619 20160630 Spring Fall Spring 2016-06-19 2016-09-30 20160701 20160831 Spring Fall Summer 2016-06-19 2016-09-30 20160901 20160930 Spring Fall Fall               Want:                           STD ENDT start_subperiod end_subperiod seasonstart seasonend season 2016-06-02 2016-09-24 20160602 20160615 Spring Fall Spring 2016-06-02 2016-09-24 20160616 20160831 Spring Fall Summer 2016-06-02 2016-09-24 20160901 20160924 Spring Fall Fall 2016-06-15 2016-09-26 20160615 20160615 Spring Fall Spring 2016-06-15 2016-09-26 20160616 20160831 Spring Fall Summer 2016-06-15 2016-09-26 20160901 20160926 Spring Fall Fall 2016-06-19 2016-09-30 20160619 20160831 Summer Fall Summer 2016-06-19 2016-09-30 20160901 20160930 Summer Fall Fall ... View more

Hi...I have got to the point where I need to split the row if the end_subperiod is greater than the end_subperiod1, and if so, then the start_subperiod entry of the new row will be the end_subperiod1 from the previous row. Would I need to use Retain? Thanks.   data Have; length season $ 6 start_subperiod $ 10 end_subperiod $ 10 end_subperiod1 $ 10; format season $char6. start_subperiod $char10. end_subperiod $char10. end_subperiod1 $char10.; informat season $char6. start_subperiod $char10. end_subperiod $char10. end_subperiod1 $char10.; infile datalines4 dlm='7F'x missover dsd; input season : $char6. start_subperiod : $char10. end_subperiod : $char10. end_subperiod1 : $char10.; datalines4; Fall2016-09-082016-10-262016-10-21 Fall2016-09-082016-11-232016-10-21 Summer2016-07-022016-08-252016-08-19 Summer2016-07-022016-08-312016-08-19 Winter2016-01-022016-03-312016-02-19 Winter2017-01-022017-03-152017-02-17 ;;;; Want:   season start_subperiod end_subperiod end_subperiod1 Fall 2016-09-08 2016-10-26 2016-10-21 Fall 2016-10-21 2016-10-26 2016-10-26 Fall 2016-09-08 2016-11-23 2016-10-21 Fall 2016-10-21 2016-11-23 2016-11-23 Summer 2016-07-02 2016-08-25 2016-08-19 Summer 2016-08-19 2016-08-25 2016-08-25 Summer 2016-07-02 2016-08-31 2016-08-19 Summer 2016-08-19 2016-08-31 2016-08-31 Winter 2016-01-02 2016-03-31 2016-02-19 Winter 2016-02-19 2016-03-31 2016-03-31 Winter 2017-01-02 2017-03-15 2017-02-17 Winter 2017-02-17 2017-03-15 2017-03-15 ... View more