I think the B. is in the wrong place. Try this: max(B.'Approval_Date'n) as max_date ... View more

If you want to keep all of the observations that are in the table ID. then use LEFT JOIN As to your other question, you could try to add this to your select statement (enclosed in commas) max(B.'Open Date'n) as Max_date ... View more

The data you want still has letters in it--is there a systematic approach to the letters you are trying to keep? The COMPRESS() function has a handy 3rd argument for determining which kinds of characters to keep, but I'm not sure if it applies in this case. https://documentation.sas.com/doc/en/pgmsascdc/v_031/fedsqlref/n01p24mgwawxa2n1hy4gwe5t59xf.htm ... View more

In the example, the data set b_year has two values of "quantity" that are merged with two years (2013 and 2015).Does each b_year data set have values from multiple years or one year? ... View more

Have you considered using the dictionary tables in SAS to assign your table to a macro variable which could then be used in subsequent DATA steps or other procedures. This is a simple example about how to use one of those tables. data test_001; input x y @@; cards; 1 2 3 4 5 6 7 8 9 10 ; run; data test_002; input x y @@; cards; 11 12 13 14 15 16 17 18 19 20 ; run; proc sql; select memname into: dsn from dictionary.tables where substr(memname, 6,3) = '001'; quit; /*You can see that &dsn is now a macro variable for the selected table*/ %put &=dsn; ... View more

I don't see "record" in the CLASS statement. Have you tried running the model with it included? Also, is there a way you can simplify to one RANDOM statement since they are both specifying a random intercept for that variable. ... View more

Welcome to constraints on variable names in SAS. 🙂 If you want variable names that begin with numbers, you need to change the VALIDVARNAME option to ANY However, this means you need to work with variable names as named literals, which is something that SAS EG does more nicely than Display Manager... options validvarname=any; data test; input '1x'n; cards; 1 2 3 ; run; ... View more

that comma after 'a.arm' is likely the culprit. There shouldn't be a comma before the FROM statement. ... View more

What values are you expecting to see in Concat in the other two rows? ... View more

Do you just need a statement like this: where week NE 2; ... View more

You need to use the SAS format that matches the form of the character variable. Something like this: data have; input date $15.; cards; 01/03/2018 02/03/2019 ; run; data want; set have; x = input(date, MMDDYY10.); putlog _all_; run; This site has the information: https://sasexamplecode.com/how-to-easily-convert-a-string-into-a-date-in-sas/ ... View more

you are missing the semicolon at the end of the line with the BY statement. ... View more

Have you tried the reverse=TRUE option in YAXISOPTS? ... View more