Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

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

Reply
Contributor
Posts: 37

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

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

Respected Advisor
Posts: 4,920

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

Posted 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
Ask a Question
Discussion stats
  • 1 reply
  • 250 views
  • 0 likes
  • 2 in conversation