Good Evening, Please advise what is the best way to remove certain text in a string in dataset.   Example: Assignment was sent to John Smith with the reason and status as Pending Assignment was sent to Peter Smith with the reason and status as Complete.   Output I'm looking for is:  Assignment was sent to John Smith Assignment was sent to Peter Smith I want to remove all the text that appears after the name (John smith, Peter Smith) in the above examples.   Thank you ... View more

Good Evening, I'm trying to extract the sentence from a specific text in a string. For example: the table below has the common word "Retail" and i would like to extract all the values from Retail. Please assist. Thank you in advance.   Input: TEST DATA Retail-Drug name dosage and strength HELLO DATA Retail Store closes at 8pm WELCOME DATA Retail this is the data we needed Good night DATA Retail Store opens at 9AM   Expected Output: Retail-Drug name dosage and strength Retail Store closes at 8pm Retail this is the data we needed Retail Store opens at 9AM ... View more

Good Evening All, please assist in the following scenario as i'm trying to import multiple EXCEL files using proc Import macro and file names begin with "test". Can I apply this wild card test% in the MEND statement so that all the files that begin with test will be imported. Please see example im trying to use   %macro Import_file(VENDORFILE); PROC IMPORT DATAFILE= "File directory location" RUN; %MEND test%;   Thank you all in advance. ... View more

How to select Top 10 records based on the variable in Proc Freq? Thanks in advance I did the order = freq however I’m trying to compare the metrics by Week...when I do the order = freq it gives me in descending but not the weeks in order (week1, week2, week3) etc. also how do I choose the top 10 counts? Please advise. Thank you ... View more

Hello,   I'm trying to extract the data by applying filter between 8AM to 6PM in data set. Time variable is in TIME format. Any suggestions please?   Thanks in advance Cnu ... View more