Good point! Thanks Kurt (@Kurt_Bremser)   Bart ... View more

Tom, "%BQUOTE() call so your answer is off by 1." Yes. Should remove the head blanks. Here I just want show an example. %let _NOLOG_pw =%bquote(Abc"2024&sysdate); "Second why use FIND? INDEX works fine " That code is not written by me ,it is from OP , I just use OP's code, since I don't know why OP wrote this. ... View more

One data step, no sorting: Data WANT; declare hash H(dataset:"MyPop_tbl(Keep=CustID)"); H.DefineKey("CustID"); H.DefineDone(); do until(_E_); SET PCS_2211_Y PCS_2210_Y PCS_2209_Y PCS_2208_Y PCS_2207_Y PCS_2206_Y PCS_2205_Y PCS_2204_Y PCS_2203_Y PCS_2202_Y PCS_2201_Y PCS_2112_Y END=_E_ ; if 0=H.check() then output; end; stop; run; Bart ... View more

Your selfless sharing of knowledge is an inspiration to others. Thank you for all you've done for SAS learners. Best wishes! -Rick ... View more

@ballardw wrote: ... Part of the bit around Macros is re-usability and the possibility of ending up in an Autocall library. Which is not conducive to relying on "top to bottom". I would say that is a pretty tight restriction on running code. This thread has wander a long way off topic, but I am not sure I see this point.  Using or not using autocall macros has nothing to do with whether your code should be executed in whole instead of in parts.   ... View more

I think the difficulty with this question is that you've actually created an over-simplified example of what you actually need.  Here, you've got a formula table that you're joining (in a Cartesian way) to your data, but the formula table only, in this example, contains a single formula, so it's not clear how the join would be modified if it contained multiple formulas that would be used conditionally based on, I guess, the data itself.  It would be easier for people to respond if your example formula table contained at least 2 different formulas and that the data step that followed showed us how you would use those formulas.     In any case, I'm guessing you have a programming background that is maybe something other than SAS - nothing wrong with that - just saying that the way you're approaching this is very unusual and probably much more complicated than it needs to be.     With your current example, you could just skip the formula table (and the join) entirely and just run a macro, e.g.: %macro xy; x * y - 1 %mend; data want; set have; calc=%xy; run; ...but again, if you provide a more realistic example, we might be able to give you a better answer. ... View more

This works for me. Giving each statement is the way to go. Thanks a ton yabwon !!! You Rock. I appreciate it. ... View more

You are right! %bquote doesn't serve any purpose here. That's the key point. Thank you again for your help! ... View more

Thank you so much! This works perfectly. ... View more

Brilliant! ... View more

Good to know.  And NLDATENM does not have MONNAME's nasty habit of right aligning the text. data months; do mofy=1 to 12; date=mdy(mofy,1,2024); month=put(date,monname.); month2=put(date,nldatemn.); output; end; format date yymmdd10.; run; proc print ; format _character_ $quote.; run;   Obs mofy date month month2 1 1 2024-01-01 " January" "January" 2 2 2024-02-01 " February" "February" 3 3 2024-03-01 " March" "March" 4 4 2024-04-01 " April" "April" 5 5 2024-05-01 " May" "May" 6 6 2024-06-01 " June" "June" 7 7 2024-07-01 " July" "July" 8 8 2024-08-01 " August" "August" 9 9 2024-09-01 "September" "September" 10 10 2024-10-01 " October" "October" 11 11 2024-11-01 " November" "November" 12 12 2024-12-01 " December" "December" ... View more

Short note about macro functions.   If you are interested in quick creation of bunch of "macro functions" that use %sysfunc "wrapping" you could look at the %generateOneLiners() macro, it's component of the basePlus package. You can run it like: %GenerateOneLiners(prefix=my_ , listOfFunctions=DATETIME TODAY YEAR QTR MONTH WEEK DAY HOUR MINUTE SECOND ) and you can enjoy convenient macro functions like: %put %my_YEAR(%my_TODAY()); %put %my_MONTH(%my_TODAY()); There are some other useful functions in the basePlus too.   And if you are interested in FCMP functions mimicking data struuctures like FIFO queue, LIFO queue, etc. check out the DFA package (documentation)   All the best Bart ... View more

I would go even one step further asking both for SAS Studio and SAS EG.  ... View more

Just an update, I was able to install the suggested hotfix and it did not solve the error with R 4.4. I am still receiving the same message at the top of this thread. R 4.4 is working fine otherwise. ... View more