BookmarkSubscribeRSS Feed
MitchellStarc
Calcite | Level 5

Each customer appear in 12 rows . Each customer has a unique key number that stay forever and never changed. However, the customer ID and the branch can be changed over time. I want to create 2 wanted data sets (one in long structure and second in wide structure). The target is to see the changes of customer id number for each customer key

1 REPLY 1

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 547 views
  • 0 likes
  • 2 in conversation