Solved: Closed

hellorc · Posted 03-28-2023 09:27 AM

Closed

Quentin · Posted 03-28-2023 09:31 AM

There is a TRANSPOSE procedure:

proc transpose data=have out=want (rename=(_Name_=Letter Col1=Value)); 
  by id group subgroup;
run ;

You can also transpose data with arrays.

BASUG is hosting free webinars Next up: Don Henderson presenting on using hash functions (not hash tables!) to segment data on June 12. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

View solution in original post

Quentin · Posted 03-28-2023 09:31 AM

There is a TRANSPOSE procedure:

proc transpose data=have out=want (rename=(_Name_=Letter Col1=Value)); 
  by id group subgroup;
run ;

You can also transpose data with arrays.

BASUG is hosting free webinars Next up: Don Henderson presenting on using hash functions (not hash tables!) to segment data on June 12. Register now at the Boston Area SAS Users Group event page: https://www.basug.org/events.

Closed

Re: Converting data into long format with a new indicating variable

Re: Converting data into long format with a new indicating variable