Hi, I have a variable called "Customer_Comment " (a string) with free text and I need to extract rest of the comment after specific word.   Word word word word word KEYword word word word word word Word word KEYword word word word word Word word word word word Word word word word word word word word KEYword word word word.   The comments are something like above and what I need is to extract all the text after the key word, if the Keyword exists in the comment, so the result would be like below..   word word word word word. word word word word. word word word.   I have tried few functions such as SCAN,FIND,SUBSTR but couldn't get it done, so any help is much appreciated! ... View more

Hi.. I'm relatively new and I'm Trying to extract 60 months data from source tables which names as DATA_YYYYMM and created separate data tables. I wrote the below macro for this.   %MACRO DO_YRMN; %do YY = 2015 %to 2020; %do MM = 01 %to 12; DATA My_DATA_TABLE&YY.&MM /**** my VAR*****/ SET SOURCE_TABLE&YY.&MM; RUN; %END; %END; %MEND DO_YRMN; %DO_YRMN; Macro runs fine. But the issue is zero is not used. So SAS created code as YYYYM only (20191) instead of YYYYMM(201901) ... View more