topic Re: Merge/Transpose Help - Some column must be fixed in New SAS User

Merge/Transpose Help - Some column must be fixed

Ovaty — Tue, 02 Apr 2019 20:34:16 GMT

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 — Tue, 02 Apr 2019 20:42:36 GMT

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 — Wed, 03 Apr 2019 19:37:07 GMT

Yes, its great!!

Thanks a lot!!