Hello, Could you pls suggest me how can i get Overall mean and mean for scores by Gender using PROC SUMMARY. See the  dataset and the output tables i want; I'm struggling to get the Overall Mean for Score1 and Score 2 according to Gender (Male, Female).  data Made; ID Gender Score1 Score2 101 M 10 8 102 F 9 12 103 M 7 5 104 F 5 8   output want; Gender  All (mean) Score1 (mean) Score2 (mean) M       F       Total (mean)         Thank you, Akter ... View more

Dear Connection, I want to create a single variable from Multiple variable and make those multiple variable as category of the single variable and calculate Total, n and % for each category. I will have to create 5 or more such single variable from 25 variable (for multiple response). I'm not sure if its possible, If it is possible it would save my lots our Data team time. See the data below as Have and output table 'Output Want' in the attached file. I really appreciate time and effort. Male=1 and Female=2   Data have; ID    Gender QA_1 QA_2 QA_3 QA_4 QB_1 QB_2 QB_3 QB_4 001   1          1   0   0   0   1   1   0   1 002   2          1   1   0   0   0   1   1   0 003   1          0   0   1   0   1   1   0  1 004   2          0   1   0   1   1   0   1  0 005  1          1   0   1   0   1   1   0   0   Output want is in the attached file.  ... View more

Hi All, I'm struggling to generate the below output table "Output" from the below made dataset 'Have'. Your help will be highly appreciated. Cat, Dog and Birds are multiple response variable for each Subject ID. Want to generate output table as below  output table (Response Category by Total and Sex).  Data Have; Id     Cat   Dog   Bird   SEX 01     1       0       1         M 02     0       1       1         F 03     1       1       0         M 04     0       1       1         F 05     1       0       0         M    Output table:  Response Total Male Female N n % N n % N n % Cat 5 4 80% 3 3 100% 2 0 0 Dog 5 3 60% 3 1 33.30% 2 2 100 Bird 5 3 60% 3 1 33.30% 2 2 100 N=Total Obs (0 and 1), n=# of 1 (one) Really appreciate your help! ... View more

Hi All, I want to change values of my columns (Q1-5) where there is '1' with different values in each column i.e for Q1, 1 will be remain same as 1 but in col 2, for the value '1' will replace by 2 similarly col3, col 4, col 5 for the value of 1 will value be replaced by 3, 4, 5 as in "data want_1". Finally i want the dataset from wider to longer n(as in Data want_2). Probably using ARRAY:   Really appreciate your help! Akter   data main; Input  ID Q1-Q5; Datalines; 1 1 0 0 0 0 2 0 1 0 0 1 3 0 0 0 1 1 4 1 1 0 0 0 5 0 0 1 0 0 ; run; Data want_1; ID Q1 Q2 Q3 Q4 Q5 1  1    0    0    0    0 2  0    2    0    0    5 3  0    0    0    4    5 4  1    2    0    0   0 5  0    0    3    0   0   data want_2: Id  New_Var 1    1 2    2 2    5 3    4 3    5 4    1 4    2 5    3 ... View more

I tried this below program its working in my SAS Base 9.4 version but not working in SAS Studio. Could you pls help me why is it, Is there anything i'm missing- ############## %let N=120; data CIop; do i=117 to &N; retain N x p L U alpha; p=i/&N; alpha=0.05; if p=0 then L=0; if p=1 then U=1; if p ne 0 then L=(1-betainv(1-alpha/2, &N-i+1, i)); if p ne 1 then U=betainv (1-alpha/2, i+1, &N-i); N=&N; x=i; **diff=L-U; diff1=L-p; diff2=round((U-L)/2*100, .01); output; end; run; proc print data=CIop; var N x p L U diff2; run; ############### ... View more