About gbu

gbu · ‎08-09-2013

Hello, Maybe this previous post can answer your question https://communities.sas.com/thread/35175?start=0&tstart=0 Regards

gbu · ‎08-08-2013

Something like this ? Graph Builder( Show Control Panel( 0 ), Variables( X( :Day ), Y( :Defect1 ), Y( :Defect2, Position( 1 ) ), Y( :Defect3, Position( 1 ) ), Y( :Yield, Position( 1 ), Side( "Right" ) ) ), Elements( Line( X, Legend( 8 ), Row order( 0 ), Summary Statistic( "Mean" ) ), Bar( X, Y( 1 ), Y( 2 ), Y( 3 ), Legend( 6 ), Bar Style( "Stacked" ), Summary Statistic( "Mean" ) ), Line( X, Y( 4 ), Legend( 9 ), Row order( 0 ), Summary Statistic( "Mean" ) ), Bar( X, Legend( 10 ), Bar Style( "Stacked" ), Summary Statistic( "Mean" ) ) ), SendToReport( Dispatch( {}, "400", LegendBox, {Position( {0, 1, 2, 3, -1} )} ) ) )

gbu · ‎08-07-2013

Hello, I think that Graph Builder is available in Jmp 8. You can use it to make this kind of graphs. This following script was done with jmp 9 and give similar result than Excel one. ============================= Graph Builder( Show Control Panel( 0 ), Variables( X( :Day ), Y( :Defect1 ), Y( :Defect2, Position( 1 ) ), Y( :Defect3, Position( 1 ) ), Y( :Yield, Position( 1 ) ) ), Elements( Line( X, Y( 4 ), Legend( 8 ), Row order( 0 ), Summary Statistic( "Mean" ) ), Bar( X, Y( 1 ), Y( 2 ), Y( 3 ), Legend( 6 ), Bar Style( "Stacked" ), Summary Statistic( "Mean" ) ) ) ) ============================= You can also read this post on jmp blog. Graph Builder in JMP: A Short Demo and Tutorial - JMP Blog

gbu · ‎08-07-2013

Hi, If you're using an earlier release than jmp10 (for windows), you can in your script create a .bat file and also call this .bat to delete files. =================================================== /* Create a .bat file command with delete instruction */ Save Text File("C:\deletemyfile.bat","del C:\myfolder\myfile.txt"); /* Execute the .bat file in order to delete the file */ Open("C:\deletemyfile.bat"); ===================================================

gbu · ‎07-22-2013

Hi, I use another solution in my company. "Jmp.per" (license file) file is store on a share folder, and with a reg file, you can easily change the default jmp value. Like this jmp is able to find the new license every year. For example, if license is stored on a share drive nammed : L:\licenses\jmp\ You can create a reg file like this (with notepad and save it with the reg extension). =========== Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\SAS Institute Inc.\JMP\9.0\Options] "JMPPerPath"="L:\licenses\jmp\jmp.per" =========== Notes : - this reg is for jmp9, if you're using jmp10, just replace 9.0 by 10.0 - if you're using relative path, please write it like this : \\\servername\\licenses\\jmp\\jmp.per User just have to execute this reg file one time. Automaticaly, jmp now check this new path for the license. Hope that will be hepfull. Regards

gbu · ‎05-18-2013

Hi, Thanks for this great tips. Log Capture function is the function that I was looking for.

gbu · ‎05-16-2013

Hello, I would like to know if there is a way to catch database error message and put it into one jmp variable. Example for an Oracle DB, if I try to insert one value already existing on ID primary key : /* JSL */ sql = "INSERT INTO MY.TABLE (ID, DATA) VALUES ('A',150)"; OpenDatabase (dsnDB, sql); /* LOG display */ [Oracle][ODBC][Ora]ORA-00001: unique constraint (MY.TABLE) violated ORA-06512: at line 1 I would like to have in a jsl variable this sting : "[Oracle][ODBC][Ora]ORA-00001: unique constraint (MY.TABLE) violated". I didn't find any solutions for the moment. Thanks.

gbu · ‎05-14-2013

Hello, You need to contact SAS office : JMP | Contact JMP Regards,

gbu · ‎05-10-2013

Thanks for this official answer.

gbu · ‎04-28-2013

Hello, Yes, concat function works too but only for string and not for number. True ? Do you have any tips for a numeric list ? For example : instead of having choice = {"rouge", "vert", "bleu", "jaune"}; we have numerics values like choice = {12,156,13,25}; and at the end we wants to have : select = "SELECT ...FROM ...WHERE ID IN (12,156,13,25)

gbu · ‎04-26-2013

Salut Antoine, You can do like this : ========================================== choice = {"rouge","vert","bleu", "jaune"}; recall_flag = 0; NW=New Window("Test", H List Box( Text Box( "choose colors" ), y = List Box( choice ) ), V List Box( Button Box( "OK", choice = (y << getselected); ::recall_flag = 1; NW << Close Window; ) ) ); select = "SELECT ... FROM ... WHERE Colors IN 'strchoice' " ; /* Step1 : Create a string from the list using loop - Creation d'une chaine de carcatère au format attendu en bouclant sur le nombre de valeurs */ string_color = "('" || choice[1] || "'"; For( i = 2, i <= Nitems(choice), i++, string_color = string_color || ",'" || choice || "'" ); string_color = string_color || ")"; /* Step2 : Replace the stingchoice by the value of string_color */ select = substitute(select,"'strchoice'",string_color); ========================================== Cordialement, Guillaume

gbu · ‎04-25-2013

If you wanna see the list, you can just use : Print( lstDelete);

gbu · ‎04-10-2013

Hello, If you want to keep the empty column name into list, you could also process like this. dt = Current Data Table(); iColMax = NCol(dt); iRowMax = NRow(dt); null = 0; lstDelete = List(); For (iCol = 1, iCol<=iColMax, iCol++, null = 0; col = Column(iCol); strColName = Column(iCol) << GetName; For (iRow = 1, iRow<=iRowMax, iRow++, If (Or(IsEmpty(col[iRow]),IsMissing(col[iRow])), null = null + 1; ); ); If (null == iRowMax, InsertInto(lstDelete, Eval(strColName)) ); ); dt << Delete Columns(lstDelete);

gbu · ‎03-08-2013

Hi RonF, Maybe this documentation could help you. http://analytics.ncsu.edu/sesug/2012/DJ-01.pdf http://www.jmp.com/software/pdf/JMPConfigurationCitrixAppXen6.pdf http://www.citrix.com/ready/partners/sas-institute/products/jmp

gbu · ‎10-29-2012

Hi, If you're using jmp 10.0.1, some new functions are available http://support.sas.com/demosdownloads/000981/JMP_1001_release_notes.pdf JSL File and Directory commands are available, including : File Exists( path ) Directory Exists( path ) Copy Directory( from, to, {1/*recursive*/} ) Copy File( from, to ) Move Directory( from, to ) Move File( from, to ) Rename Directory( old, new ) Rename File( old, new ) Delete Directory( path ) Delete File( path ) Create Directory( path ) Last Modification Date( path ) Creation Date( path )

gbu · ‎08-13-2012

Hi, JMP Technical Support recommends using MySQL ODBC driver 3.5.x insted of 5.x Regards, Guillaume

gbu · ‎08-09-2012

Hi, Already done. Investigation on going by French support team. Regards, Guillaume

gbu · ‎08-08-2012

Maybe something like this : RowsToDelete = dt << Get Rows Where(:COLUMN_NAME = 4); dt << Delete Rows(RowsToDelete); Regards, Guillaume

gbu · ‎08-08-2012

Hello, I've the same issue even with the new release 10.0.1. It's a regression compare to release 9 but I don't know if jmp is already aware of that cause it's always the same in the new 10 release. A workaround is to use JSL script to extract the data. You can use this one (only have to replace dnsname, userid, pwd, ipadress and databasename variable by your database configuration : dsn = "DSN=dnsname;UID=userid;PWD=pwd;SERVER=ipadress;DATABASE=databasename;PORT=3306;"; sql = "SELECT now();"; OpenDataBase(dsn,sql,"DateTime"); Regards, Guillaume

gbu · ‎07-26-2012

Thanks, good to know but it don't works with OpenDataBase() command.

gbu · ‎07-25-2012

Hi, I've not the answer but I'm intersting to know how you can hide tables. Thanks in advance. Ragards, Guillaume

gbu · ‎07-12-2012

Hello Marianne, Did you try with this syntax ? strpath = " http:// .............."; dt = open(strpath || "MyTable.jmp"); dt << save(strpath || "MyTable1.jmp"); Could you copy the log of the save statement ? Regards, Guillaume

gbu · ‎07-04-2012

Hello, I'm using a lot of sql in my jsl scripts and never have issue with jmp timeout execution. Did you test all the sql query in jmp or in another sql query program ? Regards, Guillaume

gbu · ‎04-04-2012

Excellent. Thanks for your answers and thanks for the tip.

gbu · ‎04-04-2012

Hello, Is everybody know how script the "Show as graph reference lines" in column property Spec limits ? Maybe something to add after target, but nothing found in jsl documentation. col<<Set Property("Spec Limits", {LSL(-1), USL(1), Target(0)}); Any idea ? Thanks Regards, Guillaume

gbu · ‎04-02-2012

Hello Paul, Unfortunately, jmp can only connect with ODBC. For application's deployment , it's a bit heavy. Regards, Guillaume

gbu · ‎10-10-2011

Hi David, Sorry for my late answer, variable name is LanguagePref. Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\Software\SAS Institute Inc.\JMP\9.0\Options] "LanguagePref"="en" Regards, Guillaume

gbu · ‎10-04-2011

Hello, For me the solution is to use English version, even if windows system is in French. I contact the french support. Below the answer : in regedit modify the key HKEY_CURRENT_USER\Software\SAS Institute Inc.\JMP\9.0\Options with en instead of fr. With this modification, all users have the same langage and all scripts work fine Guillaume

gbu · ‎09-29-2011

Hi David, Did you have a response of technical support or may I contact support too ? Thanks Guillaume

gbu · ‎08-24-2011

Seems to work... I tried with several RadioBox like you, but I did'nt know the function group rb1 << group( rb2 ) << group( rb3 ) ; Thanks fo the tip.

Date Registered	‎06-23-2011 08:01 AM
Date Last Visited	‎10-18-2016 10:51 AM
Total Messages Posted	36

Online Status	Offline
Date Last Visited	‎10-18-2016 10:51 AM