I have a left join that is working like a normal join Proc sql; Create table have as (Select A.dny, A.type, A.orderdste, B.type, B.delivery, B.dny From table a left join table b on a.dny=b.dny Where a.orderdste =b.delivery ); Run; The output it should bring everything from table a I'm looking for all the dny in table a that are not in table b ... ... View more

Hi I have a table with a comment box I need to extract key words from comment box Theft. Or Storm The data looks like this Id. Comment 1A. GL THE BOAT STORM 2A. SUNSHINE 3A. STORM IN THE CITY 4A. THEFT. IN THE JUNGLE 5A. RAINY DAY 6A. THEFT Output Id. Comment. Output 1A. GL THE BOAT STORM. Storm 2A. SUNSHINE 3A. STORM IN THE CITY. Storm 4A. THEFT. IN THE JUNGLE. Theft 5A. RAINY DAY 6A. THEFT. Theft ... View more

Hi I have 2 tables table a and table b I want everything coming from table a An only where we match table b. From table. A left join table b on a.tid =b.tid and a.date = b.date Table a has 7500 records table b has 100k records when I run it i get 7200 records ... I don't know why it's dropping 300 records ....thanks ... View more

Hi I have a data set looks like this Date Tracking. Col1 col2 col3 col4 col5 col6.col7 col8 01/01/16 2z. $$ bag. Atm. { BAG. STM $$ { I need to remove the cold where the symbols $$ or { exist and just keep where bag and atm exist. ... View more

Hi I have 2 tables 3 columns I want to join them and show my output where text they don't match each tables the 1st table look like this Table1 ID. Date. .. Text AZ. 01/01/16. AZ 01/01/16 TX. 02/02/16. TX. 02/02/16 The second. table ID. Date. Text AZ. 01/01/16. AZ 01/01/16 TX. 02/02/16. TX 02/0216 THE OUTPUT I'D. DATE. TEXT TX. 02/0216 ... View more