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

Hello , I have a dataset of patient and the dr. office dates. Some visits are mandatory while other are just when the patient has an issue. The visits are grouped into periods. Mandatory visits are 6 and visit 9 Have dataset User               stdate                            enddate                   visit6dt                          visit9dt                               A                2013-10-25                       2013-11-16                 2013-10-25                    2014-01-25 B                2013-02-01                      2013-04-21                 2013-03-10                    2013-06-10 C               2013-09-01                       2013-09                     2013-09-10                    2013-12-01 Want datset User               stdate                            enddate                   visit6dt                          visit9dt                               A                2013-10-25                       2013-10-25                 2013-10-25                    2014-01-25                             A                2013-10-26                       2014-01-25                 2013-10-25                    2014-01-25 B                2013-02-01                       2013-02-01                2013-03-10                    2013-06-10 B                2013-02-02                       2013-06-10                2013-03-10                    2013-06-10 C               2013-09-01                       2013-09-09                 2013-09-10                    2013-12-01 C               2013-09-10                      2013-09-10                   2013-09-10                    2013-12-01 C               2013-09-11                      2013-09 -30                  2013-09-10                    2013-12-01 C               2013-10-01                      2013-12-01                 2013-09-10                    2013-12-01 becasue the en day in one case is missing i had to split it into 4 rows; first until the 6 visit Then until the en of the month and then again until the end date. Thank you for your help ... View more