Where can I find SQL.COUNTRIES?

[JulieLearnsSAS]

Hello all, 

hopefully this is a simple question.  I am looking for the data that is used in the SQL examples on the site.

The examples can be found here:  sql.countries. 

Tyvm in advance.

- Jules.

[FreelanceReinh · Accepted solution]

Hello @JulieLearnsSAS,

Finally I found the link in the SAS 9.3 (!) section of the page https://support.sas.com/en/software/base-sas-support.html#documentation. Here's a direct link: http://support.sas.com/documentation/onlinedoc/base/9.3/SQLDatasetsV9.zip 

My Chrome browser tried to block the download of the zip file -- not knowing how trustworthy SAS Institute Inc. is.

After downloading and extracting the zip file you have a file named SQLDatasetsV9 (without a suffix), say, in folder your_path\. Then you submit a LIBNAME statement as usual, e.g.

libname sql 'your_library_path';

and extract the datasets from the CPORT transport file (which SQLDatasetsV9 is):

proc cimport library=sql infile='your_path\sqldatasetsv9';
run;

Now you have countries.sas7bdat and nine other SAS datasets in your_library_path available as sql.countries, etc.

[PaigeMiller]

Wow, that is very well hidden considering that SQL.COUNTRIES still is mentioned in a number of places in the SAS documentation. 

This is not good, SAS.

[JulieLearnsSAS]

Tyvm. I usually write out the copy the code (not copy and paste, but actually type it all out myself) , so I like to see if it compiles the same , etc..

Appreciate the help.