Hello Experts,   For unknown reason, my OP was deleted.   I will post my question here again.   if I have a table below:   ID                  text              term 1                  ABCAB             A 1                  ABCAB             B     I want to find the shortest distance between terms within same ID. P.S same ID would have same text   For example: in the first record I have ID=1 text=ABC  term=A , in the second record I have ID=1 text=ABC and term=B I want to compare A with A, and A with B, and B with B for ID=1 the position of first A is 1, the second A has a position of 4 so the distance between A with A is 4-1=3 the position of first A is 1, the first B has a position=2, the second B has a position=5 so the distance between first A with first B is 2-1=1 and the distance between first A with second B is 5-1=4 so shortest distance between A with B is 1 the position of second A is 4, the position of first B is 2 so the distance is 2-4=-2,  the position of second A is 4, the position of second B is 5 so the distance is 5-4=1 etc.   so the final table should look like: ID             term1   term2   shortest distance 1               A           A              1 1                A          B               1 1                B          B              3   ... View more

Hello expert,   I have two SAS transform, one is bulk load and one is table load   I have a SAS source table with column1 that contain blank value.   If I load the table into Oracle then the blank value will be treated as null value in Oracle.   However I want to keep it as blank character rather than null value in oracle.   so I set column1 in Oracle ="cannot be null"     after I have done I run the table loader and bulk load transform in SAS Data Intergration   table loader is working perfectly(blank value from source table has been treated as blank in oracle) but bulk load failed (all the blank values from source table has failed to load into oracle).   I opened both table loader and bulk load code they are below:   column1 is varchar2 in oracle   table loader code: /*Oracle is the  Oracle lib */    data Orcacle.table            (dbnull = (                       CODE_CD = NO             ));       attrib CODE_CD length = $10          format = $10.          informat = $10.          label = 'CODE_CD'; run;    proc append base = oracle.table       data = &etls_lastTable (&etls_tableOptions)  force ;     run;     bulk load code:   Oracle is Oracle lib    data Orcacle.table            (dbnull = (                       CODE_CD = NO             ));       attrib CODE_CD length = $10          format = $10.          informat = $10.          label = 'CODE_CD'; run;    proc append base = oracle.table (&G_BULKLOAD_DELETE_FILES_STMT.    &G_BULKLOAD_DIRECT_PATH_STMT.  BULKLOAD = YES    BL_LOAD_METHOD = replace )       data = &etls_lastTable (&etls_tableOptions)  force ;     run;   the warning message I was getting from bulk load is   WARNING: All or some rows were rejected/discarded!(or possibly there were other errors like Index maintenance errors) ********************************************************************** Please look in SQL*Loader log for the load results. SQL*Loader Log location(only if BL_DELETE_FILES=NO is set): -- /sasdata/data/project/work/DBMS/BL_TR_CO     I realised table loader can handle to problem and want to know why bulk load cannot handle the problem and how to use bulk load to handle the problem.   Thanks ... View more