Thank you Art and DN!  Linlin ... View more

Thank you Tom! this is what I got after making changes as you suggested: data check; input v1-v5 ; cards; 1 2 3 4 5 ; run; data look;   set check;   put (_numeric_) (=);   nm2=nmiss(of _numeric_);   put (_numeric_) (=);   nm1=nmiss(of v1-v5);   put (_numeric_) (=); run; proc print;run; Obs    v1    v2    v3    v4    v5    nm2    nm1 1      1     2     3     4     5     1      0 From log file: 301  data check; 302  input v1-v5 ; 303  cards; NOTE: The data set WORK.CHECK has 1 observations and 5 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds 305  ; 306  run; 307 308  data look; 309    set check; 310    put (_numeric_) (=); 311    nm2=nmiss(of _numeric_); 312    put (_numeric_) (=); 313    nm1=nmiss(of v1-v5); 314    put (_numeric_) (=); 315  run; v1=1 v2=2 v3=3 v4=4 v5=5 v1=1 v2=2 v3=3 v4=4 v5=5 nm2=1 v1=1 v2=2 v3=3 v4=4 v5=5 nm2=1 nm1=0 NOTE: There were 1 observations read from the data set WORK.CHECK. NOTE: The data set WORK.LOOK has 1 observations and 7 variables. NOTE: DATA statement used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds 316  proc print;run; NOTE: There were 1 observations read from the data set WORK.LOOK. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds ... View more

The OP post the question twice. http://communities.sas.com/message/117621#117621 ... View more

data have;   input ID $ x;   n=_n_;   cards; a          1 a          1 a          0 a          1 a          1 b          0 b          1 b          1 b          0 b          0 ; proc sort data=have;   by id descending n; run; data want(drop=n);   set have;   by id;   y+(-first.id*y)+x; run; proc sort data=want;   by id descending y x; run; proc print ;run;                              Obs    ID    x    y                                   1    a     1    4                                   2    a     1    3                                   3    a     0    2                                   4    a     1    2                                   5    a     1    1                                   6    b     0    2                                   7    b     1    2                                   8    b     1    1                                   9    b     0    0                                  10    b     0    0 Linin ... View more

another approach: data have; input ID Year Value1 Value2 Value3; datalines; 1  1999      .      270 . 1  1999      . .                 350  1  1999   . . . 1  2000    20 . . 1  2000    .         300 . 1  2000    .          .           320 1  2001     .        122 . 1  2001     .         . .     1  2001     .         .           500 ; proc sql;   create table want as     select distinct id,year,sum(value1) as value1,sum(value2) as value2,sum(value3) as value3             from have               group by id,year; quit; proc print; run;                  Obs    ID    Year    value1    value2    value3                    1      1    1999       .             270       350                    2      1    2000      20          300       320                    3      1    2001       .            122       500 Linlin ... View more

data have (keep=country transactions);   input country1 $ country2 $ transactions;   array cty(*) coun:;   call sortc(of cty(*));   country=upcase(catx('-',of cty(*)));   cards; Korea     USA       100 USA       Korea     100 China     Canada    200 Canada    China     300 ; proc sql;   create table want as     select country,sum(transactions) as total              from have                group by country; quit; proc print;run;                                    Obs      country       total                                      1     CANADA-CHINA     500                                      2     KOREA-USA           200 ... View more

data have; input ReAdm1-ReAdm4; cards; 12 15 7 16 23 5 67 12 ; data want;   set have;   ReAdm=cats(of ReAdm1-ReAdm4); run; proc print;run;                              Re      Re      Re      Re                  Obs    Adm1    Adm2    Adm3    Adm4     ReAdm                      1      12      15       7      16     1215716                    2      23       5      67      12     2356712 Linlin ... View more

%let dset=sashelp.class; %let varnames=age height weight; %let nvars=3; %macro doit;   data notarget_temp1;     set &dset.;       rename %do i = 1 %to &nvars.;                   %scan(&varnames.,&i.) = key_&i.                   %end;;   run; %mend; %doit ... View more

%MACRO STACK(STACKED,FILE1,FILE2) ;   DATA &STACKED ; length FILE_PERIOD $ 9; SET a.&FILE1 a.&FILE2 ; FILE_PERIOD =scan("&FILE1",2,'_') ; RUN; %MEND ; %STACK(STACKED_2011DEC31,FILE1_2011DEC31,FILE2_2011DEC31) ; ... View more

Thank you Tom! ... View more