I'm very new to SAS - switched jobs to a place that uses SAS enterprise - and have been doing readying a lot of SAS literature on forums and got some books already, but i can't seem to figure this out! Please help! essentially I need the equivalent of a Vlookup and all the syntax before and after the statement I have Table_A (Table in SAS) and Table_B (external table in excel). Table_A has 150,000 rows, while Table_B has 10 rows. I'm trying to write an if-then clause that: IF Table_A.column1 [has one of the variables in] Table_B.column1 THEN write 'TRUE' [in Table_B.column2] After that, I would probably sort and take NOT MISSING from Table_B.column2 to cut the table down to a more manageable size. Apologies if this is too simple, but I can't find anything that works! Any suggestions of what PROC or what not would greatly be appreciated. Thanks, Larry.
... View more