topic Re: proc report align each across class top in SAS Programming https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759474#M240017 <P>excellent, that works.</P> <P>understood.</P> Wed, 04 Aug 2021 19:51:45 GMT acordes 2021-08-04T19:51:45Z proc report align each across class top https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759457#M240010 <P>Hi <a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13549">@Cynthia_sas</a>&nbsp;</P> <P>&nbsp;</P> <P>Can I achieve directly in proc report that each new across class begins with the non missing model values?</P> <P>I want the output to align on top.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc report data=RISKNOBA.JG_HQJUL2 center split="*" out=three ; column scope BRAND , model dummyvar ; define scope / group ; define BRAND/ across; define model / display ; define dummyvar / computed; compute dummyvar; dummyvar = 1; endcomp; run;</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rep.png" style="width: 962px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/62263i7778EDFDF3EC7DA5/image-size/large?v=v2&amp;px=999" role="button" title="rep.png" alt="rep.png" /></span></P> Wed, 04 Aug 2021 19:18:53 GMT https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759457#M240010 acordes 2021-08-04T19:18:53Z Re: proc report align each across class top https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759459#M240011 <P>Show your input data structure please. FYI - if you post screenshots we can only post solution approaches and not code. <BR />If you want code assistance please ensure you provide data in a usable format, preferably a data step.</P> <P>&nbsp;</P> <P>FYI - I suspect the answer is no and proc transpose is an easier solution overall.</P> <P>&nbsp;</P> <LI-SPOILER>Transposing data tutorials:<BR />Long to Wide:<BR /><A href="https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/" target="_blank">https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/</A><BR /><BR /><A href="https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/" target="_blank">https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/</A><BR /><BR />Wide to Long:<BR /><A href="https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/" target="_blank">https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/</A><BR /><BR /><A href="https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/" target="_blank">https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/</A><BR /><BR />And sometimes a double transpose is needed for extra wide data sets:<BR /><A href="https://gist.github.com/statgeek/2321b6f62ab78d5bf2b0a5a8626bd7cd" target="_blank">https://gist.github.com/statgeek/2321b6f62ab78d5bf2b0a5a8626bd7cd</A></LI-SPOILER> Wed, 04 Aug 2021 19:31:13 GMT https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759459#M240011 Reeza 2021-08-04T19:31:13Z Re: proc report align each across class top https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759467#M240014 <P>sure.</P> <P>data RISKNOBA.JG_HQJUL2;<BR />infile datalines dsd truncover;<BR />input BRAND:$11. MODEL:$50. scope:$3.;<BR />datalines4;<BR />AUDI,AUDI A1 SB P 2018,all<BR />AUDI,AUDI A1 CITYCARVER P 2019,all<BR />AUDI,AUDI A3 SB D 2020,all<BR />AUDI,AUDI A3 SB P 2020,all<BR />AUDI,AUDI S3 SB P 2020,all<BR />AUDI,AUDI A3 SB P MHEV 2020,all<BR />AUDI,AUDI A3 SB Etron 2020,all<BR />AUDI,AUDI A3 SEDAN D 2020,all<BR />AUDI,AUDI A3 SEDAN P 2020,all<BR />AUDI,AUDI S3-RS3 SEDAN P 2020,all<BR />AUDI,AUDI A3 SEDAN P MHEV 2020,all<BR />AUDI,AUDI A4 D MHEV FL 2019,all<BR />AUDI,AUDI S4 D MHEV FL 2019,all<BR />AUDI,AUDI A4 P MHEV FL 2019,all<BR />AUDI,AUDI A4 AVANT D MHEV FL 2019,all<BR />AUDI,AUDI A4 ALLROAD D MHEV FL 2019,all<BR />AUDI,AUDI S4 AVANT D MHEV FL 2019,all<BR />AUDI,AUDI A4 AVANT P MHEV FL 2019,all<BR />AUDI,AUDI A4 ALLROAD P MHEV FL 2019,all<BR />AUDI,AUDI RS4 AVANT P MHEV FL 2019,all<BR />AUDI,AUDI A5 SB D MHEV FL 2019,all<BR />AUDI,AUDI S5 SB D MHEV FL 2019,all<BR />AUDI,AUDI A5 SB P MHEV FL 2019,all<BR />AUDI,AUDI RS5 SB P FL 2019,all<BR />AUDI,AUDI A5 D MHEV FL 2019,all<BR />AUDI,AUDI S5 D MHEV FL 2019,all<BR />AUDI,AUDI A5 P MHEV FL 2019,all<BR />AUDI,AUDI RS5 P FL 2019,all<BR />AUDI,AUDI A5 Cabrio D MHEV FL 2019,all<BR />AUDI,AUDI A5 Cabrio P MHEV FL 2019,all<BR />AUDI,AUDI A6 Berlina D MHEV 2018,all<BR />AUDI,AUDI S6 Berlina D MHEV 2018,all<BR />AUDI,AUDI A6 Berlina P MHEV 2018,all<BR />AUDI,AUDI A6 Berlina P PHEV 2018,all<BR />AUDI,AUDI A6 Avant D MHEV 2018,all<BR />AUDI,AUDI S6 AVANT D MHEV 2018,all<BR />AUDI,AUDI A6 Avant P MHEV 2018,all<BR />AUDI,AUDI RS6 AVANT P MHEV 2018,all<BR />AUDI,AUDI A6 Avant P PHEV 2018,all<BR />AUDI,AUDI A7 SB D MHEV 2018,all<BR />AUDI,AUDI S7 SB D MHEV 2018,all<BR />AUDI,AUDI A7 SB P MHEV 2018,all<BR />AUDI,AUDI RS7 SB P MHEV 2018,all<BR />AUDI,AUDI A7 SB P PHEV 2018,all<BR />AUDI,AUDI A8 D MHEV 2017,all<BR />AUDI,AUDI A8 P MHEV 2017,all<BR />AUDI,AUDI S8 P MHEV 2017,all<BR />AUDI,AUDI A8 P PHEV 2017,all<BR />AUDI,AUDI Q2 D FL 2020,all<BR />AUDI,AUDI Q2 P FL 2020,all<BR />AUDI,AUDI SQ2 P FL 2020,all<BR />AUDI,AUDI Q3 D 2018,all<BR />AUDI,AUDI Q3 P 2018,all<BR />AUDI,AUDI RSQ3 P 2018,all<BR />AUDI,AUDI Q3 P MHEV 2018,all<BR />AUDI,AUDI Q3 P PHEV 2018,all<BR />AUDI,AUDI Q3 SB D 2019,all<BR />AUDI,AUDI Q3 SB P 2019,all<BR />AUDI,AUDI RSQ3 SB P 2019,all<BR />AUDI,AUDI Q3 SB P MHEV 2019,all<BR />AUDI,AUDI Q3 SB P PHEV 2019,all<BR />AUDI,AUDI Q5 D MHEV FL 2020,all<BR />AUDI,AUDI SQ5 D FL 2020,all<BR />AUDI,AUDI Q5 P MHEV FL 2020,all<BR />AUDI,AUDI RSQ5 P FL 2020,all<BR />AUDI,AUDI Q5 P PHEV FL 2020,all<BR />AUDI,AUDI Q5 SB D MHEV 2021,all<BR />AUDI,AUDI SQ5 SB D MHEV 2021,all<BR />AUDI,AUDI Q5 SB P MHEV 2021,all<BR />AUDI,AUDI Q5 SB P PHEV 2021,all<BR />AUDI,AUDI Q7 D MHEV FL 2019,all<BR />AUDI,AUDI Q7 P MHEV FL 2019,all<BR />AUDI,AUDI SQ7 P FL 2019,all<BR />AUDI,AUDI Q7 P PHEV FL 2019,all<BR />AUDI,AUDI Q8 D MHEV 2018,all<BR />AUDI,AUDI Q8 P MHEV 2018,all<BR />AUDI,AUDI SQ8 P MHEV 2018,all<BR />AUDI,AUDI RSQ8 P MHEV 2018,all<BR />AUDI,AUDI Q8 P PHEV 2020,all<BR />AUDI,AUDI E-TRON,all<BR />AUDI,AUDI E-TRON SPORTBACK,all<BR />AUDI,AUDI Q4 E-TRON 2021,all<BR />AUDI,AUDI Q4 SB E-TRON 2021,all<BR />AUDI,AUDI E-TRON GT 2021,all<BR />AUDI,AUDI E-TRON GT RS 2021,all<BR />AUDI,AUDI R8 2015,all<BR />AUDI,AUDI TT COUPE P 2014,all<BR />AUDI,AUDI TT ROADSTER P 2014,all<BR />AUDI,AUDI A3 SB D FL 2016,all<BR />AUDI,AUDI A3 SB P FL2016,all<BR />AUDI,AUDI S3-RS3 SB P FL2017,all<BR />AUDI,AUDI A3 G-tron SB FL 2016,all<BR />AUDI,AUDI A3 E-tron SB 2019,all<BR />AUDI,AUDI A3 CABRIO P 2014,all<BR />AUDI,AUDI S3 CABRIO P FL 2017,all<BR />AUDI,AUDI A3 SEDAN D FL 2016,all<BR />AUDI,AUDI A3 SEDAN P FL 2016,all<BR />AUDI,AUDI S3-RS3 SEDAN P FL 2017,all<BR />AUDI,AUDI A4 D FL 2019,all<BR />AUDI,AUDI A4 AVANT D FL 2019,all<BR />AUDI,AUDI A4 ALLROAD D FL 2019,all<BR />AUDI,AUDI A4 Avant GTRON FL 2019,all<BR />AUDI,AUDI A5 SB D FL 2019,all<BR />AUDI,AUDI A5 D FL 2019,all<BR />AUDI,AUDI A5 Cabrio D FL 2019,all<BR />AUDI,AUDI Q2 D 2016,all<BR />AUDI,AUDI Q2 P 2016,all<BR />AUDI,AUDI SQ2 P 2016,all<BR />AUDI,AUDI Q5 D 2016,all<BR />AUDI,AUDI Q5 D MHEV 2016,all<BR />AUDI,AUDI SQ5 D MHEV 2016,all<BR />AUDI,AUDI Q5 P MHEV 2016,all<BR />AUDI,AUDI Q5 P PHEV 2016,all<BR />AUDI,AUDI SQ7 D FL 2019,all<BR />AUDI,AUDI SQ8 D MHEV 2018,all<BR />BENTLEY,FLYING SPUR FL 2020,all<BR />BENTLEY,CONTINENTAL GT 2018,all<BR />BENTLEY,CONTINENTAL GT CONVERTIBLE 2019,all<BR />BENTLEY,BENTAYGA 2016,all<BR />BENTLEY,BENTAYGA SPEED 2016,all<BR />BENTLEY,BENTAYGA HYBRID 2016,all<BR />BENTLEY,MULSANNE FL 2016,all<BR />LAMBORGHINI,AVENTADOR COUPÉ 2013,all<BR />LAMBORGHINI,AVENTADOR ROADSTER 2013,all<BR />LAMBORGHINI,HURACÃ&#129;N COUPÉ 2014,all<BR />LAMBORGHINI,HURACÃ&#129;N SPYDER 2014,all<BR />LAMBORGHINI,URUS 2018,all<BR />PORSCHE,911 COUPÉ PETROL,all<BR />PORSCHE,911 COUPÉ PETROL TURBO Y TURBO S,all<BR />PORSCHE,911 CABRIO PETROL,all<BR />PORSCHE,911 CABRIO PETROL TURBO Y TURBO S,all<BR />PORSCHE,911 TARGA PETROL,all<BR />PORSCHE,911 TARGA PETROL TURBO Y TURBO S,all<BR />PORSCHE,BOXSTER PETROL,all<BR />PORSCHE,718 SPYDER,all<BR />PORSCHE,CAYENNE/ COUPE HYBRID,all<BR />PORSCHE,CAYENNE/ COUPE HYBRID TURBO Y TURBO S,all<BR />PORSCHE,CAYENNE/ COUPE PETROL,all<BR />PORSCHE,CAYENNE/ COUPE PETROL TURBO Y TURBO S,all<BR />PORSCHE,CAYMAN PETROL,all<BR />PORSCHE,MACAN PETROL,all<BR />PORSCHE,MACAN PETROL TURBO Y TURBO S,all<BR />PORSCHE,PANAMERA PETROL FL 2020,all<BR />PORSCHE,PANAMERA PETROL TURBO Y TURBO S FL 2020,all<BR />PORSCHE,PANAMERA HYBRID FL 2020,all<BR />PORSCHE,PANAMERA HYB TURBO (S) FL 2020,all<BR />PORSCHE,TAYCAN ELECTRIC 4S,all<BR />PORSCHE,TAYCAN ELECTRIC TURBO Y TURBO S,all<BR />PORSCHE,TAYCAN ELECTRIC CROSS TURISMO 2021,all<BR />PORSCHE,TAYCAN ELECTRIC CROSS TURISMO TURBO Y TURBO S 2021,all<BR />PORSCHE,PANAMERA PETROL,all<BR />PORSCHE,PANAMERA PETROL TURBO Y TURBO S,all<BR />PORSCHE,PANAMERA HYBRID,all<BR />PORSCHE,PANAMERA HYBRID TURBO Y TURBO S,all<BR />SEAT,SEAT E-SCOOTER OWNER 2020,all<BR />SEAT,SEAT MINIMO,all<BR />SEAT,SEAT EMii 2019,all<BR />SEAT,SEAT IBIZA P FL 2021,all<BR />SEAT,SEAT IBIZA P FR FL 2021,all<BR />SEAT,SEAT LEON D 2020,all<BR />SEAT,SEAT LEON D FR 2020,all<BR />SEAT,SEAT LEON P 2020,all<BR />SEAT,SEAT LEON P FR 2020,all<BR />SEAT,SEAT LEON P MHEV 2020,all<BR />SEAT,SEAT LEON P MHEV FR 2020,all<BR />SEAT,SEAT LEON GNC 2020,all<BR />SEAT,SEAT LEON GNC FR 2020,all<BR />SEAT,SEAT LEON P PHEV 2020,all<BR />SEAT,SEAT LEON ST D 2020,all<BR />SEAT,SEAT LEON ST D FR 2020,all<BR />SEAT,SEAT LEON ST P 2020,all<BR />SEAT,SEAT LEON ST P FR 2020,all<BR />SEAT,SEAT LEON ST P MHEV 2020,all<BR />SEAT,SEAT LEON ST P MHEV FR 2020,all<BR />SEAT,SEAT LEON ST GNC 2020,all<BR />SEAT,SEAT LEON ST GNC FR 2020,all<BR />SEAT,SEAT LEON ST P PHEV 2020,all<BR />SEAT,SEAT LEON ST P PHEV FR 2020,all<BR />SEAT,SEAT ALHAMBRA FL 2015 P,all<BR />SEAT,SEAT ARONA P FL 2021,all<BR />SEAT,SEAT ARONA GNC FL 2021,all<BR />SEAT,SEAT ATECA D FL 2020,all<BR />SEAT,SEAT ATECA D FR FL 2020,all<BR />SEAT,SEAT ATECA P FL 2020,all<BR />SEAT,SEAT ATECA P FR FL 2020,all<BR />SEAT,SEAT TARRACO D 2018,all<BR />SEAT,SEAT TARRACO P 2018,all<BR />SEAT,SEAT TARRACO P PHEV 2021,all<BR />CUPRA,CUPRA BORN 2020,all<BR />CUPRA,CUPRA LEON P 2020,all<BR />CUPRA,CUPRA LEON P PHEV 2020,all<BR />CUPRA,CUPRA LEON ST P 2020,all<BR />CUPRA,CUPRA LEON ST P PHEV 2020,all<BR />CUPRA,CUPRA ATECA P FL 2020,all<BR />CUPRA,CUPRA FORMENTOR D 2020,all<BR />CUPRA,CUPRA FORMENTOR P 2020,all<BR />CUPRA,CUPRA FORMENTOR P 245CV 2020,all<BR />CUPRA,CUPRA FORMENTOR P 310CV 2020,all<BR />CUPRA,CUPRA FORMENTOR P PHEV 2020,all<BR />CUPRA,CUPRA FORMENTOR P PHEV 245CV 2020,all<BR />SEAT,SEAT Mii FL 2016,all<BR />SEAT,SEAT LEON D FL 2016,all<BR />SEAT,SEAT LEON DIESEL FR FL 2016,all<BR />SEAT,SEAT LEON P FL 2016,all<BR />SEAT,SEAT LEON PETROL FR FL 2016,all<BR />SEAT,SEAT LEON GNC FL 2016,all<BR />SEAT,SEAT LEON FR GNC FL 2016,all<BR />SEAT,SEAT LEON ST DIESEL FL 2016,all<BR />SEAT,SEAT LEON ST DIESEL FR FL 2016,all<BR />SEAT,SEAT LEON ST PETROL FL 2016,all<BR />SEAT,SEAT LEON ST PETROL FR FL 2016,all<BR />SEAT,SEAT LEON ST GNC FL 2016,all<BR />SEAT,SEAT LEON ST GNC FR FL 2016,all<BR />SEAT,SEAT ATECA D 2016,all<BR />SEAT,SEAT ATECA P 2016,all<BR />SEAT,SEAT TOLEDO IV DIESEL,all<BR />SEAT,SEAT TOLEDO IV PETROL,all<BR />CUPRA,SEAT LEON PETROL CUPRA FL 2016,all<BR />CUPRA,SEAT LEON ST PETROL CUPRA FL 2016,all<BR />CUPRA,CUPRA ATECA P 2016,all<BR />SKODA,SK ECITIGO 2019,all<BR />SKODA,SK FABIA P FL 2018,all<BR />SKODA,SK FABIA COMBI P FL 2017,all<BR />SKODA,SK SCALA P 2019,all<BR />SKODA,SK SCALA GNC 2019,all<BR />SKODA,SK OCTAVIA A8 D 2020,all<BR />SKODA,SK OCTAVIA A8 P 2020,all<BR />SKODA,SK OCTAVIA A8 P MHEV 2020,all<BR />SKODA,SK OCTAVIA A8 GNC 2020,all<BR />SKODA,SK OCTAVIA A8 PHEV 2020,all<BR />SKODA,SK OCTAVIA A8 COMBI D 2020,all<BR />SKODA,SK OCTAVIA A8 COMBI P 2020,all<BR />SKODA,SK OCTAVIA A8 COMBI P MHEV 2020,all<BR />SKODA,SK OCTAVIA A8 COMBI GNC 2020,all<BR />SKODA,SK OCTAVIA A8 COMBI PHEV 2020,all<BR />SKODA,SK SUPERB B8 D FL 2019,all<BR />SKODA,SK SUPERB B8 P FL 2019,all<BR />SKODA,SK SUPERB B8 IV PHEV 2020,all<BR />SKODA,SK SUPERB B8 COMBI D FL 2019,all<BR />SKODA,SK SUPERB B8 COMBI P FL 2019,all<BR />SKODA,SK SUPERB B8 COMBI IV PHEV 2020,all<BR />SKODA,SK KAMIQ P 2019,all<BR />SKODA,SK KAMIQ GNC 2019,all<BR />SKODA,SK KAROQ D 2017,all<BR />SKODA,SK KAROQ P 2017,all<BR />SKODA,SK KODIAQ D 2016,all<BR />SKODA,SK KODIAQ P 2016,all<BR />SKODA,SK KODIAQ D FL 2021,all<BR />SKODA,SK KODIAQ P FL 2021,all<BR />SKODA,SK ENYAQ 2021,all<BR />SKODA,SKODA CITIGO P 2011,all<BR />SKODA,SK SCALA D 2019,all<BR />SKODA,SK KAMIQ D 2019,all<BR />SKODA,SKODA SUPERB B8 D 2015,all<BR />SKODA,SKODA SUPERB B8 P 2015,all<BR />SKODA,SKODA SUPERB B8 COMBI D 2015,all<BR />SKODA,SKODA SUPERB B8 COMBI P 2015,all<BR />SKODA,SK OCTAVIA A7 D FL 2017,all<BR />SKODA,SK OCTAVIA A7 P FL 2017,all<BR />SKODA,SK OCTAVIA A7 GNC FL 2017,all<BR />SKODA,SK OCTAVIA A7 COMBI D FL 2017,all<BR />SKODA,SK OCTAVIA A7 COMBI P FL 2017,all<BR />SKODA,SK OCTAVIA A7 COMBI GNC FL 2017,all<BR />VW,VW ID3 2020,all<BR />VW,VW ID4 2020,all<BR />VW,VW EUP 2019,all<BR />VW,VW POLO P 2017,all<BR />VW,VW POLO P SPORT 2017,all<BR />VW,VW POLO P FL 2021,all<BR />VW,VW POLO P SPORT FL 2021,all<BR />VW,VW GOLF 8 D 2020,all<BR />VW,VW GOLF 8 D RLINE 2020,all<BR />VW,VW GOLF 8 P 2020,all<BR />VW,VW GOLF 8 P RLINE 2020,all<BR />VW,VW GOLF 8 P GTI 2020,all<BR />VW,VW GOLF 8 P MHEV DSG 2020,all<BR />VW,VW GOLF 8 P MHEV DSG RLINE 2020,all<BR />VW,VW GOLF 8 GNC 2020,all<BR />VW,VW GOLF 8 GTE 2020,all<BR />VW,VW GOLF 8 VARIANT D 2020,all<BR />VW,VW GOLF 8 VARIANT D RLINE 2020,all<BR />VW,VW GOLF 8 VARIANT P 2020,all<BR />VW,VW GOLF 8 VARIANT P RLINE 2020,all<BR />VW,VW GOLF 8 VARIANT P MHEV 2020,all<BR />VW,VW GOLF 8 VARIANT P MHEV RLINE 2020,all<BR />VW,VW GOLF 8 VARIANT GTE 2020,all<BR />VW,VW PASSAT B8 D FL 2019,all<BR />VW,VW PASSAT B8 D RLINE FL 2019,all<BR />VW,VW PASSAT B8 P FL 2019,all<BR />VW,VW PASSAT B8 P RLINE FL 2019,all<BR />VW,VW PASSAT B8 GTE FL 2019,all<BR />VW,VW PASSAT B8 VARIANT D FL 2019,all<BR />VW,VW PASSAT B8 VARIANT D RLINE FL 2019,all<BR />VW,VW PASSAT B8 VARIANT P FL 2019,all<BR />VW,VW PASSAT B8 VARIANT P RLINE FL 2019,all<BR />VW,VW PASSAT B8 VARIANT GTE FL2019,all<BR />VW,VW ARTEON D FL 2020,all<BR />VW,VW ARTEON P FL 2020,all<BR />VW,VW ARTEON P PHEV FL 2020,all<BR />VW,VW ARTEON SB D FL 2020,all<BR />VW,VW ARTEON SB P FL 2020,all<BR />VW,VW ARTEON SB P PHEV FL 2020,all<BR />VW,VW TCROSS P 2018,all<BR />VW,VW TROC D 2017,all<BR />VW,VW TROC P 2017,all<BR />VW,VW TROC P R 2017,all<BR />VW,VW TROC CABRIO P 2020,all<BR />VW,VW TROC D FL 2021,all<BR />VW,VW TROC P FL 2021,all<BR />VW,VW TROC P R FL 2021,all<BR />VW,VW TIGUAN D FL 2020,all<BR />VW,VW TIGUAN D SPORT FL 2020,all<BR />VW,VW TIGUAN P FL 2020,all<BR />VW,VW TIGUAN P SPORT FL 2020,all<BR />VW,VW TIGUAN P PHEV FL 2020,all<BR />VW,VW TIGUAN P PHEV RLINE FL 2020,all<BR />VW,VW TIGUAN ALLSPACE D 2017,all<BR />VW,VW TIGUAN ALLSPACE D SPORT 2017,all<BR />VW,VW TIGUAN ALLSPACE P 2017,all<BR />VW,VW TIGUAN ALLSPACE P SPORT 2017,all<BR />VW,VW TIGUAN ALLSPACE D FL 2021,all<BR />VW,VW TIGUAN ALLSPACE D R-LINE FL 2021,all<BR />VW,VW TIGUAN ALLSPACE P FL 2021,all<BR />VW,VW TIGUAN ALLSPACE P R-LINE FL 2021,all<BR />VW,VW TOUAREG D 2018,all<BR />VW,VW TOUAREG P 2018,all<BR />VW,VW TOUAREG P PHEV 2020,all<BR />VW,VW TOURAN D 2015,all<BR />VW,VW TOURAN P 2015,all<BR />VW,VW SHARAN D FL 2015,all<BR />VW,VW SHARAN P FL 2015,all<BR />VW,VW GOLF VII D FL 2017,all<BR />VW,VW GOLF VII D SPORT FL 2017,all<BR />VW,VW GOLF VII P FL 2017,all<BR />VW,VW GOLF VII P SPORT FL 2017,all<BR />VW,VW GOLF VII GTI FL 2017,all<BR />VW,VW GOLF VII P R FL 2017,all<BR />VW,VW GOLF VII TGI FL 2017,all<BR />VW,VW GOLF VII GTE FL 2017,all<BR />VW,VW EGOLF VII FL 2017,all<BR />VW,VW GOLF VII VARIANT D FL 2017,all<BR />VW,VW GOLF VII VARIANT D SPORT FL 2017,all<BR />VW,VW GOLF VII VARIANT P FL 2017,all<BR />VW,VW GOLF VII VARIANT P SPORT FL 2017,all<BR />VW,VW GOLF VII VARIANT TGI FL 2017,all<BR />VW,VW GOLF SPORTSVAN D FL 2017,all<BR />VW,VW GOLF SPORTSVAN P FL 2017,all<BR />VW,VW ARTEON D 2017,all<BR />VW,VW ARTEON P 2017,all<BR />VW,VW TIGUAN D 2016,all<BR />VW,VW TIGUAN D SPORT 2016,all<BR />VW,VW TIGUAN P 2016,all<BR />VW,VW TIGUAN P SPORT 2016,all<BR />VW LCV,VW ID Buzz People 2021,all<BR />VW LCV,VW ID Buzz Cargo 2021,all<BR />VW LCV,VW Caddy Kombi D 2020,all<BR />VW LCV,VW Caddy Kombi P 2020,all<BR />VW LCV,VW Caddy Kombi GNC 2020,all<BR />VW LCV,VW Caddy Maxi Kombi D 2020,all<BR />VW LCV,VW Caddy Maxi Kombi P 2020,all<BR />VW LCV,VW Caddy Maxi Kombi GNC 2020,all<BR />VW LCV,VW Caddy Life D 2020,all<BR />VW LCV,VW Caddy Life P 2020,all<BR />VW LCV,VW Caddy Life GNC 2020,all<BR />VW LCV,VW Caddy Maxi Life D 2020,all<BR />VW LCV,VW Caddy Maxi Life P 2020,all<BR />VW LCV,VW Caddy Maxi Life GNC 2020,all<BR />VW LCV,VW Caddy Cargo D 2020,all<BR />VW LCV,VW Caddy Cargo P 2020,all<BR />VW LCV,VW Caddy Cargo GNC 2020,all<BR />VW LCV,VW Caddy Maxi Cargo D 2020,all<BR />VW LCV,VW Caddy Maxi Cargo P 2020,all<BR />VW LCV,VW Caddy Maxi Cargo GNC 2020,all<BR />VW LCV,VW e-Caddy Maxi Furgón 2020,all<BR />VW LCV,VW T6 Furgón D FL 2019,all<BR />VW LCV,VW T6 eFurgón 2020,all<BR />VW LCV,VW T6 Mixto D FL 2019,all<BR />VW LCV,VW T6 Kombi D FL 2019,all<BR />VW LCV,VW T6 Caravelle D FL 2019,all<BR />VW LCV,VW T6 California D FL 2019,all<BR />VW LCV,VW T6 Multivan D FL 2019,all<BR />VW LCV,VW T7 Multivan D 2021,all<BR />VW LCV,VW T7 Multivan P 2021,all<BR />VW LCV,VW T7 Multivan P PHEV 2021,all<BR />VW LCV,VW T7 Multivan P PHEV 4M 2021,all<BR />VW LCV,VW Crafter Furgón D 2017,all<BR />MAN,MAN TGE D 2017,all<BR />VW LCV,VW Crafter Caja D 2017,all<BR />VW LCV,VW Crafter Fresh D 2017,all<BR />VW LCV,VW Crafte Grand California 2019,all<BR />VW LCV,VW ECrafter 2019,all<BR />VW LCV,VW Amarok D FL 2016,all<BR />MAN,MAN E-TGE,all<BR />VW LCV,VW Caddy Kombi D 2015,all<BR />VW LCV,VW Caddy Kombi P 2015,all<BR />VW LCV,VW Caddy Kombi GNC 2015,all<BR />VW LCV,VW Caddy Maxi Kombi D 2015,all<BR />VW LCV,VW Caddy Maxi Kombi P 2015,all<BR />VW LCV,VW Caddy Maxi Kombi GNC 2015,all<BR />VW LCV,VW Caddy Trend D 2015,all<BR />VW LCV,VW Caddy Trend P 2015,all<BR />VW LCV,VW Caddy Trend GNC 2015,all<BR />VW LCV,VW Caddy Maxi Trend D 2015,all<BR />VW LCV,VW Caddy Maxi Trend P 2015,all<BR />VW LCV,VW Caddy Maxi Trend GNC 2015,all<BR />VW LCV,VW Caddy Furgón D 2015,all<BR />VW LCV,VW Caddy Furgón Petrol 2015,all<BR />VW LCV,VW Caddy Furgón GNC 2015,all<BR />VW LCV,VW Caddy Maxi Furgón D 2015,all<BR />VW LCV,VW Caddy Maxi Furgón P 2015,all<BR />VW LCV,VW Caddy Maxi Furgón GNC 2015,all<BR />;;;;</P> <P>run;</P> Wed, 04 Aug 2021 19:40:36 GMT https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759467#M240014 acordes 2021-08-04T19:40:36Z Re: proc report align each across class top https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759470#M240015 <P>Hi:</P> <P>&nbsp; Without seeing your actual data, it is hard to speculate. However, using SASHELP.CARS and creating another "helper" variable called ROWORD, it is possible to have the rows collapse as you seem to want. You'll still need DUMMYVAR since you are trying to collapse a character value under an ACROSS item. You'll also need the "helper" variable which I show as ROWORD to allow the rows to collapse values the way you want.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Cynthia_sas_1-1628106081557.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/62266i8231429EC304F354/image-size/medium?v=v2&amp;px=400" role="button" title="Cynthia_sas_1-1628106081557.png" alt="Cynthia_sas_1-1628106081557.png" /></span></P> <P>Once you get it all working you can use NOPRINT on both ROWORD and DUMMYVAR.</P> <P>&nbsp;</P> <P>Cynthia</P> <P>&nbsp;</P> Wed, 04 Aug 2021 19:41:54 GMT https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759470#M240015 Cynthia_sas 2021-08-04T19:41:54Z Re: proc report align each across class top https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759474#M240017 <P>excellent, that works.</P> <P>understood.</P> Wed, 04 Aug 2021 19:51:45 GMT https://communities.sas.com/t5/SAS-Programming/proc-report-align-each-across-class-top/m-p/759474#M240017 acordes 2021-08-04T19:51:45Z