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

[#1]

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

[#2]

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

[#3]

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

[#4]

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

[#5 · Accepted 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

[#6]

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