BookmarkSubscribeRSS Feed
ptimusk
Obsidian | Level 7

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
Calcite | Level 5

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,

PatriceB
Calcite | Level 5

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
Obsidian | Level 7

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
Calcite | Level 5
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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 20 replies
  • 6044 views
  • 10 likes
  • 9 in conversation