JMP User Community

Latest Discussions

adding two columns and doing sum in JSL

i have an excel sheet with the following rows and columns:NumbersRed BlueBlackGreen7006101270091234701214567015167870181891070211101112702411213147027114151670301161718703311819207036120212270391222324now i need to add two columns namely red+blue and black+green and count the total of red+blue for each number and place in the resultant column..and same with the second column too..my result should...
fr2007

Discussions |
Aug 29, 2012 7:45 AM

10567 views | 1 replies
Data Filter Script

In the past I have used an earlier version of JMP. I have now started using JMP 10 and some script that I have used in the past is no longer working. I want to open a data filter, perform some operations e.g. delete some rows, then close the data filter window. In the past I have used this style of command: df = Current Data Table() << Data Filter( Location( {222, 222} ), Add Filter( columns...
phillby

Discussions |
Aug 27, 2012 3:02 PM

9581 views | 2 replies
How can JMP calculate a weighted median?

I have a survey data set with 35000 observations that includes a population weight to estimate the total U.S. I'm not a SAS expert and I need to calculate weighted median as well as weighted quantiles. I have the weight data tagged with the weight role, but that seems to only apply to weighted averages. Any suggestions? Thanks.
jcurry

Discussions |
Aug 22, 2012 9:02 AM

9737 views | 2 replies
Using SAS script to import a .dat file into JMP 10.0

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
jgreif

Discussions |
Aug 19, 2012 8:40 PM

11139 views | 5 replies
Determine column mean by day and within certain hours

Hi Folks,I have some hourly data and I'm trying to calculate the mean of variable x for each Day when Hour >= 1 and <=10. I need to store this computed value in column y for each hour of each day. I have tried Column Mean by Day where I've excluded all hours that fall outside 1 & 10, but Column Mean calculates the value for all data by Day regardless of what's been excluded. Any suggestions on ...
terapin

Discussions |
Aug 16, 2012 10:45 AM

10033 views | 2 replies

Previous
Next

Latest Discussions

How to resize graphs in Graph Builder in JMP10?

Hello everyone, I've recently upgraded to JMP10 and to my dismay i was unable to change the graph size in Graph Builder. This was easy to do in JMP9 - simply drag the edges of the chart outline to change the size of the graph. However in JMP10, neither dragging nor right clicking inside the graph (Graph --> Size/Scale) no longer works. Is this a bug in JMP 10 or is there something wrong with my i...
simonmfelix

Discussions |
Aug 9, 2012 8:32 AM

4241 views | 2 replies
run jsl script from command line in linux

Dear community,I am very new to jmp. i want to use on linux. I have installed jmp on my mac and generated script file. i have many questions1> how i can install jmp on linux. on this page (http://www.jmp.com/support/system_requirements_jmp.shtml) they say they have linux version but can't find anywhere2> what is the command for running script from command line? I am familiar with R.i used to run c...
heena

Discussions |
Aug 6, 2012 2:22 PM

4203 views | 1 replies
Using a JSL script to export reports to Word.

I have a script that generates several report tables and would like to add a bit of code that automatically exports the results of the script to a Word document. I have used both "Save As..." and copy & paste methods outside of the script, but have not found a way of capturing the code to include it in my script. Can this be done using JSL?

Discussions |
Aug 2, 2012 10:55 PM

8419 views | 5 replies
Controlling for a variable using Regression

Would someone be able to explain to me if it is possible to control for one of my IV's when performing linear regression? I would like to control for tenure when predicting compensation from performance. I do not want to use a stepwise method. Any help would be greatly appreciated.Thank you!
sarah_cag

Discussions |
Aug 1, 2012 2:46 PM

3002 views | 0 replies
Bland-Altman plot

I tried to create an Bland-Altman plot using the matched pairs option in JMP. Unfortunately, the plot doesn't include the common +-1,96 sd-line and I haven't figured out how to insert this line into the plot. It's no problem to calculate the sd, but I don't know how to integrate it into the plot.Does anyone have an idea on this?Thanks a lot!
johannes

Discussions |
Jul 25, 2012 12:21 PM

4479 views | 0 replies

Previous
Next

Latest Discussions

Controlling for a variable using Regression

Would someone be able to explain to me if it is possible to control for one of my IV's when performing linear regression? I would like to control for tenure when predicting compensation from performance. I do not want to use a stepwise method. Any help would be greatly appreciated.Thank you!
sarah_cag

Discussions |
Aug 1, 2012 2:46 PM

3002 views | 0 replies
Bland-Altman plot

I tried to create an Bland-Altman plot using the matched pairs option in JMP. Unfortunately, the plot doesn't include the common +-1,96 sd-line and I haven't figured out how to insert this line into the plot. It's no problem to calculate the sd, but I don't know how to integrate it into the plot.Does anyone have an idea on this?Thanks a lot!
johannes

Discussions |
Jul 25, 2012 12:21 PM

4479 views | 0 replies
Sample Size

Hello I have a sample of 159 individuals and I want to run an exploratory factor analysis and confirmatory factor analysis using SAS .How much individuals should I consider in ordrer to run both of them ? Is there a rule to choice?What are the SAS command associated?Can we do them by JMP,Thank you
radhi

Discussions |
Mar 5, 2012 6:36 AM

2354 views | 0 replies
Selecting List of variables

I would like select in a data table some variables from a list that I have copied from a previous analysis or from another data table containing those names in cells. Would some body know a straightforward way to do that?ThanksYves
yves

Discussions |
Jan 4, 2012 8:30 AM

2323 views | 0 replies
oh my - so many different methods to calculate percentiles

http://www.amstat.org/publications/jse/v14n3/langford.htmlGosh - I did not realize there were so many different ways to calculate percentiles! I just noticed my results from Excel (formula =percentile (array, percentile) and JMP (quantile plots and data) differed, and that led me to the above website, which identifies about 12 or more different methods! I am at a bit of a loss, for I often use res...
deer_dog

Discussions |
Nov 29, 2011 8:55 AM

3980 views | 0 replies