BookmarkSubscribeRSS Feed
Loudmila_2021
Calcite | Level 5

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. 

 

 

 

3 REPLIES 3
SASKiwi
PROC Star

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

andreas_lds
Jade | Level 19

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.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 705 views
  • 0 likes
  • 4 in conversation