No problem.  Many people do not look at the documentation first. ... View more

http://support.sas.com/documentation/cdl/en/statug/63347/HTML/default/viewer.htm#statug_surveyselect_sect007.htm If you specify the SELECTALL option, PROC SURVEYSELECT selects all stratum units when the stratum sample size exceeds the number of units in the stratum. ... View more

Dear Sergio, When using pass thru in the past, I see two things that could be the cause of your error message. The "as a" might be an issue.  Try " epi a".  The other issue may be that there are no rows selected by your where statement.  Try testing with just one of the were conditions. Are the values in "var1" and "date" formatted exactly the same? 104  from epi as a left join blas b on (a.var1 = b.var1) 105  where a.var1 <= date and a.var2 >= date and 105! a.var3>date); ERROR: PROC SQL requires any created table to have at least 1 column This is code that worked for me in the past. "Doris" is the name of the Oracle database that lived in a UNIX environment. proc sql feedback inobs=max outobs=max; drop table dlib.hstclmshdr; connect to oracle (user="&userd." password="&passd." path='mypath' schema=doris preserve_comments buffsize=8000); create table work.claims as select G.* from connection to oracle                           (select d.*                      from doris.inst_claim_header d                      where  (d.line_of_business = 'HST')                        and  (d.claim_thru_date between TO_DATE('01/01/2012','MM/DD/YYYY') and                                                        TO_DATE('12/31/2012','MM/DD/YYYY'))                       ) G ... View more

Dear HMom; Please clarify for me your variable names.  Your example name and the names in your code confused me.  I'm assuming that you want to find out if the value in GenericName is in the variable FormalName. 1654  data have; 1655     length GenericName FormalName Gen_Name $20.; 1656     GenericName = upcase('drugABCD'); 1657     FormalName  = upcase('drugABCDEFG'); 1658     Gen_name    = scan(FormalName,1,' '); 1659  put _all_; 1660  run; GenericName=DRUGABCD FormalName=DRUGABCDEFG Gen_Name=DRUGABCDEFG _ERROR_=0 _N_=1 NOTE: The data set WORK.HAVE has 1 observations and 3 variables. 1679 1680  data temp1; 1681      set have; 1682    x = index(FormalName,(substr(strip(gen_name),1,(length(GenericName))))); 1683  put x; 1684  run; 1 NOTE: There were 1 observations read from the data set WORK.HAVE. NOTE: The data set WORK.TEMP1 has 1 observations and 4 variables. ... View more

Eagles, The to and from locations are not always the same in every function. The only difference I see in our code is the "trim" function and I placed my translate result into a new variable. 9445  data _null; 9446      RSK_SEG_ID = 'ABCD 0101'; 9447   rsk_seg_id_trans = translate(rsk_seg_id,'_',' '); 9448   put rsk_seg_id = rsk_seg_id_trans=; 9449  run; RSK_SEG_ID=ABCD 0101 rsk_seg_id_trans=ABCD_0101 also: 9477 9478 data _null; 9479 RSK_SEG_ID = ' ABCD 0101 '; 9480 rsk_seg_id_trans = translate(rsk_seg_id,'_',' '); 9481 rsk_seg_id_trans2 = translate(trim(left(rsk_seg_id)),'_',' '); 9482 rsk_seg_id_trans3 = translate(' ABCD 0101 ','_',' '); 9483 rsk_seg_id_trans4 = translate(trim(left(' ABCD 0101 ')),'_',' '); 9484 put rsk_seg_id = rsk_seg_id_trans= rsk_seg_id_trans2= rsk_seg_id_trans3= rsk_seg_id_trans4=; 9485 run; RSK_SEG_ID=ABCD 0101 rsk_seg_id_trans=__ABCD_0101__ rsk_seg_id_trans2=ABCD_0101 rsk_seg_id_trans3=__ABCD_0101__ rsk_seg_id_trans4=ABCD_0101 Message was edited by: James Willis. I added spaces before and after and I added the trim(left()) functions. ... View more