Nevermind, it's because my variables were stored as text! Thanks a lot for the help! ... View more

Hello. I created the table in Excel to describe if a person has a qualification or not, and I later need to modify it by joining it to another table / transposing it. It's taking way too long with all the unnecessary variables : ) ... View more

Thanks for the response! This looks very easy to follow and recreate. Though I tried running this, and it just gave me my table back with the 0's still there, the table I am trying to filter is "my_table". What went wrong??   proc summary data=my_table; var _numeric_; output out=check (drop=_type_ _freq_) sum=; run; proc transpose data=check out=check2; var _all_; run; data _null_; set check2 end=eof; if _n_ = 1 then call execute('data want; set unix.my_table; drop'); if col1 = 0 then call execute(' ' !! trim(_name_)); if eof then call execute('; run;'); run; ... View more

Thanks so much - I was trying to merge it back in, but this works so much better! ... View more

Thanks for the reply!! Two questions - Why isn't it  - - if first.area then cumvalue = 0; (edit - just realized I have it like that in my op : O)   Also, I believe that code removes duplicates and condenses each area into one. I would like each area to remain and have the final cumulative value. ... View more