Hello!  Finding proc report syntax to be a bit tricky. I am attempting to count a variable (below - I am attempting to count the caseid variable so that I have the number of cases in each employee's queue) and add it to the summary line. I couldn't come up with a way to just display the count of the caseid variable in the summary line without also creating a column for it. The summary line also the includes the count of the days variable, which I do not need and would prefer to exclude. Is there a better way to be doing this?    This is my current code:    proc report nowd data=test; column employee caseid n days ; define employee/ group ; define n / "count"; break after caseid / summarize Ol UL; rbreak after /summarize; run;    This is the current output:  Employee  CaseID Count Days Michael Smith  1234-55   5   1256-99   7 Michael Smith    2 12 Jane Doe   7890-10   1   2233-55   2   6789-12   4 Jane Doe    3 7   I was hoping more for this - days is not including in the summary line and ideally (though not as crucial) count of cases would be hidden as a column.  Employee  CaseID Days Michael Smith  1234-55 5   1256-99 7 Michael Smith  2   Jane Doe   7890-10 1   2233-55 2   6789-12 7 Jane Doe  3   ... View more

Hello - trying to compare the substr function to a perl reg expressions for searching for a string pattern across multiple variables. For whatever reason it seems like the array is only searching across one of the fields and then stopping but it works when using substr function. Is there additional syntax that needs to be added for this to work? The example below is simple, so it's fine to use SUBTR but there are cases where Perl Reg Expressions can really reduce the amount of logic.    Note: &dx_field refers to a list of 26 variables   First Array - using SUBSTR searches across all variables (This works!):  ARRAY TEST {*} $ &DX_FIELD; DO i=lbound(TEST) TO hbound(TEST); IF (substr(TEST{i},1,3) = ("J11")) then flu=1 ; END;   Second Array - uses Perl Reg Expression -  only produces a match when the first variable within &dx_field matches:  ARRAY TEST2 {*} $ &dx_field; DO i=lbound(TEST2) TO hbound(TEST2); IF PRXMATCH("/(J11)/",TEST2[i]) THEN FLU2 =1 ; LEAVE; END;   ... View more

I have a date variable and I want to be able to calculate its corresponding week start date. Example:   Have:   Date 1/5/2020 1/6/2020 1/7/2020 1/12/2020 1/21/2020 1/23/2020   Want: Date:              Week Start Date:  1/5/2020         1/5/2020 1/6/2020         1/5/2020 1/7/2020         1/5/2020 1/13/2020       1/12/2020 1/21/2020       1/19/2020 1/23/2020        1/19/2020 ... View more