proc import with dbms=xlsx should be able to read and excel with the xlsm extension. However you will need to have SAS/ACCESS Interface to PC Files ... View more

Sorry the layout is somewhat scrambled. What I meant to say is that you can use the SQL statement using exists proc sql; select distinct story from headlines where exists (select 'X' from terms where headlines.story contains kstrip(terms.word) and terms.word in ('indict')) ; quit; or alternatively add a mutual variable to the datasets to prevent the cartesian product. ... View more

proc sql; select distinct story from headlines where exists (select 'X' from terms where headlines.story contains kstrip(terms.word) and terms.word in ('indict')) ; quit; * Alternatively dd mutual variable to prevent cartesian product; data headlines; input key story & $200.; datalines; 1 The president will have to resign for being involved in a political scandal 1 The grand jury has handed down indictments against several mobsters 1 This is another headline ; run; data terms; input key word $20.; datalines; 1 scandal 1 indict 1 abuse ; run; proc sql; select distinct story from headlines inner join terms on headlines.key = terms.key where headlines.story contains kstrip(terms.word) and kstrip(terms.word) in ('indict') ; quit; ... View more

Something like this?   data A; headline = 'How to do this'; output; headline = 'How not to do this'; output; run; data B; term = 'not'; output; term = 'applicable'; output; run; proc sql; select distinct headline from A inner join B on A.headline contains B.term ; quit; ... View more

Hi Cynthia, Thanks for your support, I will contact support for clarification. kr Daan ... View more

Hi Cynthia, I tried to add mm as unit. To my surprise SAS accepted the unit (according to the SAS help n specifies the number of spaces). However the result is more or less the same. Where I used the style attribute in the value of the variable the indentation in RTF is two spaces regardless of the number of spaces defined. The indentation coming from the define statement replaces the number of spaces with a tab with the specified width. I'm on SAS 9.4M6 (LSAF 5.2)  but I also noticed this behavior on PC SAS 9.4M5.   Daan ... View more