Hello! I am using SQL trying to view the nct_id column that matches 3  criteria and i have 2 tables that share the nct_id. 2 criterias are within the table studies Last criteria is in table interventions. I am not sure how to connect first two criterias to the inner join, do you have any clue? select studies.nct_id from studies where study_type='Interventional' and overall_status='Completed' inner join interventions on studies.nct_id=interventions.nct_id where intervention_type='Drug'; ERROR: syntax error at or near "inner" LINE 20: inner join interventions on studies.nct_id=interventions.n... ^   Many thanks! ... View more

Hello,   I am just starting in Sas and i hope my question is not too dumm, but i would like to ask for some help, I am using Sas university edition.  I have been thinking a lot but i do not find a my mistake.   My final objective is to import several pipe delimited text files that are in a folder to sas. I found this topic: https://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0ctmldxf23ixtn1kqsoh5bsgmg8.htm&docsetVersion=9.4&locale=en   I ran the code, however i did not get to import my files below the error and code Following note:  107 %drive(C:\SASUniversityEdition\myfolders\sasuser.v94\relationaltables201603,txt) NOTE: In a call to the DOPEN routine, the fileref /folders/myfolders/sasuser.v94/relationaltables201603/ exceeds 8 characters, and will be truncated. C:\SASUniversityEdition\myfolders\sasuser.v94\relationaltables201603 cannot be open. 108 109 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 121   %macro drive(dir,ext); %local cnt filrf rc did memcnt name; %let cnt=0; %let filrf=/folders/myfolders/sasuser.v94/relationaltables201603/; %let rc=%sysfunc(filename(filrf,&dir)); %let did=%sysfunc(dopen(&filrf)); %if &did ne 0 %then %do; %let memcnt=%sysfunc(dnum(&did)); %do i=1 %to &memcnt; %let name=%qscan(%qsysfunc(dread(&did,&i)),-1,.); %if %qupcase(%qsysfunc(dread(&did,&i))) ne %qupcase(&name) %then %do; %if %superq(ext) = %superq(&name) %then %do; %let cnt=%eval(&cnt+1); %put %qsysfunc(dread(&did,&i)); PROC IMPORT DATAFILE="&dir\%qsysfunc(dread(&did,&i))" out=dsn&cnt DBMS=DLM OUT=WORK.&OUTFILENAME; DELIMITER="|"; GETNAMES=YES; run; %end; %end; %end; %end; %else %put &dir cannot be open.; %let rc=%sysfunc(dclose(&did)); %mend drive; %drive(C:\SASUniversityEdition\myfolders\sasuser.v94\relationaltables201603,txt)   Therefore i found this topic: https://communities.sas.com/t5/SAS-Procedures/Problem-importing-my-CSV-into-SAS-University-Edition/td-p/139536   and I ran the test and found my files, therefore I am not sure why isnt sas  finding my files. data _null_; infile "/folders/myfolders/sasuser.v94/relationaltables201603/arm_groups.txt" obs=100; input; put _infile_; run;       Does anybody, have a clue of what can i try?   Thaaanks!   ... View more