importing SAS 9.4 custom formats to JMP 12 Pro

Question

Hi,

I have been working with a dataset in SAS 9.4 and I have created custom formats for some of the variable values. I then want to look at the dataset in JMP but regardless of how i move the dataset to JMP ( i.e., "view in JMP" through sas's explorer window, exporting via SAS code to .sas7bdat file type) I am not able to maintain variable custom formats. I have noticed that i do retain custom formats which appear to be created in SAS ver. 7|8 but not those created in SAS ver. 9.4.

In JMP these custom formats are called "value scores".... where in SAS they are defined like:

proc format ;

value employ_ 0 = "0 = Unemployed" 1 = "1 = Employed" 3 = "3 = Retire & Not Working"

;

run;

I've been trying to setup a metadata server (which I'm not sure will resolve this problem) for my local machine but my firewall settings are locked down right now.

Will the metadata server resolve this problem or should I be doing something else in order to get SAS to pass the formats to JMP?

Thanks,

albest3 · Answer

I too am trying to get a sas dataset with user-defined formats into a jmp datafile with value labels.

I've tried all of the options in this thread and none work. (I'm using SAS v9.4 and JMP pro v 15.2)

Even the simplest dataset doesnt come across correctly ... even when I use the browse sas data process in JMP. I welcome feedback on what I'm missing.

Libname library "C:\Users\albest\Desktop";
Proc Format library=Library;
Value $MF "M"="male" "F"="female";
Value highlow 100="one H" 200="two H";
Data Library.Test;
Input Sex $ age;
Format Sex $mf. ;
Format age highlow.;
Label Sex="Sex label";
Label Age="Age label";
Datalines;
M 1
M 100
F 2
F 200
Proc Contents;
Run;

PROC EXPORT DATA= Library.Test
OUTFILE= "C:\Users\albest\Desktop	est.jmp"
DBMS=JMP label REPLACE ;
RUN;

teebahnson · Answer

My fix for this is to export from SAS to JMP using the following code:

PROC EXPORT DATA= (sas dataset with custom formats)
OUTFILE= "jmp_dataset with custom formats as value labels.jmp"
DBMS=JMP label REPLACE ;
RUN;

Jeff_Perkinson · Answer

The first thing to know is that the SAS session you are running interactively is not the same SAS session that JMP is connecting to. Therefore they don't share a WORK library.

You'll want to copy the datasets to a permanent library and then make sure the libref is assigned in the SAS session that JMP is connected to. You can do that with File->SAS->New SAS Program. You'll get a SAS Program window and you can put your LIBNAME statement in there, then right click and choose Submit to SAS.

Then that library should show up in your Browse Data window and you'll be good to go.

Let us know how you make out.

-Jeff