cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
acordes
Rhodochrosite | Level 12 acordes
Rhodochrosite | Level 12
Go to Solution

proc report align each across class top

Posted 08-04-2021 03:18 PM (556 views)

Hi @Cynthia_sas 

 

Can I achieve directly in proc report that each new across class begins with the non missing model values?

I want the output to align on top.

 

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;

rep.png

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ Cynthia_sas
SAS Super FREQ

Re: proc report align each across class top

Posted 08-04-2021 03:41 PM (528 views)  |   In reply to acordes

Hi:

  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.

Cynthia_sas_1-1628106081557.png

Once you get it all working you can use NOPRINT on both ROWORD and DUMMYVAR.

 

Cynthia

 

View solution in original post

4 REPLIES 4
Reeza
Super User Reeza
Super User

Re: proc report align each across class top

Posted 08-04-2021 03:29 PM (548 views)  |   In reply to acordes

Show your input data structure please. FYI - if you post screenshots we can only post solution approaches and not code.
If you want code assistance please ensure you provide data in a usable format, preferably a data step.

 

FYI - I suspect the answer is no and proc transpose is an easier solution overall.

 

Spoiler
Transposing data tutorials:
Long to Wide:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/

Wide to Long:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/

And sometimes a double transpose is needed for extra wide data sets:
https://gist.github.com/statgeek/2321b6f62ab78d5bf2b0a5a8626bd7cd
acordes
Rhodochrosite | Level 12 acordes
Rhodochrosite | Level 12

Re: proc report align each across class top

Posted 08-04-2021 03:40 PM (529 views)  |   In reply to Reeza

sure.

data RISKNOBA.JG_HQJUL2;
infile datalines dsd truncover;
input BRAND:$11. MODEL:$50. scope:$3.;
datalines4;
AUDI,AUDI A1 SB P 2018,all
AUDI,AUDI A1 CITYCARVER P 2019,all
AUDI,AUDI A3 SB D 2020,all
AUDI,AUDI A3 SB P 2020,all
AUDI,AUDI S3 SB P 2020,all
AUDI,AUDI A3 SB P MHEV 2020,all
AUDI,AUDI A3 SB Etron 2020,all
AUDI,AUDI A3 SEDAN D 2020,all
AUDI,AUDI A3 SEDAN P 2020,all
AUDI,AUDI S3-RS3 SEDAN P 2020,all
AUDI,AUDI A3 SEDAN P MHEV 2020,all
AUDI,AUDI A4 D MHEV FL 2019,all
AUDI,AUDI S4 D MHEV FL 2019,all
AUDI,AUDI A4 P MHEV FL 2019,all
AUDI,AUDI A4 AVANT D MHEV FL 2019,all
AUDI,AUDI A4 ALLROAD D MHEV FL 2019,all
AUDI,AUDI S4 AVANT D MHEV FL 2019,all
AUDI,AUDI A4 AVANT P MHEV FL 2019,all
AUDI,AUDI A4 ALLROAD P MHEV FL 2019,all
AUDI,AUDI RS4 AVANT P MHEV FL 2019,all
AUDI,AUDI A5 SB D MHEV FL 2019,all
AUDI,AUDI S5 SB D MHEV FL 2019,all
AUDI,AUDI A5 SB P MHEV FL 2019,all
AUDI,AUDI RS5 SB P FL 2019,all
AUDI,AUDI A5 D MHEV FL 2019,all
AUDI,AUDI S5 D MHEV FL 2019,all
AUDI,AUDI A5 P MHEV FL 2019,all
AUDI,AUDI RS5 P FL 2019,all
AUDI,AUDI A5 Cabrio D MHEV FL 2019,all
AUDI,AUDI A5 Cabrio P MHEV FL 2019,all
AUDI,AUDI A6 Berlina D MHEV 2018,all
AUDI,AUDI S6 Berlina D MHEV 2018,all
AUDI,AUDI A6 Berlina P MHEV 2018,all
AUDI,AUDI A6 Berlina P PHEV 2018,all
AUDI,AUDI A6 Avant D MHEV 2018,all
AUDI,AUDI S6 AVANT D MHEV 2018,all
AUDI,AUDI A6 Avant P MHEV 2018,all
AUDI,AUDI RS6 AVANT P MHEV 2018,all
AUDI,AUDI A6 Avant P PHEV 2018,all
AUDI,AUDI A7 SB D MHEV 2018,all
AUDI,AUDI S7 SB D MHEV 2018,all
AUDI,AUDI A7 SB P MHEV 2018,all
AUDI,AUDI RS7 SB P MHEV 2018,all
AUDI,AUDI A7 SB P PHEV 2018,all
AUDI,AUDI A8 D MHEV 2017,all
AUDI,AUDI A8 P MHEV 2017,all
AUDI,AUDI S8 P MHEV 2017,all
AUDI,AUDI A8 P PHEV 2017,all
AUDI,AUDI Q2 D FL 2020,all
AUDI,AUDI Q2 P FL 2020,all
AUDI,AUDI SQ2 P FL 2020,all
AUDI,AUDI Q3 D 2018,all
AUDI,AUDI Q3 P 2018,all
AUDI,AUDI RSQ3 P 2018,all
AUDI,AUDI Q3 P MHEV 2018,all
AUDI,AUDI Q3 P PHEV 2018,all
AUDI,AUDI Q3 SB D 2019,all
AUDI,AUDI Q3 SB P 2019,all
AUDI,AUDI RSQ3 SB P 2019,all
AUDI,AUDI Q3 SB P MHEV 2019,all
AUDI,AUDI Q3 SB P PHEV 2019,all
AUDI,AUDI Q5 D MHEV FL 2020,all
AUDI,AUDI SQ5 D FL 2020,all
AUDI,AUDI Q5 P MHEV FL 2020,all
AUDI,AUDI RSQ5 P FL 2020,all
AUDI,AUDI Q5 P PHEV FL 2020,all
AUDI,AUDI Q5 SB D MHEV 2021,all
AUDI,AUDI SQ5 SB D MHEV 2021,all
AUDI,AUDI Q5 SB P MHEV 2021,all
AUDI,AUDI Q5 SB P PHEV 2021,all
AUDI,AUDI Q7 D MHEV FL 2019,all
AUDI,AUDI Q7 P MHEV FL 2019,all
AUDI,AUDI SQ7 P FL 2019,all
AUDI,AUDI Q7 P PHEV FL 2019,all
AUDI,AUDI Q8 D MHEV 2018,all
AUDI,AUDI Q8 P MHEV 2018,all
AUDI,AUDI SQ8 P MHEV 2018,all
AUDI,AUDI RSQ8 P MHEV 2018,all
AUDI,AUDI Q8 P PHEV 2020,all
AUDI,AUDI E-TRON,all
AUDI,AUDI E-TRON SPORTBACK,all
AUDI,AUDI Q4 E-TRON 2021,all
AUDI,AUDI Q4 SB E-TRON 2021,all
AUDI,AUDI E-TRON GT 2021,all
AUDI,AUDI E-TRON GT RS 2021,all
AUDI,AUDI R8 2015,all
AUDI,AUDI TT COUPE P 2014,all
AUDI,AUDI TT ROADSTER P 2014,all
AUDI,AUDI A3 SB D FL 2016,all
AUDI,AUDI A3 SB P FL2016,all
AUDI,AUDI S3-RS3 SB P FL2017,all
AUDI,AUDI A3 G-tron SB FL 2016,all
AUDI,AUDI A3 E-tron SB 2019,all
AUDI,AUDI A3 CABRIO P 2014,all
AUDI,AUDI S3 CABRIO P FL 2017,all
AUDI,AUDI A3 SEDAN D FL 2016,all
AUDI,AUDI A3 SEDAN P FL 2016,all
AUDI,AUDI S3-RS3 SEDAN P FL 2017,all
AUDI,AUDI A4 D FL 2019,all
AUDI,AUDI A4 AVANT D FL 2019,all
AUDI,AUDI A4 ALLROAD D FL 2019,all
AUDI,AUDI A4 Avant GTRON FL 2019,all
AUDI,AUDI A5 SB D FL 2019,all
AUDI,AUDI A5 D FL 2019,all
AUDI,AUDI A5 Cabrio D FL 2019,all
AUDI,AUDI Q2 D 2016,all
AUDI,AUDI Q2 P 2016,all
AUDI,AUDI SQ2 P 2016,all
AUDI,AUDI Q5 D 2016,all
AUDI,AUDI Q5 D MHEV 2016,all
AUDI,AUDI SQ5 D MHEV 2016,all
AUDI,AUDI Q5 P MHEV 2016,all
AUDI,AUDI Q5 P PHEV 2016,all
AUDI,AUDI SQ7 D FL 2019,all
AUDI,AUDI SQ8 D MHEV 2018,all
BENTLEY,FLYING SPUR FL 2020,all
BENTLEY,CONTINENTAL GT 2018,all
BENTLEY,CONTINENTAL GT CONVERTIBLE 2019,all
BENTLEY,BENTAYGA 2016,all
BENTLEY,BENTAYGA SPEED 2016,all
BENTLEY,BENTAYGA HYBRID 2016,all
BENTLEY,MULSANNE FL 2016,all
LAMBORGHINI,AVENTADOR COUPÉ 2013,all
LAMBORGHINI,AVENTADOR ROADSTER 2013,all
LAMBORGHINI,HURACÁN COUPÉ 2014,all
LAMBORGHINI,HURACÁN SPYDER 2014,all
LAMBORGHINI,URUS 2018,all
PORSCHE,911 COUPÉ PETROL,all
PORSCHE,911 COUPÉ PETROL TURBO Y TURBO S,all
PORSCHE,911 CABRIO PETROL,all
PORSCHE,911 CABRIO PETROL TURBO Y TURBO S,all
PORSCHE,911 TARGA PETROL,all
PORSCHE,911 TARGA PETROL TURBO Y TURBO S,all
PORSCHE,BOXSTER PETROL,all
PORSCHE,718 SPYDER,all
PORSCHE,CAYENNE/ COUPE HYBRID,all
PORSCHE,CAYENNE/ COUPE HYBRID TURBO Y TURBO S,all
PORSCHE,CAYENNE/ COUPE PETROL,all
PORSCHE,CAYENNE/ COUPE PETROL TURBO Y TURBO S,all
PORSCHE,CAYMAN PETROL,all
PORSCHE,MACAN PETROL,all
PORSCHE,MACAN PETROL TURBO Y TURBO S,all
PORSCHE,PANAMERA PETROL FL 2020,all
PORSCHE,PANAMERA PETROL TURBO Y TURBO S FL 2020,all
PORSCHE,PANAMERA HYBRID FL 2020,all
PORSCHE,PANAMERA HYB TURBO (S) FL 2020,all
PORSCHE,TAYCAN ELECTRIC 4S,all
PORSCHE,TAYCAN ELECTRIC TURBO Y TURBO S,all
PORSCHE,TAYCAN ELECTRIC CROSS TURISMO 2021,all
PORSCHE,TAYCAN ELECTRIC CROSS TURISMO TURBO Y TURBO S 2021,all
PORSCHE,PANAMERA PETROL,all
PORSCHE,PANAMERA PETROL TURBO Y TURBO S,all
PORSCHE,PANAMERA HYBRID,all
PORSCHE,PANAMERA HYBRID TURBO Y TURBO S,all
SEAT,SEAT E-SCOOTER OWNER 2020,all
SEAT,SEAT MINIMO,all
SEAT,SEAT EMii 2019,all
SEAT,SEAT IBIZA P FL 2021,all
SEAT,SEAT IBIZA P FR FL 2021,all
SEAT,SEAT LEON D 2020,all
SEAT,SEAT LEON D FR 2020,all
SEAT,SEAT LEON P 2020,all
SEAT,SEAT LEON P FR 2020,all
SEAT,SEAT LEON P MHEV 2020,all
SEAT,SEAT LEON P MHEV FR 2020,all
SEAT,SEAT LEON GNC 2020,all
SEAT,SEAT LEON GNC FR 2020,all
SEAT,SEAT LEON P PHEV 2020,all
SEAT,SEAT LEON ST D 2020,all
SEAT,SEAT LEON ST D FR 2020,all
SEAT,SEAT LEON ST P 2020,all
SEAT,SEAT LEON ST P FR 2020,all
SEAT,SEAT LEON ST P MHEV 2020,all
SEAT,SEAT LEON ST P MHEV FR 2020,all
SEAT,SEAT LEON ST GNC 2020,all
SEAT,SEAT LEON ST GNC FR 2020,all
SEAT,SEAT LEON ST P PHEV 2020,all
SEAT,SEAT LEON ST P PHEV FR 2020,all
SEAT,SEAT ALHAMBRA FL 2015 P,all
SEAT,SEAT ARONA P FL 2021,all
SEAT,SEAT ARONA GNC FL 2021,all
SEAT,SEAT ATECA D FL 2020,all
SEAT,SEAT ATECA D FR FL 2020,all
SEAT,SEAT ATECA P FL 2020,all
SEAT,SEAT ATECA P FR FL 2020,all
SEAT,SEAT TARRACO D 2018,all
SEAT,SEAT TARRACO P 2018,all
SEAT,SEAT TARRACO P PHEV 2021,all
CUPRA,CUPRA BORN 2020,all
CUPRA,CUPRA LEON P 2020,all
CUPRA,CUPRA LEON P PHEV 2020,all
CUPRA,CUPRA LEON ST P 2020,all
CUPRA,CUPRA LEON ST P PHEV 2020,all
CUPRA,CUPRA ATECA P FL 2020,all
CUPRA,CUPRA FORMENTOR D 2020,all
CUPRA,CUPRA FORMENTOR P 2020,all
CUPRA,CUPRA FORMENTOR P 245CV 2020,all
CUPRA,CUPRA FORMENTOR P 310CV 2020,all
CUPRA,CUPRA FORMENTOR P PHEV 2020,all
CUPRA,CUPRA FORMENTOR P PHEV 245CV 2020,all
SEAT,SEAT Mii FL 2016,all
SEAT,SEAT LEON D FL 2016,all
SEAT,SEAT LEON DIESEL FR FL 2016,all
SEAT,SEAT LEON P FL 2016,all
SEAT,SEAT LEON PETROL FR FL 2016,all
SEAT,SEAT LEON GNC FL 2016,all
SEAT,SEAT LEON FR GNC FL 2016,all
SEAT,SEAT LEON ST DIESEL FL 2016,all
SEAT,SEAT LEON ST DIESEL FR FL 2016,all
SEAT,SEAT LEON ST PETROL FL 2016,all
SEAT,SEAT LEON ST PETROL FR FL 2016,all
SEAT,SEAT LEON ST GNC FL 2016,all
SEAT,SEAT LEON ST GNC FR FL 2016,all
SEAT,SEAT ATECA D 2016,all
SEAT,SEAT ATECA P 2016,all
SEAT,SEAT TOLEDO IV DIESEL,all
SEAT,SEAT TOLEDO IV PETROL,all
CUPRA,SEAT LEON PETROL CUPRA FL 2016,all
CUPRA,SEAT LEON ST PETROL CUPRA FL 2016,all
CUPRA,CUPRA ATECA P 2016,all
SKODA,SK ECITIGO 2019,all
SKODA,SK FABIA P FL 2018,all
SKODA,SK FABIA COMBI P FL 2017,all
SKODA,SK SCALA P 2019,all
SKODA,SK SCALA GNC 2019,all
SKODA,SK OCTAVIA A8 D 2020,all
SKODA,SK OCTAVIA A8 P 2020,all
SKODA,SK OCTAVIA A8 P MHEV 2020,all
SKODA,SK OCTAVIA A8 GNC 2020,all
SKODA,SK OCTAVIA A8 PHEV 2020,all
SKODA,SK OCTAVIA A8 COMBI D 2020,all
SKODA,SK OCTAVIA A8 COMBI P 2020,all
SKODA,SK OCTAVIA A8 COMBI P MHEV 2020,all
SKODA,SK OCTAVIA A8 COMBI GNC 2020,all
SKODA,SK OCTAVIA A8 COMBI PHEV 2020,all
SKODA,SK SUPERB B8 D FL 2019,all
SKODA,SK SUPERB B8 P FL 2019,all
SKODA,SK SUPERB B8 IV PHEV 2020,all
SKODA,SK SUPERB B8 COMBI D FL 2019,all
SKODA,SK SUPERB B8 COMBI P FL 2019,all
SKODA,SK SUPERB B8 COMBI IV PHEV 2020,all
SKODA,SK KAMIQ P 2019,all
SKODA,SK KAMIQ GNC 2019,all
SKODA,SK KAROQ D 2017,all
SKODA,SK KAROQ P 2017,all
SKODA,SK KODIAQ D 2016,all
SKODA,SK KODIAQ P 2016,all
SKODA,SK KODIAQ D FL 2021,all
SKODA,SK KODIAQ P FL 2021,all
SKODA,SK ENYAQ 2021,all
SKODA,SKODA CITIGO P 2011,all
SKODA,SK SCALA D 2019,all
SKODA,SK KAMIQ D 2019,all
SKODA,SKODA SUPERB B8 D 2015,all
SKODA,SKODA SUPERB B8 P 2015,all
SKODA,SKODA SUPERB B8 COMBI D 2015,all
SKODA,SKODA SUPERB B8 COMBI P 2015,all
SKODA,SK OCTAVIA A7 D FL 2017,all
SKODA,SK OCTAVIA A7 P FL 2017,all
SKODA,SK OCTAVIA A7 GNC FL 2017,all
SKODA,SK OCTAVIA A7 COMBI D FL 2017,all
SKODA,SK OCTAVIA A7 COMBI P FL 2017,all
SKODA,SK OCTAVIA A7 COMBI GNC FL 2017,all
VW,VW ID3 2020,all
VW,VW ID4 2020,all
VW,VW EUP 2019,all
VW,VW POLO P 2017,all
VW,VW POLO P SPORT 2017,all
VW,VW POLO P FL 2021,all
VW,VW POLO P SPORT FL 2021,all
VW,VW GOLF 8 D 2020,all
VW,VW GOLF 8 D RLINE 2020,all
VW,VW GOLF 8 P 2020,all
VW,VW GOLF 8 P RLINE 2020,all
VW,VW GOLF 8 P GTI 2020,all
VW,VW GOLF 8 P MHEV DSG 2020,all
VW,VW GOLF 8 P MHEV DSG RLINE 2020,all
VW,VW GOLF 8 GNC 2020,all
VW,VW GOLF 8 GTE 2020,all
VW,VW GOLF 8 VARIANT D 2020,all
VW,VW GOLF 8 VARIANT D RLINE 2020,all
VW,VW GOLF 8 VARIANT P 2020,all
VW,VW GOLF 8 VARIANT P RLINE 2020,all
VW,VW GOLF 8 VARIANT P MHEV 2020,all
VW,VW GOLF 8 VARIANT P MHEV RLINE 2020,all
VW,VW GOLF 8 VARIANT GTE 2020,all
VW,VW PASSAT B8 D FL 2019,all
VW,VW PASSAT B8 D RLINE FL 2019,all
VW,VW PASSAT B8 P FL 2019,all
VW,VW PASSAT B8 P RLINE FL 2019,all
VW,VW PASSAT B8 GTE FL 2019,all
VW,VW PASSAT B8 VARIANT D FL 2019,all
VW,VW PASSAT B8 VARIANT D RLINE FL 2019,all
VW,VW PASSAT B8 VARIANT P FL 2019,all
VW,VW PASSAT B8 VARIANT P RLINE FL 2019,all
VW,VW PASSAT B8 VARIANT GTE FL2019,all
VW,VW ARTEON D FL 2020,all
VW,VW ARTEON P FL 2020,all
VW,VW ARTEON P PHEV FL 2020,all
VW,VW ARTEON SB D FL 2020,all
VW,VW ARTEON SB P FL 2020,all
VW,VW ARTEON SB P PHEV FL 2020,all
VW,VW TCROSS P 2018,all
VW,VW TROC D 2017,all
VW,VW TROC P 2017,all
VW,VW TROC P R 2017,all
VW,VW TROC CABRIO P 2020,all
VW,VW TROC D FL 2021,all
VW,VW TROC P FL 2021,all
VW,VW TROC P R FL 2021,all
VW,VW TIGUAN D FL 2020,all
VW,VW TIGUAN D SPORT FL 2020,all
VW,VW TIGUAN P FL 2020,all
VW,VW TIGUAN P SPORT FL 2020,all
VW,VW TIGUAN P PHEV FL 2020,all
VW,VW TIGUAN P PHEV RLINE FL 2020,all
VW,VW TIGUAN ALLSPACE D 2017,all
VW,VW TIGUAN ALLSPACE D SPORT 2017,all
VW,VW TIGUAN ALLSPACE P 2017,all
VW,VW TIGUAN ALLSPACE P SPORT 2017,all
VW,VW TIGUAN ALLSPACE D FL 2021,all
VW,VW TIGUAN ALLSPACE D R-LINE FL 2021,all
VW,VW TIGUAN ALLSPACE P FL 2021,all
VW,VW TIGUAN ALLSPACE P R-LINE FL 2021,all
VW,VW TOUAREG D 2018,all
VW,VW TOUAREG P 2018,all
VW,VW TOUAREG P PHEV 2020,all
VW,VW TOURAN D 2015,all
VW,VW TOURAN P 2015,all
VW,VW SHARAN D FL 2015,all
VW,VW SHARAN P FL 2015,all
VW,VW GOLF VII D FL 2017,all
VW,VW GOLF VII D SPORT FL 2017,all
VW,VW GOLF VII P FL 2017,all
VW,VW GOLF VII P SPORT FL 2017,all
VW,VW GOLF VII GTI FL 2017,all
VW,VW GOLF VII P R FL 2017,all
VW,VW GOLF VII TGI FL 2017,all
VW,VW GOLF VII GTE FL 2017,all
VW,VW EGOLF VII FL 2017,all
VW,VW GOLF VII VARIANT D FL 2017,all
VW,VW GOLF VII VARIANT D SPORT FL 2017,all
VW,VW GOLF VII VARIANT P FL 2017,all
VW,VW GOLF VII VARIANT P SPORT FL 2017,all
VW,VW GOLF VII VARIANT TGI FL 2017,all
VW,VW GOLF SPORTSVAN D FL 2017,all
VW,VW GOLF SPORTSVAN P FL 2017,all
VW,VW ARTEON D 2017,all
VW,VW ARTEON P 2017,all
VW,VW TIGUAN D 2016,all
VW,VW TIGUAN D SPORT 2016,all
VW,VW TIGUAN P 2016,all
VW,VW TIGUAN P SPORT 2016,all
VW LCV,VW ID Buzz People 2021,all
VW LCV,VW ID Buzz Cargo 2021,all
VW LCV,VW Caddy Kombi D 2020,all
VW LCV,VW Caddy Kombi P 2020,all
VW LCV,VW Caddy Kombi GNC 2020,all
VW LCV,VW Caddy Maxi Kombi D 2020,all
VW LCV,VW Caddy Maxi Kombi P 2020,all
VW LCV,VW Caddy Maxi Kombi GNC 2020,all
VW LCV,VW Caddy Life D 2020,all
VW LCV,VW Caddy Life P 2020,all
VW LCV,VW Caddy Life GNC 2020,all
VW LCV,VW Caddy Maxi Life D 2020,all
VW LCV,VW Caddy Maxi Life P 2020,all
VW LCV,VW Caddy Maxi Life GNC 2020,all
VW LCV,VW Caddy Cargo D 2020,all
VW LCV,VW Caddy Cargo P 2020,all
VW LCV,VW Caddy Cargo GNC 2020,all
VW LCV,VW Caddy Maxi Cargo D 2020,all
VW LCV,VW Caddy Maxi Cargo P 2020,all
VW LCV,VW Caddy Maxi Cargo GNC 2020,all
VW LCV,VW e-Caddy Maxi Furgón 2020,all
VW LCV,VW T6 Furgón D FL 2019,all
VW LCV,VW T6 eFurgón 2020,all
VW LCV,VW T6 Mixto D FL 2019,all
VW LCV,VW T6 Kombi D FL 2019,all
VW LCV,VW T6 Caravelle D FL 2019,all
VW LCV,VW T6 California D FL 2019,all
VW LCV,VW T6 Multivan D FL 2019,all
VW LCV,VW T7 Multivan D 2021,all
VW LCV,VW T7 Multivan P 2021,all
VW LCV,VW T7 Multivan P PHEV 2021,all
VW LCV,VW T7 Multivan P PHEV 4M 2021,all
VW LCV,VW Crafter Furgón D 2017,all
MAN,MAN TGE D 2017,all
VW LCV,VW Crafter Caja D 2017,all
VW LCV,VW Crafter Fresh D 2017,all
VW LCV,VW Crafte Grand California 2019,all
VW LCV,VW ECrafter 2019,all
VW LCV,VW Amarok D FL 2016,all
MAN,MAN E-TGE,all
VW LCV,VW Caddy Kombi D 2015,all
VW LCV,VW Caddy Kombi P 2015,all
VW LCV,VW Caddy Kombi GNC 2015,all
VW LCV,VW Caddy Maxi Kombi D 2015,all
VW LCV,VW Caddy Maxi Kombi P 2015,all
VW LCV,VW Caddy Maxi Kombi GNC 2015,all
VW LCV,VW Caddy Trend D 2015,all
VW LCV,VW Caddy Trend P 2015,all
VW LCV,VW Caddy Trend GNC 2015,all
VW LCV,VW Caddy Maxi Trend D 2015,all
VW LCV,VW Caddy Maxi Trend P 2015,all
VW LCV,VW Caddy Maxi Trend GNC 2015,all
VW LCV,VW Caddy Furgón D 2015,all
VW LCV,VW Caddy Furgón Petrol 2015,all
VW LCV,VW Caddy Furgón GNC 2015,all
VW LCV,VW Caddy Maxi Furgón D 2015,all
VW LCV,VW Caddy Maxi Furgón P 2015,all
VW LCV,VW Caddy Maxi Furgón GNC 2015,all
;;;;

run;

0 Likes
Cynthia_sas
SAS Super FREQ Cynthia_sas
SAS Super FREQ

Re: proc report align each across class top

Posted 08-04-2021 03:41 PM (529 views)  |   In reply to acordes

Hi:

  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.

Cynthia_sas_1-1628106081557.png

Once you get it all working you can use NOPRINT on both ROWORD and DUMMYVAR.

 

Cynthia

 

acordes
Rhodochrosite | Level 12 acordes
Rhodochrosite | Level 12

Re: proc report align each across class top

Posted 08-04-2021 03:51 PM (523 views)  |   In reply to Cynthia_sas

excellent, that works.

understood.

0 Likes

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • ‎08-04-2021 03:18 PM
  • 557 views
  • 3 likes
  • 3 in conversation