Very helpful - thank you! ... View more

Thanks for the assistance. I enabled the option to display all SAS code, but I'm not sure where I make the adjustment to have each excel output tab named after the value in the Pages task role. Here is a simplified example using data from the CARS table. I'm trying to make each tab name equal the value in the MAKE field. Where would I adjust this code?   ODS _ALL_ CLOSE; ODS PROCTITLE; OPTIONS DEV=PNG; GOPTIONS XPIXELS=0 YPIXELS=0; %macro HTML5AccessibleGraphSupported;     %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; %mend; FILENAME EGSR TEMP; ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR     STYLE=HTMLBlue     NOGTITLE     NOGFOOTNOTE     GPATH=&sasworklocation     ENCODING=UTF8     options(rolap="on") ; FILENAME EGXLSSX TEMP; ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX STYLE=HTMLBlue OPTIONS (  EMBEDDED_TITLES="yes" EMBEDDED_FOOTNOTES="yes" );   TITLE; FOOTNOTE; /* -------------------------------------------------------------------    Code generated by SAS Task      Generated on: Wednesday, June 17, 2020 at 8:39:19 AM    By task: Summary Tables      Input Data: SASApp:SASHELP.CARS    Server:  SASApp    ------------------------------------------------------------------- */     /* -------------------------------------------------------------------    Run the tabulate procedure    ------------------------------------------------------------------- */ PROC TABULATE DATA=SASHELP.CARS           ;           VAR MSRP Invoice;      CLASS DriveTrain /    ORDER=UNFORMATTED MISSING;      CLASS Origin /  ORDER=UNFORMATTED MISSING;      CLASS Type /    ORDER=UNFORMATTED MISSING;      CLASS Model /   ORDER=UNFORMATTED MISSING;      CLASS Make /    ORDER=UNFORMATTED MISSING;      TABLE /* Page Dimension */ Make, /* Row Dimension */ Model*   Type*     Origin, /* Column Dimension */ Mean*   Invoice       ;      ;   RUN; /* -------------------------------------------------------------------    End of task code    ------------------------------------------------------------------- */ RUN; QUIT; TITLE; FOOTNOTE;     %LET _CLIENTTASKLABEL=; %LET _CLIENTPROCESSFLOWNAME=; %LET _CLIENTPROJECTPATH=; %LET _CLIENTPROJECTPATHHOST=; %LET _CLIENTPROJECTNAME=;   ;*';*";*/;quit;run; ODS _ALL_ CLOSE; ... View more

Thanks for the insight and the steps on how to do this. I appreciate the help. ... View more

If I wanted to continue to group by program but also include the gender variable by column output how could this code be adjusted to accomplish that?   For example if I wanted the same results, but I wanted it to look like this (either with gender concatenated into the column name or with gender falling under each category):     program ft24m ft24f ft30m ft30f pt12m pt12f pt15m pt15f a               #        #     #         #      #         #       #         # b               #        #     #         #      #         #       #         #   OR   program ft24+ ft30+ pt12+ pt15+                 m f     m f    m f      m f a            # #     # #    # #      # #  b            # #     # #    # #      # #   Thanks!   ... View more

Perfect - many thanks! ... View more

Sure - no problem. Appreciate your expertise and insight. Thanks! ... View more

Solution worked perfectly - thank you!   Not sure if I need to post this as a new, separate question, but since it is related to the prior solution I thought I'd add it here.   Using the problem identified, but adding one additional variable I'd like to do the same thing but unduplicate the records factoring in the additional variable. For example, the current data looks like this:   ID,STATE,YEAR KREE990001,TX,2017 KREE990001,TX,2017 KREE990001,TX,2017 KREE990001,TX,2017 KREE990001,TX,2016 KREE990001,TX,2016 KREE990001,   GHTR880001,   GHTR880001,   JHRT330001,NC,2016 JHRT330001,   WQUT110001,TX,2017 WQUT110001,OH,2017 WQUT110001,OH,2017 WQUT110001,OH,2017 WQUT110001,TX,2016 WQUT110001,TX,2016   However, I would like to change this so that no record is duplicated in a single YEAR. I would like to assign values as follows taking the YEAR variable into consideration:   0 - All of the STATE values associated with the ID are blank. 1 - If the STATE value(s) associated with the record equals TX and no other value is present for the STATE field in that YEAR. 2 - If the STATE field includes one or more STATE values and none of the STATE value(s) associated with the record equals TX in that YEAR. 3 - If the STATE field includes values for both TX and at least one other state in that YEAR.   The new data would look like this:   ID,STATE,YEAR KREE990001,1,2017 KREE990001,1,2016 KREE990001,0 GHTR880001,0 JHRT330001,2,2016 JHRT330001,0 WQUT110001,3,2017 WQUT110001,1,2016   Could the previous solution be modified to accomplish this or is a different method recommended? ... View more

I'd like to merge the records to create a new dataset. For example, the current data looks like this: ID,STATE KREE990001,TX KREE990001,TX KREE990001,    GHTR880001,    GHTR880001,    JHRT330001,NC JHRT330001,    WQUT110001,TX WQUT110001,OH However, I would like to change this so that no record is duplicated. I would like to assign values as follows: 0 - All of the STATE values associated with the ID are blank. 1 - If the STATE value(s) associated with the record equals TX and no other value is present for the STATE field. 2 - If the STATE field includes one or more STATE values and none of the the STATE value(s) associated with the record equals TX. 3 - If the STATE field includes values for both TX and at least one other state. The new data would look like this: ID,STATE KREE990001,1 GHTR880001,0 JHRT330001,2 WQUT110001,3 ... View more

Final solution I used was as follows: if month(date) <= 6 then fiscal_Year = catx('/', year(date)-1, year(date)); else fiscal_year = catx('/', year(date), year(date)+1); This provided the FISCAL YEAR formatted as needed. Thanks for the feedback especially given the lack of clarity in my original question. ... View more