Hi, I have two simple  tables, A and B Table A looks like this: ID name Comment 123 Toyota Good 111 Nissan Good 124 Range Rover Best Table B looks like this ID name Comment Status 123 Toyota Good Sold 111 Nissan Good Available 171 Ford Excellent Sold I want a SAS SQL programme  to look at table B and report status for each vehicle  on table A( availability column)  according to ID as follows, and return N/a when there is no ID match as follows. ID name comment Availability 123 Toyota Good Sold 111 Nissan Good Available 124 Range Rover Best N/a ... View more

Hi, I have two tables, A and B. I want to create a variable on Table A( TableB ID?) that scans iDS on table B and returns the ID if a similar one is found or puts Na, when none is available. Example. Table A ID       fruit                     colour           TableB ID? 165     avocado             orange         Na 111    orange                 orange        111 111    cabbage             green            111 123     mango                 green            Na 333    strawberry             red                333 333    strawberry             red                333 555      berry                   orange          Na Table B ID    fruit                 colour               555  avocado         Orange            111  orange            Orange           178  cabbage         green             236   mango            green              333  strawberry       red                  333  strawberry       red                   148  berry                 orange                Thanks. Message was edited by: zetter rweza I have edited the table to make things clear/ I just want to look at ID don't mind about fruit type or colour, please help. ... View more

Hi I’ve got a table like this ID       fruit                     colour 555     avocado             orange 111    orange                 orange 111    cabbage             green 123     mango                 green 333    strawberry             red 333    strawberry             red 555      berry                     orange I want sas to look at all of the IDS above and flag if similar ID exist, like this: ID    fruit                 colour               duplicate? 555  avocado         Orange            No 111  orange            Orange             No 111  cabbage         green             Yes 123   mango            green               No 333  strawberry       red                   No 333  strawberry       red                   Yes 555  berry                 orange              Yes   Thanks. ... View more