topic Re: Statistics Canada Download in SAS Programming

Statistics Canada Download

BCNAV — Mon, 20 Apr 2020 19:06:31 GMT

Has anyone written a macro/guide to automatically download specified vectors from Statistics Canada?

Suppose I want, as an example, v125190 v125221, is there a way to automate this? Note these are vectors with data and not tables.

Thx

Tom — Mon, 20 Apr 2020 19:49:36 GMT

How do you access it now? Does it have a URL? Some other method?

BCNAV — Mon, 20 Apr 2020 20:16:41 GMT

I would go to this page and get a CSV

2. Where it says enter vector numbers enter them in separated by commas, then choose 3,000 as the number of reference periods, then download manually

3. Load into SAS.

This is not an automated approach....so I thought I would ask

Tom — Mon, 20 Apr 2020 20:28:32 GMT

So clicking around it looks like you can download a ZIP file with the data for one of those directly.

Not sure whether it is always going to use that 24100041 number for this "vector".

The ZIP file has two files. From the names it looks like one is the data and the other is the description of the data.

Reeza — Mon, 20 Apr 2020 21:11:03 GMT

I wrote a macro to get all data at one point, not specific vectors.

It's in the Canadian subforum.