SQL

GiuseppeC — Fri, 09 Jun 2023 17:03:56 GMT

Dear All,

I would like to make a query on a database that contains two separate columns in which different genetic mutations are indicated.
Therefore I would like to look for two mutations at the same time.
I wrote the following program in SAS:

proc sql;
create table f.gat as
select *
from f.c
where mutation1 in ("G178R", "S549N", "S549R", "S549R (A-> C)", "S549R (T-> G)", "G551D", "G551S", "G1244E", "S1251N "," S1255P "," G1349D ")
or / and
mutation2 in ("G178R", "S549N", "S549R", "S549R (A-> C)", "S549R (T-> G)", "G551D", "G551S", "G1244E", "S1251N" , "S1255P", "G1349D");
run;

in JMP is it possible to write a program that does the same thing that SAS does? Is it possible to replace "in" with "not in" or different?

Thank you

Giuseppe

Re: SQL

frank_wang — Tue, 12 Jul 2022 00:30:47 GMT

JMP can query DB like below:

obj = New SQL Query( Connection( "ODBC:DSN=SampleDSN;" ), Custom SQL( "SELECT c1, c2, c3 FROM my_table;" ) );

Put SQL into 'Custom SQL()'. Details could be serched from script index with key word 'SQL'

topic Re: SQL in Discussions

SQL

Re: SQL