About MTOF

MTOF · ‎09-23-2014

Hi Mark Thanks for posting this. I would be great if it could be done BY a grouping variable. BR, Marianne

MTOF · ‎09-17-2013

Hi Try removing the lock on the column first: dt= current data table () ; dt1= dt << summary(Group( : Group 1) , mean ( : data 1 , : data 2)) ; dt2= dt << summary(Group( : Group 2) , mean ( : data 1 , : data 2)) ; dt1: Group 1 << set lock( 0 ) ; dt1 : Group 1 << set name ( "Group" ) ; dt2 : Group 2 << set lock( 0 ) ; dt2 : Group 2 << set name ( "Group" ) ; dt3=dt1 << concatenate(dt2) ; close(dt1, no save); close(dt2, no save); BR, Marianne

MTOF · ‎10-22-2012

Hi Eifrid Use Analyze/Fit Model. Put all (Random and Fixed) factors into Model Effects. Mark the Random ones and click the small red triangle Attributes and select Random Effect. Read more in the Help: Contents/Statistics and Graphics Guide/Standard Least Squares: Random Effects BR, Marianne

MTOF · ‎09-16-2012

On Windows, you can use the scheduler (on XP is under Control Panel/Scheduled Tasks). Put //! in the first line of your script so that is runs automatically. Put exit(no save) or something like that at the end, so that JMP closes when the script is done. BR, Marianne

MTOF · ‎07-18-2012

I'll get in contact with our IT guys. Thank you so much for your help sorting this out! BR, Marianne

MTOF · ‎07-18-2012

No, I really have done as you write and get the path in my previous reply. I'm on Windows XP - maybe you're on something different? Anyway - removing the http: and exchanging the front slashes with back slashes worked to a certain extent... Now JMP understands what I want to do and tries to save the file with the correct name in the correct folder. Only now I get an error message: I/O problem. Unable to open in ReadWrite mode. The specified network name is no longer available. Unable to save file. Looks like some kind of permission problem, but my permissions on this sharepoint is "Full Control" - I thought that was good enough.

MTOF · ‎07-12-2012

Dear PMroz Thank you for your comment, but this is exactly what I've done! Opened the Sharepoint folder in Windows Explorer and copied the path from here: ::pathstr="http://mysite.mycompany.net/mysubject/JMP_DB/";. This path works fine with dt=open(::pathstr||"MyTable.jmp"). But it doesn't work with dt<<save(::pathstr||"MyTable.jmp"); See explanation of what happens in my reply above. BR, Marianne somehow got an extra set of http: in the above text... Message was edited by: Marianne Toft

MTOF · ‎07-12-2012

Hello Guillaume Thank you for trying to help . Yes, my path is a string (defined as ::path = " http:// ..............\"; ) The path as such works fine, otherwise the open command would not have worked. But when saving the problem occurs. I've nailed the problem, but don't know how to overcome it! The problem is that Save interprets the input string I give it in the wrong way. dt<<Save("MyTable.jmp") saves dt as MyTable.jmp in the current directory . dt<<Save("C:\Program Files\MyTable.jmp") saves dt as MyTable.jmp in C:\Program Files . dt<<Save(" http://........\MyTable.jmp ") is supposed to save dt as MyTable.jmp in the specified folder on the Sharepoint (given by the path), but instead saves dt in the current directory as a file named http---..................MyTable.jmp . There is no error message in the log - only 'Scriptable[]' as JMP does save the file - just in the wrong place with the wrong name... I've also tried changing directory using set current directory, thinking that then I could save the file using dt<<Save("MyTable.jmp") afterwards, but nothing happens (no error message, no change in directory). set current directory (::path); BR, Marianne

MTOF · ‎07-11-2012

Hi All I have succeded in reading data tables (uploaded manually) from a sharepoint using JSL. However, I cannot find a way to make JMP (version 8.0.2 on Windows) save a file to this sharepoint. To read a file I use: dt = open(::path||"MyTable.jmp"); where path is a long string starting with http:// ..... This works fine. To save a file I use: dt << save(::path||"MyTable1.jmp") JMP interprets ::path||"MyTable1.jmp" as the filename and not as the full path incl filename!? And saves the file with a stupidly long name in the current directory in stead of on the sharepoint... Any suggestions are highly appreciated! BR, Marianne

MTOF · ‎02-09-2012

You don't have to script it - just make a new column and add a formula. Concatenation is under Character. The " (" and ")" you write yourself and the Column 1 and Column 2 are chosen from the list, so that the final formula is: :Column 1 || " (" || :Column 2 || ")" If you want it to be scripted, this is a shorter version of above. dt << new column ( "Concatenated" , character, formula( :Column 1 || " (" || :Column 2 || ")" )) ;

MTOF · ‎01-06-2012

JMP can do PLS as well - it's under Analyze/Multivariate Methods. BR, Marianne

MTOF · ‎11-02-2011

Are you creating the column NumberFlag in the script? Could it be that the creation of the column (or population of values) is not finished when you try to access the values? Then a wait(0) might help? If it contains a formula, adding 'eval formula' at the end of the new column might also help. new column("NumberFlag", character, formula(if(:Result<5, "Low", "High")), eval formula);

MTOF · ‎11-01-2011

Excellent, just what I needed

MTOF · ‎11-01-2011

Hi "whom" Try using k instead of j. J is also an inbuilt jsl function, an even if you try to tell JMP you don't mean the function J but variable ::j it doesn't seem to work. At least that's my experience - I'm still in JMP 8.0.2, this might be different in version 9. BR, Marianne

MTOF · ‎10-18-2011

Hi Does anyone know how to script the creation of a new column with initial data values ? Below is my best guess, but it doesn't work. Cannot find any help on "initial data values" in the scripting guide. BR, Marianne dt=current data table(); dt<<new column("Selected", character, initial data values(constant("YES")));

MTOF · ‎07-14-2011

Hi Allan I've had the same problem/wish as you and haven't found a way to do exactly what you're asking. Instead of row state colors I used Value Colors on the column in question. When adding a Legend to a plot, Value Colors show up as coloring scheme. Is this of any help?? BR, Marianne

MTOF · ‎07-11-2011

Hi JMP doesn't finish one "command" before moving on to the next - it reads the 'new column' command and starts executing it, but continues to read and perform the next commands. What happens here is that the 'New Column' commands are not finished executing (this type of command especially takes some time because the graphics have to be updated), before JMP reads the final line with the 'show' commands, so there are no values in the columns at the time this command is executed. Either 'flush' the formulas as above or put a 'eval formula' directly into the 'new column' command, e.g. new column("title", numeric, formula(:X1*:X2), eval formula); As far as I have understood the two approaches have the same effect. BR, Marianne PS: I'm not from JMP

MTOF · ‎07-08-2011

For a qualitative variable with n modalities, you get n-1 parameter estimates.That can be very confusing! If you want to know if the variable "as a whole" has a significant influence on your response, look at the Effect Tests output - there you only have one row of output and one F test for the qualitative variable. If the F-test is insignificant - you can remove the variable. If the F-test is significant, it means that at least two of the modalities give significantly different response. If you want to know which are different, look at the Effect Details output, find the qualitative variable in question, press the red triangle next to the name and select LSMeans Tukey LSD - that will give you a list showing which are different. Regarding R2 - you shouldn't optimize the model using R2, as R2 is prone to overfitting and will reduce when you remove any term. In stead use the Effect Tests and remove insignificant terms! This is the classical approach. There are other methods for finding the most correct model like crossvalidation (only in JMP Pro) and Mallow's cp (under Stepwise) - look them up in the Help. BR, Marianne

MTOF · ‎07-08-2011

Hi. Are you sure you need to recode the qualitative variables? Do you mean to 0-1 variables? In Fit Model you can fit MLR models with quantitative as well as qualitative parameters without coding. BR, Marianne

MTOF · ‎07-08-2011

Using :: for global variables was also recommended for JMP 8, but not enforced (i.e. it generally worked anyway unless the global variable had a name that could be confused with a column name or an inbuilt function). But in JMP 9 it is more strictly enforced - thus the difference between JMP 8 and JMP 9. BR, Marianne

MTOF · ‎07-08-2011

Or - if you have to make a new column anyway: dt << new column ( "Eligible" , character , formula( If ( : Age < 15 , "no" , : Age >= 15 , "yes" ))); BR, Marianne

MTOF · ‎07-08-2011

Hi Dan Does this solve your problem? It saves the predicted values in a column with a formula attached. linfit = Fit Model( Y( : Yvar ) , Effects( : Xvar ) , Personality( Standard Least Squares ) , Run model ); linfit << prediction formula ; BR, Marianne

MTOF · ‎07-01-2011

Hi Chris There's a thin grey line just below the blue bar at the top of the window. Clicking that will show the full toolbar. BR, Marianne

MTOF · ‎07-01-2011

Hi Paul Assuming your columns are called Rating and Date You could add two columns Month and Year with the formulas month(Date) and year(Date) (they are both in the Date Time group) respectively. Then do Tables/Summary, Statistics:Mean of Rating and Group:Year and Month. BR, Marianne

Date Registered	‎06-30-2011 02:52 AM
Date Last Visited	‎09-25-2020 08:14 AM
Total Messages Posted	47
Total Kudos Received	2

Online Status	Offline
Date Last Visited	‎09-25-2020 08:14 AM