Subscribe Bookmark RSS Feed

Using SAS script to import a .dat file into JMP 10.0

jgreif

Community Trekker

Joined:

Aug 12, 2012

I've been given a large .dat file and an SAS script file to create an SAS data file with appropriate labels, column size, etc.  I can't make the SAS script work in JMP.  Is there a way to convert the SAS script into usable JMP script, or to use SAS on line to create my SAS file?  Thanks for your help.

Jon

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

These 2 files may help get you going. It would be easier by far to have the folks who sent you the SAS code run it against your data, but failing that, you can follow the example and manually convert the SAS input stuff into JMP input JSL. The JSL file I attached reads in all of the records in the attached data file (2 of them) and the first few columns, still fewer of which contain script to use Value labeling for the codes. Before you run this against your real data you should probably change the word "All" to some low number like 10 or 20.

Michael

5 REPLIES
jgreif

Community Trekker

Joined:

Aug 12, 2012

Still hoping for some help here!!!  Thanks, Jon.

mpb

Super User

Joined:

Jun 23, 2011

What does the .dat file look like? Or perhaps equivalently, what does the SAS code look like?

jgreif

Community Trekker

Joined:

Aug 12, 2012

Thanks very much.  I've attached the SAS script file.  The .dat data file is quite large, and I'm really not at liberty to share, but, it is basically 2.4 million lines which are strings of letters and numbers that represent medical registry data.  Really appreciate your help.

Jon

Solution

These 2 files may help get you going. It would be easier by far to have the folks who sent you the SAS code run it against your data, but failing that, you can follow the example and manually convert the SAS input stuff into JMP input JSL. The JSL file I attached reads in all of the records in the attached data file (2 of them) and the first few columns, still fewer of which contain script to use Value labeling for the codes. Before you run this against your real data you should probably change the word "All" to some low number like 10 or 20.

Michael

jgreif

Community Trekker

Joined:

Aug 12, 2012

Michael. Thank you very much.  You gave me just enough information to complete the script and upload my data file.  I really am very grateful!!!

Jon