cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-36207%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36207%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDespu%C3%A9s%20de%20crear%20una%20f%C3%B3rmula%20de%20predicci%C3%B3n%20(por%20ejemplo%2C%20desde%20una%20red%20neuronal)%20y%20crear%20una%20columna%2C%20puedo%20hacer%20clic%20derecho%20en%20esa%20columna%20y%20hacer%20clic%20en%20%22f%C3%B3rmula%22%20y%20ver%20la%20f%C3%B3rmula%20creada.%20%26nbsp%3BEntonces%20puedo%20%22hacer%20clic%20y%20arrastrar%22%20la%20ecuaci%C3%B3n%20en%20un%20archivo%20de%20texto%20como%20una%20ecuaci%C3%B3n%20de%20una%20l%C3%ADnea.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMi%20pregunta%3A%20%C2%BFEs%20posible%20escribir%20este%20proceso%3F%20Quiero%20guardar%20esa%20f%C3%B3rmula%20sin%20tener%20que%20hacer%20el%20proceso%20anterior%20cada%20vez.%20%26nbsp%3B(Ya%20tengo%20un%20script%20que%20ejecutar%C3%A1%20la%20red%20neuronal%2C%20etc.%20s%C3%B3lo%20nada%20que%20pueda%20salvar%20esa%20f%C3%B3rmula%20de%20una%20sola%20l%C3%ADnea).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%C2%A1Gracias%20por%20tu%20tiempo!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36248%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36248%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGracias%2C%20Mark.%20Realmente%20aprecio%20tu%20tiempo.%20%26nbsp%3BDescubr%C3%AD%20que%20pude%20imprimir%20(pero%20no%20en%20un%20archivo%20separado)%20la%20f%C3%B3rmula%20completa%20(usando%20el%20comando%20Show%20())%20haciendo%20algo%20como%20esto%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eresult%20%3D%20Column%20(%22Predicted%20x%22)%20%26gt%3B%26gt%3B%20Get%20Formula%3C%2FP%3E%3CP%3EMostrar%20resultado)%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUna%20vez%20que%20vi%20que%20la%20ecuaci%C3%B3n%20impresa%20coincid%C3%ADa%20con%20lo%20que%20quer%C3%ADa%20(con%20el%20comando%20Show%20())%2C%20intent%C3%A9%20convertirla%20en%20una%20cadena%20para%20usar%20el%20comando%20%22Guardar%20archivo%20de%20texto%22.%20%26nbsp%3BSin%20embargo%2C%20al%20convertir%20la%20f%C3%B3rmula%20en%20una%20cadena%2C%20se%20obtuvo%20esta%20salida%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProb%C3%A9%20esto%20intentando%20convertir%20algo%20simple%20como%20%22tan%20(a%20%2B%20b)%22%20en%20una%20cadena%2C%20pero%20dentro%20del%20comando%20char%20()%2C%20intenta%20resolver%20%22tan%20(a%20%2B%20b)%22.%20%26nbsp%3BNo%20estoy%20seguro%20si%20eso%20es%20lo%20que%20est%C3%A1%20pasando%20con%20lo%20anterior.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPero%20veo%20que%20su%20soluci%C3%B3n%20propuesta%20incluye%20un%20poco%20m%C3%A1s%20de%20sintaxis%20que%20no%20estaba%20incluida%2C%20por%20lo%20que%20le%20dar%C3%A9%20una%20oportunidad%20ahora.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36245%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36245%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%3CSPAN%3EEste%20script%20no%20es%20una%20soluci%C3%B3n%20general%2C%20pero%20muestra%20c%C3%B3mo%20podr%C3%ADa%20hacerlo%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Edt%20%3D%20Open(%20%22%24SAMPLE_DATA%2FBig%20Class.jmp%22%20)%3B%0A%0Ann%20%3D%20dt%20%26lt%3B%26lt%3B%20Neural(%0A%20Y(%20%3Aweight%20)%2C%0A%20X(%20%3Aage%2C%20%3Asex%2C%20%3Aheight%20)%2C%0A%20Informative%20Missing(%200%20)%2C%0A%20Validation%20Method(%20%22Holdback%22%2C%200.3333%20)%2C%0A%20Fit(%20NTanH(%203%20)%20)%0A)%3B%0A%0Ann%20%26lt%3B%26lt%3B%20Save%20Formulas%3B%0A%0Aformula%20string%20%20%20%3D%20Char(%20%3AH1_1%20%26lt%3B%26lt%3B%20Get%20Formula%20)%20%7C%7C%20%22%5C!n%22%3B%0Aformula%20string%20%7C%7C%3D%20Char(%20%3AH1_2%20%26lt%3B%26lt%3B%20Get%20Formula%20)%20%7C%7C%20%22%5C!n%22%3B%0Aformula%20string%20%7C%7C%3D%20Char(%20%3AH1_3%20%26lt%3B%26lt%3B%20Get%20Formula%20)%20%7C%7C%20%22%5C!n%22%3B%0Aformula%20string%20%7C%7C%3D%20Char(%20%3APredicted%20weight%20%26lt%3B%26lt%3B%20Get%20Formula%20)%3B%0A%0ASave%20Text%20File(%20%22My%20NN%20Formula.txt%22%2C%20formula%20string%20)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36244%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36244%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EInteresante%2C%20as%C3%AD%20que%20tal%20vez%20si%20pueda%20dividir%20la%20f%C3%B3rmula%20con%20%22Guardar%20f%C3%B3rmula%22%20en%20lugar%20de%20seleccionar%20%22Guardar%20f%C3%B3rmulas%20de%20perfil%22%2C%20entonces%20podr%C3%A9%20juntar%20toda%20la%20f%C3%B3rmula.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36243%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36243%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGracias%2C%20Mark%2C%20%C2%BFno%20hay%20una%20sintaxis%20actual%20para%20%22agarrar%22%20una%20f%C3%B3rmula%20de%20la%20red%20neuronal%20en%20un%20script%3F%20Como%20mencion%C3%A9%20anteriormente%2C%20lo%20que%20he%20estado%20haciendo%20es%20abrir%20el%20editor%20de%20f%C3%B3rmulas%20(para%20ver%20la%20f%C3%B3rmula%20de%20la%20red%20neuronal)%2C%20luego%20haga%20clic%20y%20arrastre%20la%20f%C3%B3rmula%20a%20un%20archivo%20de%20texto.%20%26nbsp%3BParece%20que%20tiene%20que%20haber%20una%20manera%20de%20sacar%20esa%20ecuaci%C3%B3n.%20%26nbsp%3B%C2%A1Gracias%20por%20echar%20un%20vistazo!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36242%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36242%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ENeural%20guarda%20el%20modelo%20ajustado%20como%20una%20serie%20de%20columnas%20con%20f%C3%B3rmulas%20para%20cada%20nodo%20oculto%20y%20para%20la%20acumulaci%C3%B3n%20de%20los%20nodos%20ocultos%20para%20cada%20respuesta.%20No%20es%20el%20mismo%20resultado%20que%20cuando%20se%20ajusta%20un%20modelo%20lineal.%3C%2FP%3E%0A%3CP%3EPor%20cierto%2C%20obtuve%20la%20expresi%C3%B3n%20de%20f%C3%B3rmula%20con%20este%20mensaje%20cuando%20se%20envi%C3%B3%20a%20la%20columna%20de%20f%C3%B3rmula%20de%20predicci%C3%B3n.%20Requerir%C3%ADa%20la%20sustituci%C3%B3n%20con%20las%20f%C3%B3rmulas%20de%20los%20nodos%20ocultos%20individuales%20(H1%20...%20Hn)%20para%20expandirlo%20completamente.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36241%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36241%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EHola%20Jim%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%C3%AD%20que%20eso%20funciona%20para%20la%20mayor%C3%ADa%20de%20las%20ecuaciones%2C%20pero%20si%20estoy%20tratando%20de%20hacer%20eso%20para%20una%20f%C3%B3rmula%20generada%20a%20partir%20de%20una%20%3CSTRONG%3E%20Red%20neuronal%20%3C%2FSTRONG%3E%20%2C%20el%20%22Get%20Formula%22%20devuelve%20esto%20para%20la%20ecuaci%C3%B3n%20%2F%20f%C3%B3rmula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeural%20%5B%5D%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%C2%BFSabe%20si%20hay%20otra%20forma%20de%20llamar%20u%20obtener%20la%20f%C3%B3rmula%20utilizada%20para%20un%20c%C3%A1lculo%3F%20Es%20una%20ecuaci%C3%B3n%20larga%2C%20por%20lo%20que%20se%20pregunta%20si%20hay%20un%20l%C3%ADmite%20de%20caracteres%20para%20%22Obtener%20f%C3%B3rmula%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGracias%2C%20%3CBR%20%2F%3E%20Juan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36225%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36225%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EUsted%20es%20correcto%20y%20el%20ajuste%20que%20realiz%C3%B3%20debe%20hacer%20que%20funcione%20sin%20problemas.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36223%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36223%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EGracias%20de%20nuevo%20por%20la%20respuesta%2C%20sin%20embargo%2C%20%C2%BFno%20funciona%20el%20%22Guardar%20archivo%20de%20texto%22%20solo%20para%20cadenas%3F%20(donde%20incluy%C3%B3%20la%20'x').%20%26nbsp%3BAs%C3%AD%20que%20creo%20que%20tendr%C3%A9%20que%20intentar%20algo%20como%20x%20%3D%20char%20(col%20%26lt%3B%26lt%3B%20obtener%20f%C3%B3rmula).%20%26nbsp%3BVoy%20a%20ver%20si%20eso%20funciona.%20%26nbsp%3BSi%20tienes%20alguna%20otra%20idea%2C%20%C2%A1no%20dudes%20en%20hac%C3%A9rmelo%20saber!%20Gracias.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36215%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36215%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%C2%A1Muchas%20gracias!%20Le%20voy%20a%20dar%20una%20oportunidad.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36214%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%C2%BFEs%20posible%20extraer%20la%20f%C3%B3rmula%20de%20predicci%C3%B3n%20como%20una%20f%C3%B3rmula%20de%20una%20l%C3%ADnea%20en%20el%20script%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36214%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3Ex%20%3D%20col%20%26lt%3B%26lt%3B%20obtener%20f%C3%B3rmula%3B%3C%2FP%3E%0A%3CP%3Eguardar%20archivo%20de%20texto%20(%22ruta%20al%20archivo%22%2C%20x)%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ever%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Ayuda%20%3D%3D%26gt%3B%20%C3%8Dndice%20de%20secuencias%20de%20comandos%20%3D%3D%26gt%3B%20Tabla%20de%20datos%20%3D%3D%26gt%3B%20Secuencias%20de%20comandos%20de%20columnas%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
showtime287
Level I

Possible to extract Prediction Formula as a one line formula in script?

Hello, 

 

After creating a prediction formula (say from a Neural Network) and a column is created, I can right click on that column and click "formula" and view the created formula.  I then am able to "click and drag" the equation into a text file as a one line equation. 

 

My question: Is it possible to script this process?  I want to save off that formula without having to do the above process every time.  (I already have a script that will run the neural network, etc. just nothing that can save off that single line formula).

 

Thank you for your time!

10 REPLIES 10
showtime287
Level I

Re: Possible to extract Prediction Formula as a one line formula in script?

Interesting, so maybe if I can breakout the formula by "Save Formula" instead of selecting "Save Profile Formulas" then I may be able to piece the entire formula together. 

Recommended Articles