Hi, I'm extracting information from a string based on keywords that are pre-defined by regex patterns. My question is how do I get 4 words before and after the keywords, and save them into two separate columns? BIG thanks!   Let's say the regex pattern is defined as:  patternID = prxparse('/a \w+ fruit/i');      ... View more

Hi, I'm doing conditional datasets output within a SAS macro:   I already had work.other dataset.   %macro m(w); data dat1 dat2;  set other; w = &w.; if diff le &w. then output dat1;  else output dat2; run; %mend;   It works when I run without the "%macro" But, when I call the macro by doing "%m(1);", I got an error saying something wrong with the "set":   Statement is not valid or it is used out of proper order.   Thoughts? Thanks! ... View more

Hi, I'm having a question regarding how to enumerate unique date by group - id, see below:   id.       date           rank 123.   20190101.    1 123.   20190101.    1 123.   20190102.    2  123    20190102.    2   how do I get the rank column?  ... View more