topic Re: CSV file download by url in SAS Enterprise Guide

CSV file download by url

rfsalves — Tue, 09 Jan 2018 11:20:40 GMT

The base below has been downloaded without problems:

FILENAME SETOR_AG URL "http://w3.bdo.ibge.gov.br/index.php?r=administrativos/recursos/setores/CSVSetores"

but when I use that to download this other file in the same site, the download doesn't work well

FILENAME SETOR_AG URL "http://w3.bdo.ibge.gov.br/index.php?r=administrativos/recursos/agencias/CSVAgencias"

both files are in CSV

What can I do to solve this problem?

I use the SAS Enterprise Guide 5.1

Re: CSV file download by url

Kurt_Bremser — Tue, 09 Jan 2018 12:52:14 GMT

.... and the sack of rice dropped again in China.

"doesn't work well" tells us next to NOTHING. PLEASE BE MORE SPECIFIC. Include code and log, and examples of input data that does not end up in SAS as you expected.

Use the proper buttons ({i} and "little running man") to post log and code, respectively.

Re: CSV file download by url

Reeza — Tue, 09 Jan 2018 16:19:13 GMT

In my experience when downloading from a link it usually has the .csv at the end. What usually ends up happening, is if I paste the URL into a web browser I should also get a CSV file. Neither of your links produce a CSV file when pasted into the browser so they both seem incorrect.