Is there a way to combine these 3 PROC SQL code blocks into 1 PROC SQL code block? The only 2 parts of the SQL code that change are the name of the count(x) variable and the date range used in the where statement. PROC SQL; CREATE TABLE comp_date_range AS SELECT company, count(x) as ee_quarter20_count from company_data where doi between '01Aug2020'd and today() group by company ; run;quit;   PROC SQL; CREATE TABLE comp_date_range1 AS SELECT company, count(x) as ee_quarter19_count from company_data where doi between '01Aug2019'd and intnx('year',today(),-1,'same') group by company ; run;quit;   PROC SQL; CREATE TABLE comp_date_range2 AS SELECT company, count(x) as ee_ytd_count from company_data where doi between '01Jan2020'd and today() group by company ; run;quit;   Thank you.   ... View more

Does anyone know how to setup one prxparse expression to capture the following 5 pieces of text? What comes before or after the 5 pieces of text shown below can be anything. 1) Level space 1,2,3 (e.g. Level 1) 2) Level hyphen space 1,2,3 (e.g. Level- 2) 3) Level space hyphen space 1,2,3 (e.g. Level - 3) 4) Level hyphen 1,2,3 (e.g. Level-1) 5) Level space parenthesis around 1,2,3 (e.g. Level (2)) Thank you.   ... View more

How would I go about extracting all words from a text field that start with "SM" where the 2 letters "SM" are uppercase? All words that begin with "SM" would be copied into a new column where each word that begins with "SM" for that specific record would be separated by a space or comma. For example, for record 100 the text is "SM690 and SM780 occurred at 1:00pm". The newly created column would show "SM690 SM780" or "SM690,SM780". Thank you. ... View more

Hi, How would I modify this code to only select column names that begin with "CDD_"? proc sql; select name into :charlist separated by ' ' from dictionary.columns where UPCASE(LIBNAME)="WORK" and upcase(memname)="ECM"; quit; Thank you.   ... View more

How would I create a regular expression using prxparse that always starts with x1, ends with y2 and the middle part can be any length (1+) and any characters? For example, I want: x1abc_efy2 x12y2 x1a!y2   I don't want: x2abcy2 x1zy3   Thank you.   ... View more

I have a macro that takes two values (both are text): pattern and serial. I have a data set with these two variables (i.e. patterns). How would I go about reading in, for example, the first 20 rows, then the next 20 rows, etc. Each time a group of records is inputted the results would be stored or outputted where check equals 1 or 2. The data that I am applying this macro to is in a separate data set (i.e. all_data).   %macro prx(pattern,serial); b=prxparse("&pattern"); if prxmatch(b,serial_number)>0 then do; check=1; serial=&serial; if (length(serial) = length(serial_number)) then check=2; end; %mend;   Example values and how they would fit into the macro: pattern=066957 serial=0669578 %prx(/^066957[\d{1}]/,"0669578");   Here's an example of the records that I would like to feed into the macro (only 2 columns): Serial        Pattern B266056   B26605 00308110  0030811   Thank you. ... View more