JMP User Community

Latest Discussions

TXT file import issue

Dear JMP users, I am facing a problem while importing a TXT file. I am using the Following jsl instruction:Open("U:\Lib\PRODUCTION\Report_Prod.txt");I had no problem until a couple of weeks when it came that some data were missing. I could not understand why as data were visible in the file when importing the .txt file into Excel.Today, I finally tried to import using "Load Text File" jsl instruct...
J_Bonnouvrier1

Discussions |
Mar 24, 2020 4:55 AM

6964 views | 5 replies
How to replace the text in JSL thru User Interface(a dialog window)

Hi,I've been using SQL in my JSL, and declared 4 variables and set required value.(see below script)What I want is to create a new window as user interface.. when run this JSL, pop up the window first to allow user to input different values for the variables.For example: 1st run JSL, user input: x,y,z,n for the 4 variables, to achieve the effect like below:set @spec = 'x'
set @opn = 'y'
set @Loss = ...
steven_gong

Discussions |
Mar 24, 2020 12:15 AM

2725 views | 3 replies
How Do I Make a Data Column Numeric Continuous

I've been stumbling over this and haven't been able to find the proper syntax. In my data I have a column titled "InstHead_Serial", which is always a numeric value of 6 numeric characters, with no decimal. I want to treat the data as numeric in my analysis, but when it gets pulled in from our database it is character type data. I've been trying many permutations of the command below to conve...
Tom_Watson

Discussions |
Mar 23, 2020 5:48 PM

12015 views | 4 replies
JSL Optimization for speed: Avoiding repeated calls to Save Presentation ("File", Append)

Hi JMP Community, I'm making some progress in my attempt to generate PowerPoint slides assembled from the Plots stored in multiple journals (JRN) files.The following script produces the right output but it is quite slow most likely due to the repeated calls to << Save Presentation ("file_name", Append).I think it would be much faster to aggregate the different plots in a master container (new wind...
Thierry_S

Discussions |
Mar 23, 2020 9:49 AM

2091 views | 1 replies
heatmap of the US

I'm looking to create a map of the US in JMP that shows dollars by zip code. Is there a way I can do this in JMP?
biancapiccirill

Discussions |
Mar 23, 2020 7:04 AM

13302 views | 6 replies

Previous
Next

Latest Discussions

TXT file import issue

Dear JMP users, I am facing a problem while importing a TXT file. I am using the Following jsl instruction:Open("U:\Lib\PRODUCTION\Report_Prod.txt");I had no problem until a couple of weeks when it came that some data were missing. I could not understand why as data were visible in the file when importing the .txt file into Excel.Today, I finally tried to import using "Load Text File" jsl instruct...
J_Bonnouvrier1

Discussions |
Mar 24, 2020 4:55 AM

6964 views | 5 replies
How to replace the text in JSL thru User Interface(a dialog window)

Hi,I've been using SQL in my JSL, and declared 4 variables and set required value.(see below script)What I want is to create a new window as user interface.. when run this JSL, pop up the window first to allow user to input different values for the variables.For example: 1st run JSL, user input: x,y,z,n for the 4 variables, to achieve the effect like below:set @spec = 'x'
set @opn = 'y'
set @Loss = ...
steven_gong

Discussions |
Mar 24, 2020 12:15 AM

2725 views | 3 replies
How Do I Make a Data Column Numeric Continuous

I've been stumbling over this and haven't been able to find the proper syntax. In my data I have a column titled "InstHead_Serial", which is always a numeric value of 6 numeric characters, with no decimal. I want to treat the data as numeric in my analysis, but when it gets pulled in from our database it is character type data. I've been trying many permutations of the command below to conve...
Tom_Watson

Discussions |
Mar 23, 2020 5:48 PM

12015 views | 4 replies
heatmap of the US

I'm looking to create a map of the US in JMP that shows dollars by zip code. Is there a way I can do this in JMP?
biancapiccirill

Discussions |
Mar 23, 2020 7:04 AM

13302 views | 6 replies
how to change one column to percentage format

Like change the weight column to persentage: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); how to covert the "weight" column as "95/100*100"=95%. 95% as the final result? height weightKATIE small F 59 95
LOUISE small F 61 123
Theresa

Discussions |
Mar 22, 2020 7:47 PM

7063 views | 1 replies

Previous
Next

Latest Discussions

How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2261 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

2061 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1688 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1624 views | 0 replies
Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1718 views | 0 replies