BookmarkSubscribeRSS Feed
niam
Quartz | Level 8

Hi, I want to analyze the Yelp Academic Dataset in SAS. Yelp provides the data in different formats, one of which is .sql

Data is available here:

https://www.yelp.com/dataset/download

How can I read the filed into SAS?

 

3 REPLIES 3
Reeza
Super User

A .SQL file is a text file but there is no method that I know of to have that read into SAS automatically. Open a part of the text file in a text editor and you'll see why. It has the create table statements and insert table statements embedded. You can convert it to SAS SQL with minimal effort, but the size of the files are problematic. If you have SAS 9.4 TS1M5 perhaps JSON with the JSON libname is a better option?


@niam wrote:

Hi, I want to analyze the Yelp Academic Dataset in SAS. Yelp provides the data in different formats, one of which is .sql

Data is available here:

https://www.yelp.com/dataset/download

How can I read the filed into SAS?

 


 

niam
Quartz | Level 8

Thank you very much for the help. I opened the files and as you said, they are not the typical SAS readable files.

I can use the JSON files, but still, I do not know how to use SAS to read them. Do you have any tips for that?

Reeza
Super User

@niam wrote:

Thank you very much for the help. I opened the files and as you said, they are not the typical SAS readable files.

I can use the JSON files, but still, I do not know how to use SAS to read them. Do you have any tips for that?


I googled "SAS JSON LIBNAME" and found this:

https://blogs.sas.com/content/sasdummy/2016/12/02/json-libname-engine-sas/

 

I do not have SAS 9.4 TS1M5 so I've never used it.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 876 views
  • 0 likes
  • 2 in conversation