Hi @mkeintz,
Thanks for your reply.
This looks like a two step program: (1) get id's, content identifiers (future variable names), and data values in a long format, (2) transpose to a wide format. What have you tried so far to read in the data - prior to transpose?
I merged the two threads into one.
If you want more detailed help with parsing your file please share an actual sample of the file structure.
First use a text editor, like NOTEPAD, to replace any confidential information with similar strings. Try not to modify the pattern (ie don't replace strings that are all digits with only letters or the reverse).
Hi @Tom ,
I have attached a .txt file that is somewhat similar to my file and the excel file has my desired output.
Thank you for your help.
Can you please help me delete this post as I had framed the question wrongly.
Thanks
I will reach out to you via email @UV_123.
@ChrisHemedinger is currently traveling.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.