How to import this SDMX-ML data from Statistics Canada in SAS?

[ptimusk]

I have SAS IML Studio  14.1 and R installed, so can run this R code and it works for me.

submit / R;
install.packages("rsdmx")
library(rsdmx)
generic <- readSDMX(file = "C:/Users/ptimusk/Documents/98-311-XCB2011011/Generic_98-311-XCB2011011.xml", isURL = FALSE)
Generic_98_311_XCB2011011 <- as.data.frame(generic)
endsubmit;

libname out2 'C:\Users\ptimusk\Documents\SDMX_ML\SDMX_2-1-1_SECTION_3B_SDMX_ML_Schemas_Samples_201108\schemas\';
run ImportDataSetFromR( "out2.Generic98311XCB2011011_2", "Generic_98_311_XCB2011011" );

[Isarmiento]

Hi, I have seen you were able to create a CSV using Beyond 20/20. I need to work with a table from StatCan but it looks like it is impossible.

Can you please explain how did you do it?

Thank you,

[ptimusk]

The software beyond 20/20 is here http://www.statcan.gc.ca/eng/public/beyond20-20

[PatriceB]

Hello to you all.

Was anyone successfull in loading StatCan XML-SDMX format files?

For the moment, can't install Beyond 20/20 on my workstation because of local IT limitations.

Need to load the census data for 2016 per dissimination area.

Pat 🙂

[ptimusk]

The R solution above works but you need to install R and have SAS IML installed. Or you need to use XML mapper but write your own XML map.

[Isarmiento]

Hi, Patrice

In my experience, the easiest thing to do is work with Beyond 20/20 to get
the .csv containing the data. To do that, I had to use another computer
because it did not work on my Mac.

You can also try to contact Statistics Canada directly and ask for the
information. As long as it is something they already have, they are very
quick to answer.

I solved my problem with the data they sent, and then I figured out how to
export from Beyond 20/20. So, I can tell you that both paths can work.

Good luck!

Ivan