topic Re: Where can I find SQL.COUNTRIES? in SAS Procedures

Where can I find SQL.COUNTRIES?

JulieLearnsSAS — Sun, 20 Dec 2020 13:49:03 GMT

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.

Re: Where can I find SQL.COUNTRIES?

FreelanceReinh — Mon, 21 Dec 2020 11:32:24 GMT

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.

Re: Where can I find SQL.COUNTRIES?

PaigeMiller — Mon, 21 Dec 2020 11:46:14 GMT

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.

Re: Where can I find SQL.COUNTRIES?

JulieLearnsSAS — Tue, 22 Dec 2020 00:17:42 GMT

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.