Dear,   I just posted for asking help. I modified your code to get output I need. Could please check and suggest if this is ok. Thank you very much.   modified code: data two(drop=n vsum group ldate); set one; by id visit test date; output; vsum+val; n+1; ldate=lag(date); if first.id then group=1; else if first.date and ldate ne date then group+1; if first.date then do; n=1; vsum=val; end; /* if group = 1 then output;*/ if last.date and group= 1 then do; test=cats(test,'7'); val=vsum/n; output; end; run;   ... View more

Dear,   Thank you very much. That works for me. But the output data has only OBS with AVG calculated. I need to have all the OBS in the output. Please help. Thank you very much.   Output getting with the code:   1 1 dbp 88 2010-04-28 1 1 dbp 90 2010-04-28 1 1 dbp 92 2010-04-28 1 1 dbp7 90 2010-04-28 2 1 dbp 100 2010-05-27  2 1 dbp 98 2010-05-27 2 1 dbp 96 2010-05-27 2 1 dbp7 98 2010-05-27   output needed: 1 1 dbp 88 2010-04-28 1 1 dbp 90 2010-04-28 1 1 dbp 92 2010-04-28 1 1 dbp7 90 2010-04-28 2 1 dbp 100 2010-05-27  2 1 dbp 98 2010-05-27 2 1 dbp 96 2010-05-27 2 1 dbp7 98 2010-05-27 2 1 dbp 100 2010-05-28 2 1 dbp 98 2010-05-28 2 1 dbp 96 2010-05-28 2 1 dbp 94 2010-05-29 2 1 dbp 92 2010-05-29 2 1 dbp 90 2010-05-29 ... View more

Dear,   I am running following program. i am not getting the out I need. please suggest. Thank you   data one; input cmendtc_raw $11.; datalines; UN/Feb/2015 ; data two; set one; cmendtc=put(input(cmendtc_raw, ?? date11.),yymmdd10.); if missing(cmendtc) and not missing(cmendtc_raw) then do; length _day1 _month1 _year1 8; _day1 =input(scan(cmendtc_raw,1,'/','m'), ?? best32.); _month1=month(input(scan(cmendtc_raw,2,'/','m')||'2000', ?? monyy.)); _year1 =input(scan(cmendtc_raw,3,'/','m'),?? best32.); end; if _day1<1 or _day1>31 then call missing(_day1); if _month1<1 or _month1>12 then call missing(_month1); /* valid day and year? */ if mdy(01,_day1,_year1) then cmendtc=put(_year1,z4.)||'--'||put(_day1,z2.); /* valid month and year? */ else if mdy(_month1,01,_year1) then cmendtc=put(_year1,z4.)||'-'||put(_month1,z2.); /* valid year? */ else if mdy(02,01,_year1) then cmendtc=put(_year1,z4.); run;   output need: 2015-02   I am seeing a blank value     "         .'   . The missing function is not recognizing. Please help. Thank you ... View more

Thank you for the support. But it did not work. The lengths of term1 still shows 193 and194.   In my program, one time I used "options varlenchk=nowarn;". Does this effect compbl function. Thank you  ... View more

Sorry. That statement should be In my ouput dataset I need all subject with sf='N'. ... View more

I think i donot need to calculate macro. After calculating total(ns), i used Proc Transpose procedure to get my output. Thanks you all for the support. ... View more

Thank you very much for your time.   I am trying to get a data set for a table that I need to create.   The following data set I need to created using proc means. But the n values created by proc means are not the values I need for for table. The n values are (ns) distinct id values which I calculated using proc sql (data one).   I  ran proc means for the stat values and proc sql for number of distinct subjects.   data one; (created by sql) input ns trt$ visit$; datalines; 18 15 wk4 38 30 wk4 10 37 wk4 17 72 wk4 19 place wk4 18 15 wk1 38 30 wk1 10 37 wk1 17 72 wk1 19 place wk1 ;    dataset output needed:(Created by proc means). The n values  are not useful for my table.   visit   trt           n   mean median min    max   SD wk1    15         2     5         5        3      7      2.82     wk1    30         2     6.5     6.5       6      7      0.7 wk1    37         2     5         5        3      7      2.82     wk1    72         2     6.5     6.5       6      7      0.7 wk1   placebo   2      8       8          7      9     1.4 wk4    15          2     5         5        3      7       2.82 wk4    30          2     6.5     6.5       6      7      0.7 wk4     37          2      8       8          7      9     1.4 wk4    72            2     6.5     6.5       6      7      0.7 wk4     placebo    2      8       8          7      9     1.4       Table output needed; wk1(pul)                                            15                                    30                                    37                  72             placebo     Total n(ns )                                  18                                     38                                   10                  17                19            83 mean(SD)                              5(2.82)                            6.5(0.7)                           8(1.4)             6.5(0.7)           8(1.4) median                                  5                                     6.5                                 8                   6.5                 8 range(min,max)                      3, 7                                 6, 7                                7, 9                6.5                  8     wk1(pul)                                            15                                    30                                    37                  72             placebo     Total n   (ns)                                   18                                     38                                   10                  17                19            83 mean(SD)                              5(2.82)                            6.5(0.7)                           8(1.4)          6.5(0.7)            8(1.4) median                                  5                                     6.5                                 8                 6.5                  8 range(min,max)                      3, 7                                 6, 7                                7, 9          6.5                      8 ... View more