Hi Mirisage. You are correct, the green highlighted place should be “Wiiii_okk_Total",that was a typo. For the IF/THEN-IF vs. IF/THEN - ELSE IF/THEN: ... if type = "a" and wii > 0 then do this;      if type = "b" and wii < 0 then do this; VS. if type = "a" and wii > 0 then do this;     else if type = "b" and wii < 0 then do this; I think that this (may) be the reason things work or not: The first scenario (no else-if) tells SAS that      if this condition is true, then do this. after that, independent of the previous statement being true or not, check this new condition (we use the second if statement). OK, for the second scenario: we tell SAS if this statement is true then do something or other.      ELSE IF do something....this forces SAS to only check this new IF statement if the prior IF (the one above) is not true. SO... if type = "a" and wii > 0 then do this; * may or may not be true;      if type = "b" and wii < 0 then do this;* may or may not be true...However, SAS executes both; VS. if type = "a" and wii > 0 then do this; * may or may not be true;     else if type = "b" and wii < 0 then do this;*this will only get executed when the line above is FALSE. The end. Good luck!   ... View more

Hi. Please try FRAME = VOID; Something like this: proc report data = your_data style(report)=[frame=void]; ... thanks! Anca. ... View more

Thank you. Once I posted it, I figured it out myself. ... View more

ok,I got it. Sorry for taking any of your time. proc sort data = in;by c_id ckd_dt; data want(drop = ckd_dt rename = (new_dt = ckd_dt))     set in;     by c_id ckd_dt;     if first.ckd_dt then new_dt = ckd_dt;         else new_dt= .; run; Thanks! ... View more

OK, I got it. Thank you. proc sort data = in;by c_id ckd_dt; data want;     set in;     by c_id ckd_dt;     if first.ckd_dt then new_dt = ckd_dt;         else new_dt= .; run; :smileyplain: ... View more

How about this?; %macro insert(); %do i = 1 %to 19;     data tmp_&i.;         set newt(obs = 1) ;         by freq;         drop _1 _2;             if first.freq then do;                 freq = &i.;             output;         end;     run; %end; %mend insert; %insert(); data final;     merge newt tmp_:;     by freq; run; Let me know if this is what you wanted; ... View more

Hi, Could you add in your output data set what exactly are you looking for? Would you like the '?' to be filled?? Obs    freq    _1    _2                                        1       1      2     2                                        2       3      4    ?                                        3       4      2     3                                        4       6      3    ?                                        5       8      ?     4                                        6      20      1    ?                                        7      21     ?     2 ... View more

One simple way would be: as Fareeza suggested data zero(rename =  (Temp_Wiiii_okk_Total = Wiiii_okk_Total ));      set a.have;      if TTT_TYPE  = "Khgrgi-lff Peveksel: 3" and Wiiii_okk_Total > 0 then Temp_Wiiii_okk_Total =Wiiii_okk_Total * -1;           else Temp_Wiiii_okk_Total=  Wiiii_okk_Total;      if TTT_TYPE  = "Aaaaa Bnumb nn Bhrrrr-Hff: 66" and Wiiii_okk_Total < 0 then Temp_Wiiii_okk_Total =Wiiii_okk_Total * -1;           else Temp_Wiiii_okk_Total = Temp_Wiiii_okk_Total;      drop Wiiii_okk_Total; run;   ... View more