topic Using SAS script to import a .dat file into JMP 10.0 in Discussions https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5463#M5462 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; I can't make the SAS script work in JMP.&nbsp; Is there a way to convert the SAS script into usable JMP script, or to use SAS on line to create my SAS file?&nbsp; Thanks for your help. <SPAN __jive_emoticon_name="plain" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" src="https://community.jmp.com/5.0.2/images/emoticons/plain.gif"></SPAN></P><P>Jon</P></BODY></HTML> Mon, 13 Aug 2012 03:48:18 GMT jgreif 2012-08-13T03:48:18Z Using SAS script to import a .dat file into JMP 10.0 https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5463#M5462 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; I can't make the SAS script work in JMP.&nbsp; Is there a way to convert the SAS script into usable JMP script, or to use SAS on line to create my SAS file?&nbsp; Thanks for your help. <SPAN __jive_emoticon_name="plain" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" src="https://community.jmp.com/5.0.2/images/emoticons/plain.gif"></SPAN></P><P>Jon</P></BODY></HTML> Mon, 13 Aug 2012 03:48:18 GMT https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5463#M5462 jgreif 2012-08-13T03:48:18Z Re: Using SAS script to import a .dat file into JMP 10.0 https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5464#M5463 <HTML><HEAD></HEAD><BODY><P>Still hoping for some help here!!!&nbsp; Thanks, Jon.</P></BODY></HTML> Fri, 17 Aug 2012 03:42:50 GMT https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5464#M5463 jgreif 2012-08-17T03:42:50Z Re: Using SAS script to import a .dat file into JMP 10.0 https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5465#M5464 <HTML><HEAD></HEAD><BODY><P>What does the .dat file look like? Or perhaps equivalently, what does the SAS code look like?</P></BODY></HTML> Fri, 17 Aug 2012 21:19:39 GMT https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5465#M5464 mpb 2012-08-17T21:19:39Z Re: Using SAS script to import a .dat file into JMP 10.0 https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5466#M5465 <HTML><HEAD></HEAD><BODY><P>Thanks very much.&nbsp; I've attached the SAS script file.&nbsp; 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.&nbsp; Really appreciate your help.</P><P>Jon</P></BODY></HTML> Sat, 18 Aug 2012 01:59:54 GMT https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5466#M5465 jgreif 2012-08-18T01:59:54Z Re: Using SAS script to import a .dat file into JMP 10.0 https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5467#M5466 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Michael</P></BODY></HTML> Sat, 18 Aug 2012 21:18:14 GMT https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5467#M5466 mpb 2012-08-18T21:18:14Z Re: Using SAS script to import a .dat file into JMP 10.0 https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5468#M5467 <HTML><HEAD></HEAD><BODY><P>Michael. Thank you very much.&nbsp; You gave me just enough information to complete the script and upload my data file.&nbsp; I really am very grateful!!!<SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_macro_emoticon jive_emote" src="https://community.jmp.com/5.0.2/images/emoticons/happy.gif"></SPAN></P><P>Jon</P></BODY></HTML> Mon, 20 Aug 2012 03:40:36 GMT https://community.jmp.com/t5/Discussions/Using-SAS-script-to-import-a-dat-file-into-JMP-10-0/m-p/5468#M5467 jgreif 2012-08-20T03:40:36Z