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.
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,
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.
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,
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.
Ready to level-up your skills? Choose your own adventure.