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: 
BookmarkSubscribeRSS Feed
HarshadMadhamshettiwar
Obsidian | Level 7 HarshadMadhamshettiwar
Obsidian | Level 7

Re: How to convert sas dataset which is in columnar format into flat file?

Posted 07-26-2014 08:13 AM (1879 views)

Hey, sorry for late, I am attaching a screen shot of how I want the final dataset to look like. Data is not original but representation of it. Please notice that number of product (pm) are thousands.Capture1.PNG

0 Likes
Reply
1 REPLY 1
PGStats
Opal | Level 21 PGStats
Opal | Level 21

Re: How to convert sas dataset which is in columnar format into flat file?

Posted 07-20-2014 03:36 PM (1797 views)  |   In reply to HarshadMadhamshettiwar

This kind of transformation is usually done with SAS Transpose procedure. We can propose some working code to get from a precise dataset structure to another, given enough detail (i.e., variable names and types).

PG

PG
0 Likes
Reply

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Watch How to choose a machine learning algorithm on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎07-26-2014 08:13 AM
  • 1880 views
  • 0 likes
  • 2 in conversation