topic CUSTOMIZED REPORT USING PROC REPORT in SAS Procedures

CUSTOMIZED REPORT USING PROC REPORT

vidyasagar1 — Thu, 18 Jun 2020 17:01:26 GMT

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;

Anyone please help me to get the output like below with the above data using PROC REPORT.

Re: CUSTOMIZED REPORT USING PROC REPORT

vidyasagar1 — Fri, 19 Jun 2020 07:57:41 GMT

Using the below code but not getting the desired output.

PROC REPORT DATA=HAVE out=WANT nowd;
COLUMN SUP DATE,(REC ERR ) E_C R_C C_A P_A S_C E_D;
DEFINE SUP / group order=data;
DEFINE DATE / ACROSS ;
RUN;

Re: CUSTOMIZED REPORT USING PROC REPORT

Ksharp — Fri, 19 Jun 2020 11:54:56 GMT

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;


proc report data=have nowd;
columns sup date,(rec err) e_c r_c c_a;
define sup/group;
define e_c/group missing;
define r_c/group missing;
define c_a/group missing;
define date/across;
run;

Re: CUSTOMIZED REPORT USING PROC REPORT

vidyasagar1 — Mon, 22 Jun 2020 12:08:54 GMT

Thank you .. 🙂
The code is working to get the desired output..