Merge/Transpose Help - Some column must be fixed

Ovaty · Posted 04-02-2019 04:34 PM

Hi everybody!

I need your help to solve my issue.

I need to do a merge/transpose column and leave some columns fixed.

Ex.:

I need this exit below for BMW:

Thanks a lot!!!

Gustavo.

Astounding · Posted 04-02-2019 04:42 PM

This should do it:

data want;
   set have;
   array parts {4} part1-part4;
   do k=1 to 4;
      part = parts{k};
      output;
   end;
   drop k part1-part4;
run;

Ovaty · Posted 04-03-2019 03:37 PM

Yes, its great!!

Thanks a lot!!

Re: Merge/Transpose Help - Some column must be fixed