topic Re: How to program this report for the desired output (how to suppress multiple rows as single row) in SAS Programming

How to program this report for the desired output (how to suppress multiple rows as single row)

buddha_d — Sat, 29 Aug 2020 05:07:33 GMT

Guys, I have building a report as shown below. Can anyone help me to obtain that?

data cars (DROP=MODEL);
	set sashelp.cars;
run;

PROC SQL;
	CREATE TABLE HAVE AS 
	SELECT make,origin,type,drivetrain,Cylinders,enginesize,MSRP,invoice,horsepower,
			WEIGHT,WHEELBASE,LENGTH
	FROM CARS
	WHERE MAKE='Audi'
	GROUP BY MAKE,ORIGIN,TYPE,DRIVETRAIN,CYLINDERS
	order by MAKE,ORIGIN,TYPE,DRIVETRAIN,CYLINDERS
	;
QUIT;

I want my output to look like this either in SAS or excel (prior to proc export step).

Thanks in advance

Re: How to program this report for the desired output (how to suppress multiple rows as single row)

Shmuel — Sat, 29 Aug 2020 05:46:59 GMT

proc report data=have nofs headline;
   column make origin type drivetrain Cylinders enginesize
          MSRP invoice horsepower WEIGHT WHEELBASE LENGTH;
   define make / order;
   define origin  / order;
   define type  / order;
   define drivetrain  / order;
   define Cylinders  / order;
   define enginesize / display;
   define MSRP / display;
   define invoice / display;
   define horsepower / display;
   define WEIGHT / display;
   define WHEELBASE / display;
   define LENGTH / display;
run;

Re: How to program this report for the desired output (how to suppress multiple rows as single row)

buddha_d — Sat, 29 Aug 2020 11:14:39 GMT

Thanks Shmuel