topic Re: how to read in a text fie with special formats in SAS Programming

how to read in a text fie with special formats

flyingsohigh — Tue, 18 Sep 2018 15:57:20 GMT

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!

Data format

product/productId: B001E4KFG0

review/userId: A3SGXH7AUHU8GW

review/profileName: delmartian

review/helpfulness: 1/1

review/score: 5.0

review/time: 1303862400

review/summary: Good Quality Dog Food review/text: I have bought several of the Vitality canned dog food products and have found them all to be of good quality. The product looks more like a stew than a processed meat and it smells better. My Labrador is finicky and she appreciates this product better than most.

where

product/productId: asin, e.g. amazon.com/dp/B001E4KFG0
review/userId: id of the user, e.g. A3SGXH7AUHU8GW
review/profileName: name of the user
review/helpfulness: fraction of users who found the review helpful
review/score: rating of the product
review/time: time of the review (unix time)
review/summary: review summary
review/text: text of the review

Re: how to read in a text fie with special formats

Reeza — Tue, 18 Sep 2018 16:08:37 GMT

Is this the exact structure? You'll have multiple lines after that all follow the structure? Is the last line, the text line, does it have a maximum length limit?

The reason I'm asking is because it's easy to write code that will read the lines above, but it may not generalize to your actual data so it's better to get the details ahead of time.

Here's a couple of different methods outlined here:
https://documentation.sas.com/?docsetId=basess&docsetTarget=p0s16wvzu0z9q7n0zmxia30s6qyc.htm&docsetVersion=9.4&locale=en

Re: how to read in a text fie with special formats

flyingsohigh — Tue, 18 Sep 2018 17:50:21 GMT

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.

Re: how to read in a text fie with special formats

Reeza — Tue, 18 Sep 2018 19:11:55 GMT

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.