topic Re: HOW TO IMPORT DATA FROM A DATABASE INTO SAS in New SAS User

HOW TO IMPORT DATA FROM A DATABASE INTO SAS

Loudmila_2021 — Wed, 27 Jan 2021 09:53:01 GMT

Hello,

Actually, I need help to produce the SAS Program to import a database of a city from this site https://www.insee.fr/fr/statistiques/2011101?geo=EPCI-200068799#chiffre-key-9 and then produce another another SAS program to produce a table / database that will include the aggregated information at the intermunicipal level for the city and the neighboring cities.

Re: HOW TO IMPORT DATA FROM A DATABASE INTO SAS

SASKiwi — Wed, 27 Jan 2021 22:08:40 GMT

What have you tried so far? Please post any code you have developed.

Re: HOW TO IMPORT DATA FROM A DATABASE INTO SAS

andreas_lds — Thu, 28 Jan 2021 07:25:55 GMT

The answer depends on:

the database you want to read from
the access-methods defined by the maintainer of the database
the sas access-modules you can use

Assuming that you want to read from mysql/maria:

libname source mysql <options to connect to the database>;

After successful execution you can process the tables using the same tools you normally use when working with datasets.

BUT: You need AccessTo MySQL licenced and installed at your site to do so.

Re: HOW TO IMPORT DATA FROM A DATABASE INTO SAS

Kurt_Bremser — Thu, 28 Jan 2021 08:47:24 GMT

Please provide the further navigation to the downloadable data on this website.