topic Re: How to convert sas dataset which is in columnar format into flat file? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/Re-How-to-convert-sas-dataset-which-is-in-columnar-format-into/m-p/186780#M2285 <HTML><HEAD></HEAD><BODY><P>This kind of transformation is usually done with SAS <STRONG>Transpose</STRONG> 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).</P><P></P><P>PG</P></BODY></HTML> Sun, 20 Jul 2014 19:36:39 GMT PGStats 2014-07-20T19:36:39Z Re: How to convert sas dataset which is in columnar format into flat file? https://communities.sas.com/t5/SAS-Data-Science/Re-How-to-convert-sas-dataset-which-is-in-columnar-format-into/m-p/186779#M2284 <HTML><HEAD></HEAD><BODY><P>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.<IMG alt="Capture1.PNG" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/6892_Capture1.PNG" width="450" /> </P></BODY></HTML> Sat, 26 Jul 2014 12:13:49 GMT https://communities.sas.com/t5/SAS-Data-Science/Re-How-to-convert-sas-dataset-which-is-in-columnar-format-into/m-p/186779#M2284 HarshadMadhamshettiwar 2014-07-26T12:13:49Z Re: How to convert sas dataset which is in columnar format into flat file? https://communities.sas.com/t5/SAS-Data-Science/Re-How-to-convert-sas-dataset-which-is-in-columnar-format-into/m-p/186780#M2285 <HTML><HEAD></HEAD><BODY><P>This kind of transformation is usually done with SAS <STRONG>Transpose</STRONG> 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).</P><P></P><P>PG</P></BODY></HTML> Sun, 20 Jul 2014 19:36:39 GMT https://communities.sas.com/t5/SAS-Data-Science/Re-How-to-convert-sas-dataset-which-is-in-columnar-format-into/m-p/186780#M2285 PGStats 2014-07-20T19:36:39Z