Thanks a lot guys! Both helpful! Wish I could mark both as correct. ... View more

If you have some sort of group id to be considered, then the following code may help a little: DATA have; input (Var1    Var2    Var3    Var4a    Var4b    Var5    Var6) ($); group=floor(_n_/4); cards; 1    a    y    1515    2323    orange    $500 2    b    n    2626    3434    blue    $600 3    c    y    3737    4545    green    $700 4    d    n    4848    5656    red        $800 1    a    y    1515    2323    orange    $500 2    b    n    2626    3434    blue    $600 3    c    y    3737    4545    green    $700 4    d    n    4848    5656    red        $800 ; data want; array vb (0:999) $  _temporary_; set have; by group; if first.group then call missing(i); i+1; vb(i)=var4b; output; if last.group then do _n_=1 to i; call missing (of _all_);    var4a=vb(_n_);    output; end; drop var4b i; run;   proc print;RUN; Regards, Haikuo Update: On my second thought, Keith's solution is superior even there is a group id: data want; set have (drop=var4b rename=(var4a=var4))   have (keep=group var4b rename=(var4b=var4));   by group; run; ... View more

Or you can just: proc stdize data=have reponly method=sum missing=0 out=want;    var msd1101 - msd1112;    run; Haikuo ... View more

Fantastic. That did it. Thank you! ... View more

Did you add Schema into libname statement ? First of all ,running the following single statement. libname x db2 dsn=db2 user=xx password=xx schema=K ; And Check X whether you can see some DB2 tables in X library. If I guess right, You will see nothing, because you must need to add schema ( it must be uppercase) . After You ensure you can see these tables, then running the following SAS code . As I expect ,you will get the result. Good Luck. Ksharp ... View more