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,655

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

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
  • 248 views
  • 0 likes
  • 2 in conversation