PROC Report

[vidyasagar1]

DATA HAVE;
 INFILE DATALINES;
 INPUT @1 SUP $6. @8 REC 1. @10 ERR 1. @12 DATE $8. @21 E_C $1. @23 R_C $2. @26 C_A $2. 
 @29 P_A $2. @32 S_C $2. @35 E_D $2.;
 DATALINES;
AAAAAA 9 0 1/1/2020 Y NA NA NA NA NA
AAAAAA 8 2 2/1/2020 Y NA NA NA NA NA
AAAAAA 7 5 3/1/2020 Y NA NA NA NA NA
BBBBBB 8 3 1/1/2020 N NA NA NA NA NA
BBBBBB 6 5 2/1/2020 N NA NA NA NA NA
BBBBBB 8 7 3/1/2020 N NA NA NA NA NA
CCCCCC 8 2 1/1/2020						
CCCCCC 2 1 2/1/2020						
CCCCCC 3 1 3/1/2020						
DDDDDD 9 3 1/1/2020						
DDDDDD 6 2 2/1/2020						
;
RUN;

I have a data like above and i need to get the output like below using proc report.

Any help would be greatly appreciated.

[PaigeMiller]

Most of us will not download or open Microsoft Office documents, as they are a security risk. Please just show us the desired output in your message.

[vidyasagar1]

Hi, I have added the screenshot of the required output in my message, could you please help me with the code.

[ed_sas_member · Accepted solution]

Hi @vidyasagar1 

Please try this:

proc report data=have missing;
	column sup date, (rec err) E_C R_C C_A P_A S_C E_D;
	define sup / group;
	define date / across;
	define rec / sum;
	define err / sum;
	define E_C / group;
	define R_C / group;
	define C_A / group;
	define P_A / group;
	define S_C / group;
	define E_D / group;
run;

Best,

[vidyasagar1]

Hi, Thank you so much.
The code is working for me to get the output as desired.
I appreciate your help.

[ed_sas_member]

Thank you @vidyasagar1. You're welcome