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" );
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,
The software beyond 20/20 is here http://www.statcan.gc.ca/eng/public/beyond20-20
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 🙂
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.