topic Re: Reading Cport, Copy/Export, and Stata data files in Discussions

Reading Cport, Copy/Export, and Stata data files

LNitz — Tue, 10 Dec 2024 21:15:50 GMT

I have downloaded the Federal Reserve's files for the Survey of Consumer Finances. Here are the formats available:

I am using the academic edition of JMP Pro 18. I cannot find a way to read either the two SAS transport formats or the Stata format. I may be missing something obvious, like the correct description in the JMP open script options, or another command that I cannot remember. In essence, I cannot open any of the three files.

Re: Reading Cport, Copy/Export, and Stata data files

txnelson — Wed, 11 Dec 2024 05:01:56 GMT

SAS on Demand for Academics is a version of SAS that is free for students. i downloaded the CPORT file and moved it into the SAS Studio environment. I then used Proc Cimport to import the file into a SAS data table. From there I downloaded the SAS file to my download folder and then used JMP to open the SAS file.

There is also an ascii file that can be downloaded, and after adding a .txt as a file extension to the file, it can be directly read into JMP