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.
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;
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;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: