Thank you @@statslikejazz for replying! For exapmple I'm having trouble doing complex IF statements. Ex. I want to create a new column where summarizes that IF (Col Drug is "Atorvastatin" or "Rosuvastatin" and the matching Col Dose is either >40 for Ator or >20 in Rosu) And (Col 2nd Drug is positive) to mark as Yes.
@@RafaelZubirán Great question, and it is definitely doable! Can I get you to copy and paste this question to our community? It is easier to share the answer there. community.jmp.com/ cheers :)
Super Helpful! Often sorting and formatting data is 10X the amount of work compared to running the stats.....Fundamental and very helpful Knowledge
Thank you @Irwin! Data cleaning is always difficult to demonstrate as all have there own data problems. Any typical problem you encounter?
This is super useful for me. Thanks a lot.
And if the If statement is a word? as "Bees Knees"?
Thanks for the question! You can easily use words in your if statements. Did you have anything particular in mind?
Thank you @@statslikejazz for replying! For exapmple I'm having trouble doing complex IF statements. Ex. I want to create a new column where summarizes that IF (Col Drug is "Atorvastatin" or "Rosuvastatin" and the matching Col Dose is either >40 for Ator or >20 in Rosu) And (Col 2nd Drug is positive) to mark as Yes.
@@RafaelZubirán Great question, and it is definitely doable! Can I get you to copy and paste this question to our community?
It is easier to share the answer there.
community.jmp.com/
cheers :)