hi,
I need to read in a text file with a layout as below into sas. The sas data should have columns as "Product_productid","Review_userId","Review_ProfileName", "Review_helpfulness","Review_Score", "Review Time", "Review Summary". Can someone let me know how I can handle such case? Thanks!
where
Thank you for replying to my post. However, I cannot open the link. There is not a limit set to the text so I might just set to the maximum sas allows.
Ok, well your SAS installation should have the documentation installed.
It's under SAS Products>Base SAS>Step-by-Step Programming with Base SAS 9.4 ... > Getting your data into Shape> Starting with Raw Data: Beyond the Basics> Reading Multiple Records to Create a Single Observation
Not sure why you can't access the SAS documentation.
Or you can search for that topic as well: "Reading Multiple Records to Create a Single Observation".
@flyingsohigh wrote:
Thank you for replying to my post. However, I cannot open the link. There is not a limit set to the text so I might just set to the maximum sas allows.
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!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: