About mark_anawis

mark_anawis · ‎08-18-2020

Add date time format with decimals for seconds such as: column("my_column_name") << format("yyyy-mm-ddThh:mm:ss.S");

mark_anawis · ‎06-14-2019

Dear Fellow Midwestern JMP Users, we are working on setting up our next meeting over the next few months.Our members are typically from Illinois, Indiana, Michigan, and Wisconsin., The meeting will be a physical meeting in the north suburbs of Chicago, likely at Abbott Labs since I can arrange a conference room there. Please send us ideas of topics you would like to see covered. Any format suggestions would be appreciated. We used to have 3-4 x 50 min lecture presentations with 10 min for questions after each lecture on a given larger topic like Design of Experiments, but we are open to suggestions. We have done a question & answer session each meeting, but we could try other formats. If you have a meeting site that you can offer the group to use and/or would like to present, we are open to that. Suggestions as to meeting duration and days of the week are appreciated. The only requirement we have is that you do not bring any confidential data or information to the group meetings as many of our group are from the corporate world. We look forward to hearing from you! Regards, Mark Anawis and John Wass

mark_anawis · ‎06-14-2019

Hello Laura and Stan, Yes, let's talk. I am open all day Tues and Wed next week (6/18,6/19). I am in CDT time zone. We are about 1 hour north of Chicago. We can do a phone call. My #224-667-4347. My work email: mark.anawis@abbott.com. We can share some ideas. Best Regards, Mark Anawis

mark_anawis · ‎06-07-2019

Hello Laura and Stan, we are currently exploring ideas for formats for the meetings (e.g. live vs. web-based) and topics. While we do have access to venue sites for the meetings, attendance at the last few meetings has fallen so we went on hiatus. However, we intend to continue with the group and would appreciate any ideas anyone would have. Regards, Mark Anawis

mark_anawis · ‎01-18-2019

Add Legend to Latent Class Analysis to display color groups of clusters.

mark_anawis · ‎01-11-2019

Good afternoon. I installed the addin and ran it using JMP Pro 14.1 with Windows 7. It did not return a cat picture and I received the following error for the Random Cat option even when I increased the Internet Open Timeout to 10000: GET http://thecatapi.com/api/images/get?concept_tags=false&limit=1000 Failed to connect to thecatapi.com port 80: Timed outEmpty()

mark_anawis · ‎01-11-2019

Hi John, on the ouptut report next to the left of the Model, there is a red arrow. You can select "Save Formulas" and new columns are created for your model. From the JMP menu at top, you can select Rows > Add Rows. Enter 10 for "How many rows to add" and keep default of "At end". Enter your 10 new values in these empty rows and JMP should calculate your probabilities.

mark_anawis · ‎01-10-2019

Hi Ana, Have you tried "Match"? If you select the column name first and single-click on "Match", it shows you a submenu where you can automatically add the Match arguments from the data (i.e. the values in your column). Then you can add the value you want returned in each then clause.

mark_anawis · ‎01-10-2019

When using JSL, update the Make Validation Column function to accept column names for Stratified Random, Grouped Random, and Cutpoint options. I know you can use formula random and add a by(:Group) but there should be a direct way to do this. Example: current data table() << Make Validation Column( Training Set( 0.50 ), Validation Set( 0.25 ), Test Set( 0.25 ), Stratified Random ("My_Column_Name") );

mark_anawis · ‎09-12-2018

I would like to be able to use my JMP Pro License either on my laptop/desktop or in Amazon Web Services, rather than buying two separate licenses.

mark_anawis · ‎01-09-2017

The date and format of the date in the TO_DATE function need to match. Try this in the select section of the script I sent: TO_DATE( SUBSTR (txntime, 1,4)||"/"||SUBSTR(txntime,5,2)||"/"||SUBSTR(txntime,7,2)||" "|| SUBSTR(txntime,10,2)||":"||SUBSTR(txntime,12,2)||":"||SUBSTR(txntime,14,2), 'yyyy/mm/dd hh24:mi:ss') txntime

mark_anawis · ‎01-06-2017

Although I don't currently have JMP Pro 13, I suggest you try a script which you can add to the data table (see below but substitute your y and x variable names and the type of Oneway if you are not running All Pairs before running the script). You can set the preferences for all 6 Oneway Means Comparison and also remove the Comparison Circles in a separate command. The latter Comparison Circles can be accessed from the report's topmost Oneway Analysis hotspot (red triangle) Display Options, Comparisons Circles. Just uncheck the latter. If none of these work, I suggest contacting the JMP Tech Support (JMP Technical Support <support@jmp.com>). They are very helpful and responsive. Platform Preferences( Oneway Means Comparisons( Difference Matrix( 1 ), Confidence Quantile( 1 ), LSD Threshold Matrix( 1 ), Connecting Letters Report( 1 ), Ordered Differences Report( 1 ), Detailed Comparisons Report( 1 ) )); Oneway( Y( :yvariable ), X( :xvariable ), All Pairs( 1), Comparison Circles( 0 ) );

mark_anawis · ‎01-05-2017

I think you need to enforce the format for the from date and to date which the user enters so I've provided an option. However, I think the major issue is in the where statement so I've provided an option which should get you close to what you need. Delete Symbols(); Delete Globals(); nw = new window("Scrap Data", << modal(), panelbox("Enter Date Range", hlistbox( text box("From Date"), fromdate_teb = text edit box(format(today(),"y/m/d h:m:s"), << set width (100)), ), hlistbox( text box("To Date"), todate_teb = text edit box(format(today(),"y/m/d h:m:s") , << set width (100)), ), ), panelbox("Actions", hlistbox( ok_button = button box("OK", fromdate = fromdate_teb << get text(); todate = todate_teb << get text(); ok_pushed = 1;), cancel_button = button box("Cancel", ok_pushed = 0), ) ) ); Open Database("Generic database connection string", " SELECT p.productname, p.model, p.family, TO_DATE (SUBSTR (txntime, 1, 15), 'yyyy/mm/dd hh24:mi:ss') txntime FROM database p WHERE txntime >= to_date('"|| fromdate || "', 'yyyy/mm/dd hh:mi:ss am') AND txntime < to_date('"|| todate || "', 'yyyy/mm/dd hh:mi:ss am') ", // End of SQL statement "New_Table" // New table name --> can be changed as per requirements );

mark_anawis · ‎01-05-2017

Is Index the expected output that you want, that is the running count of your Site_ID and p_code?

mark_anawis · ‎01-05-2017

Can you send part of your table as well as an expected output?

mark_anawis · ‎01-05-2017

Have you tried using Tabulate platform with Site_ID and P_Code as rows to get a count of occurrences rather than creating a column with a formula?

mark_anawis · ‎01-05-2017

Sometimes JMP needs to finish a command before continuing to the next command so adding a wait statement allows it to finish the previous command.

mark_anawis · ‎01-05-2017

Try adding a wait statement. For example: dt=Open("mypath\table.jmp"); wait(0); dt<<go to row(nrow(dt));

mark_anawis · ‎06-27-2016

Great improvement. Here is another suggestion for matrices: simplify the indexing when you are using a conditional. This is best explained through an example. Let's say I have a matrix that I want to find and return the values greater than 5: mymatrix = [2,4,6,8,10]; newmatrix=mymatrix[loc(mymatrix>5)]; Compare this to similar code in R: mymatrix = matrix(cbind(2,4,6,8,10)); newmatrix=mymatrix[mymatrix>5]; OK, the first statement in R is longer and the second statement returns a vector rather than a matrix, but the second statement is shorter. It would be nice if JMP could implement the simpler syntax in the second statement in future versions.

mark_anawis · ‎06-23-2016

Hot spots.

mark_anawis · ‎06-23-2016

I agree that the new handling of the single value matrix is an improvement, but I also second Mark Bailey's request for elimination of the confusing empty matrix output [](0,1). Replacing it with [] would be easier for the user to understand and deal with. I usually use logic such as the following to handle this situation: dt=current data table(); rows_to_capture=dt<<get rows where(:mycolumn==number); if(nrows(rows_to_capture)==0, expr_when_no_rows, expr_when_there_are_rows);

mark_anawis · ‎05-10-2016

We are investigating Deep Learning for predictive modeling to identify instrument subsystem failures using R and Python packages. Since Deep Learning is similar to neural nets, perhaps these can be used as the basis of a script to expand the number of layers. Deep Learning would be a good tool for future versions of JMP Pro.

Date Registered	‎11-18-2014 10:32 AM
Date Last Visited	Monday
Total Messages Posted	22
Total Kudos Received	9

Online Status	Offline
Date Last Visited	Monday