So your original question was: Hi, Could you help me with this requirement?  Requirement: ------------ Dataset A: Var1     Var2     Var3     ---- Variables Pm     Am     Em     --------+ :     :     :          | :     :     :          | Po     Ao     Eo           | P1     A1     E1          | P2     A2     E2          | P3     A3     E3          |---- Observations :     :     :          | :     :     :          | Py     Ay     Ey          | Pz     Az     Ez          | :     :     :          | :     :     :          | Pn     An     En     --------+ Values from Am to Ao, Em to Eo, Az to An and Ez to En are Correct. Values A1-Ay E1-Ey are incorrect. I have a dataset B as below: Var1     Var2     Var3     ---- Variables Pm     Am     Em     --------+ :     :     :          | :     :     :          | Po     Ao     Eo           | P1     A1     E1          | P1     A1C     E1C          | P2     A2     E2          | P2     A2C     E2C          | P3     A3     E3          |---- Observations P3     A3C     E3C          | :     :     :          | :     :     :          | Py     Ay     Ey          | Py     AyC     EyC          | Pz     Az     Ez          | :     :     :          | :     :     :          | Pn     An     En     --------+ I want to overwrite dataset A using the dataset B as below (I’m expecting the dataset A to look like below after fix). Dataset A: Var1     Var2     Var3     ---- Variables Pm     Am     Em     --------+ :     :     :          | :     :     :          | Po     Ao     Eo           | P1     A1C     E1C          | P2     A2C     E2C          | P3     A3C     E3C          |---- Observations :     :     :          | :     :     :          | PyC     AyC     EyC          | Pz     Az     Ez          | :     :     :          | :     :     :          | Pn     An     En     --------+ It is not clear how you know which observations in A to update?  Normally there are key variables that you could use to know which rows to update. What code did you try? What result did you get? Did you get any errors? If the data for both A and B are already in your remote database then you would be better off asking your Data Base Administrator how to code the update in the native language of the database.  You can use the EXECUTE statement in PROC SQL to execute code in the remote database. ... View more

I make id variable to make them in the same group. if it starts with '----' then we enter into another group (id+1). ... View more

Hi, I found a way with proc transpose. You can check each single step. data test;   input variable1 $ variable2; datalines; AA S AA L AA W AB S AC S AC L AD L AD W AE S AF S AG L ; run; proc sort data=test;   by variable1 variable2; run; proc transpose data=test out=turn prefix=value;   by variable1;   var variable1 variable2; run; data turn;   set turn;    if value2= '' and value3= '' then delete; run; proc transpose data=turn out=turnback (drop=_name_);   by variable1;   var value1 value2 value3; run; data testend;   set turnback;    if variable1= '' or variable2= '' then delete; run; ... View more

You asked for it, sort 3 data set in one data step by different variables. Silly? I'll let you decide.  data a(keep=aa) b(keep=bb) c(keep=cc);    do _n_ = 10 to 1 by -1;            aa = _n_;       bb = _n_;       cc = _n_;       do j = 1 to 3;          output;          end;       end;    run; data _null_;    if 0 then set a;    declare hash a(dataset:'A',multidata: 'Y',ordered:'Y');    a.definekey('AA');    a.definedata(all:'Y');    a.defineDone();    a.output(dataset:'SA');    a.clear();    if 0 then set b;    declare hash b(dataset:'B',multidata: 'Y',ordered:'Y');    b.definekey('BB');    b.definedata(all:'Y');    b.defineDone();    b.output(dataset:'SB');    if 0 then set c;    declare hash c(dataset:'C',multidata: 'Y',ordered:'Y');    c.definekey('CC');    c.definedata(all:'Y');    c.defineDone();    c.output(dataset:'SC');    stop;    run; proc print data=SA;    run; proc print data=SB;    run; proc print data=SC;    run; ... View more