cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAS Tip: Turn data on its side with TRANSPOSE (Daily tip for 2024-Apr-26)

Somethings work better turned on their side 180 degrees. Fear not, proc transpose is a super hero..Proc transpose data = --- out = ---;. By identifier;. Var product;.Run;..The identifier is a id and the product is what you want to transpose.

Thanks to Brian Mitchell for this tip. Read more details in this paper from WUSS 2017: Building a member centric world from a transactional data galaxy.

READ this complete tip   Visit a random SAS tip

Start a topic
About these Tips
A "SAS tip" is a basic unit of information exchange between SAS users. The tips on this board come from sasCommunity.org, from SAS user conferences, from SAS blogs, and from freelance contributions from SAS users like you. We hope that you're able to always learn something new here!


» How you can contribute

Tip-o-meter: 80 tips

How Can You Use Deep Learning for Personalized Pricing and Revenue Optimization?

Join this webinar to learn how you can use the power of machine learning and apply its capabilities to achieve personalized pricing. Register for this free Ask the Expert webinar to learn more.

Premiering May 2, 11 am ET

Register Now