Hi everyone, I need to classify every record of the activity of test2,        in groups...1, 2 , 3. Which group?  The group number is given in test1.         I give you some a couple of examles to explain the problem:        ...the first record in test2 of subjid=1 (activity=15)        has to be assigned to the group=1, because 15 for subjid=1 is        between 10 and 20 beloging to group 1 and so on.        the first record in test2 of subjid=2 (activity=03)        has to be missing (group=.) because there is not group below 5 assigned in test1        to subjid=2        In my problem I have 40 subjid, I only show 2 to simplify the problem,        andI need you to help me with a general code (using matrix I suppose). Thanks a lot. V        data test1;        input subjid awake sleep group;        datalines;        1 10 20 1        1 30 40 2        1 50  . 1        2 05 10 1        2 15 25 2        2 28 42 3        2 53 60 2        ;        run;        data test2;        input subjid activity;        datalines;        1 15        1 25        1 35        1 39        1 51        2 03        2 07        2 16        2 43        2 55        2 63        ;        run; ... View more

Hi everyone, how can I create the variable b from a. a                b                ----            ------ 1                1 1                1 2                2 2                2 3                3 4                4 4                4 1                5 1                5 2                6 3                7 4                8 4                8 Thnaks, V ... View more

  Hi everyone, I got the next code that generate adv1 (a summary table):   data new;   length subjid leg_sort aeterm $20. trtrel 8.;   input subjid leg_sort aeterm trtrel;   datalines;   100 drug drymouth  1   101 drug drymouth  1   102 placebo  drymount 0   ;   run; proc sql noprint;   create table adv1 as   select count(distinct subjid) as n, leg_sort, 'Subjects evaluable for AE' as text   from new   where trtrel=1   group by leg_sort; quit; my problem is that I would like to include the row placebo  with N= . i.e, I  want to generate a dataset including all the possible values of leg_sort considering the values with missing data (placebo in my example). Thnaks in advance. V ... View more

Hi everyone, I am interesting to put the final numeric variable time I got, for example 176:30...in a character variable: 176:30 with format $7 Any help? Thnaks. V. data have; input hours 8.; datalines; 0 176.5 1.25 2.5 3 ;;; run; data want; set have; format time HHMM7.; time = hours*3600; run; proc print; run; ... View more

Hi everyone, I've got a proble with the conversion in hours and minutes for the data 176.5...it is not converted properly, any help? Thnaks in advance. V. data have; input hours 8.; datalines; 0 176.5 1.25 2.5 3 ;;; run; data want; set have; format time HHMM5.; time = hours*3600; run; proc print; run; ... View more