Hello,   I have a  5 variables in a dataset (A1 to A5). Each of then can have a value of Y or N. I need to create a 6th variable which give "summary" of the 5 others. When more than one variable is set to Y then A6=" More than 1". If only one of then is Y then in A6 I need to add which variable is set to Y: ex         A1        A2        A3      A4     A5       A6 1      Y          N          N        Y       N       More than one 2      N          N          N        Y       N        A4 3      Y          N          N        N       N        A1 4     N          N          Y        N       N        A3     If is possible to do it in a array or do I need to use if- else with multiple combination?   ... View more

Hello,   I am doing a summary by category of response and by visit for a group of people.   proc means data=all noprint; by visit cat ; var aval; output out=final_cat n=n mean=mean min=min ; run;   proc means data=all noprint; by visit cat under; var aval; output out=final_under n=ns ; run;    I then do a proc transpose and set the 2 datasets together; proc transpose data=final_cat out=Tr_cat; by visit; var n mean min; id cat; run; Proc sort data= final_under ; by visit under ; run; proc transpose data=final_under out=Tr_under; by visit under; var ns; id cat; run;   data final; tr_cat tr_under; by visit; set run;       I get :                                          category 1   category 2    category3 Day1       N                         18                19                 6                Mean                   0.5              0.6                1.34                Min                     0.1               0.5                0.2               under 12               17 (%)          17  (%)            5(%)                over 12                   1(%)             2(%)              1(%)    Day4       N                          8                     3                  32                Mean                    0.4                  0.35             0.73                Min                       0.1                  0.2              0.1               under 12                7 (%)                  3  (%)       23(%)                over 12                  1 (%)                   0  (%)        9(%)    Day8       N                          3                           1                  39                Mean                Min               under 12                      3(%)                 1(%)                29(%)                over 12                         0 (%)               0(%)                 10(%)       I need to calculate the percentage in red based on the count of people at each visit.Ex for Day 1, in category 1, under 12 it should be (7/8)*100. How can I do it?   Thanks KC ... View more

Hello, I have a dataset where I have multiple dates per subject on different rows. I would like to have all the dates into one row. Each row has a number of other parameters. have data look like this subject      startdt             enddt                           topic               comments              location 1               1jan2015         31mar2015                 english             good                      buildA 1               1apr2015         30jun2015                 science             average                  LabB 2               1jan2015         28feb2015                  math                  bad                         mathlab 3               1jan2015         28feb2015                  math                good                        mathlab  3               1mar2015        31mar2015              history                good                        buildA 3               1apr2015         30jun2015                 science             average                  LabB 4              1mar2015        31mar2015              history                good                        buildA 5               1mar2015        31mar2015              english                good                        buildA 5               1apr2015         30jun2015                 science             average                  LabB     I would like the data to look like subject startdt1  enddt1  topic1    comments1   location1   startdt2    enddt2   topic2   comments2   location1 startdt3   enddt3      topic3  comments3   location3 1    1jan2015   31mar2015    english     good   buildA      1apr2015  30jun2015    science     average     LabB           2    1jan2015   28feb2015     math        bad    mathlab 3    1jan2015  28feb2015       math       good   mathlab  1mar2015   31mar2015   history    good   buildA 1apr2015  30jun2015   science             average                  LabB 4    1mar2015   31mar2015   history  good    buildA 5    1mar2015  31mar2015   english   good    buildA     1apr2015   30jun2015     science   average    LabB   Thanks fo your help.   KC ... View more

Hello  I have two datasets, with 4 rows and 3 columns. and I need to divide the values of one by the other. dataset 1                   Col1           Col2         Col3 Type1       T1C1          T1C2         T1C3 Type2       T2C1          T2C2         T2C3 Type3       T3C1          T3C2         T3C3 Type4       T4C1          T4C2         T4C3   dataset 2                   Col1           Col2         Col3 Samp1       S1C1          S1C2        S1C3 Samp2       S2C1          S2C2        S2C3 Samp3       S3C1          S3C2        S3C3 Samp4       S4C1          S4C2        S4C3     How can I divide the values in dataset 1 by the values in dataset2: desired result: dataset 3:                   Col1                        Col2                    Col3 Resl1       T1C1/S1C1          T1C2/S1C2        T1C3/S1C3 Resl2       T2C1/S2C1          T2C2/S2C2        T2C3/S2C3 Resl3       T3C1/S3C1          T2C2/S3C2        T2C3/S3C3 Resl4       T4C1/S4C1          T4C2/S4C2        T4C3/S4C3   I ws thinking of using a loop: data result;         set dataset1 dataset2; array type{4,3} t1c1-t1c3 t2c1-t2c3 t3c1-t3c3 t4c1-t4c3; array sample{4,3} s1c1-s1c3 s2c1-s2c3 s3c1-s3c3 s4c1-s4c3;         %do i = 1 %to dim1(type);             %do j = 1 %to dim2(type);              result{i,j}=type{i,j}/sample{i,j};             %end;         %end;   thanks ... View more