Hello,  I found an error message when I ran a macro.  Please see the details below.  I won't be able to list the entire messages below.  There are a thousand lines. %let bdate=2022_12_12; proc sql; create table cov&rr as select site, date, id, ageyears, agemonths, source, &regprodate1 from CoV where (&regprodate1>"&bdate."d and &regprodate1 ^= '08aug8888'd) order by site,id; ERROR: Invalid date/time/datetime constant "2022_12_12"d. (covprovdt2>"2022_12_12"d and covprovdt2 ^= '08aug8888'd) NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): I think the date format could not be recognized by SAS.  Do I have to create a new specific one shown below? %let bdate1=12DEC2022; The old one, 'bdate', needs to be used somewhere else.  Could I keep the old one, 'bdate', and make some modifications in the where command? Just curious.   ... View more

Hello, I used two different methods to get two different results in the subgroups. I would like to compare whether these two methods are the same in each group (ATR/FYH/YRU/TRG).  The Method_1 and Method_2 values in the sample dataset could be referred to as any statical value, (mean, sum, etc.) Please guild me to approach it; thanks.   data Sensitivity; infile datalines dsd; input Sub_Group : $10. Method_1 Method_2; datalines; ATR, , 261483.06, FYH, 732878.49, 762531.35, YRU, 323238.54, 49796.91, TRG, 404592.55, 329885.45 ;     ... View more