There is an blog article from Yinliang Wu: https://blogs.sas.com/content/sgf/2021/06/25/how-to-evaluate-sas-expression-in-data-step-dynamically/ ... View more

To simulate the screenshot style, try this: proc transpose data=have out=tran; by type notsorted; var month y:; run; %let styles=backgroundcolor=cxedf2f9 font_weight=bold color=cx112277; proc report data=tran style(header column)={just=center}; column ("Type" type) _name_ ("Month" col1-col6); define type /style(column)={&styles.} order order=data ""; define _name_ /style(column)={&styles.} ""; define col1-col6 /""; compute _name_; if _name_="Month" then do; _name_=""; call define(_row_,"style","style={&styles.}"); end; endcomp; run; ... View more

You can use arrays to manually calculate the mode: 1. Calculate the frequency of each variable value; 2. Compare the frequency of each variable value. When the frequency becomes larger, the variable value who have the larger frequency is the mode; data want; set have; array _par_[12]hp_01-hp_12; array _cnt_[12]_temporary_; call missing(of _cnt_[*]); do i=1 to dim(_par_); do j=1 to dim(_par_); _cnt_[i]+(_par_[i]=_par_[j]); end; if frequency<=_cnt_[i] then do; frequency=_cnt_[i]; most_frequent_value=_par_[i]; end; end; run; Since you ask for the latest mode, I use " frequency<=_cnt_[i] " instead of " frequency<_cnt_[i] ". ... View more

Great! But whether the two agenda titles are reversed? ... View more

Yes, SAS 9.4M7 in DMS enviroment. I want to imitate : mouse move; left click; left press and hold;   Even more complex: Get the color of the current position of mouse arrow;   ... View more

Does he/she have access to the Documents folder? ... View more

Code in red doesn't always means error code, it could be wrongly colored by editor. ... View more

Maybe contractor can not read date with format date9., try an international format, like e8601da. ... View more

I remeber Leonid has a post: https://blogs.sas.com/content/sgf/2019/06/26/finding-n-th-instance-of-a-substring-within-a-string/ ... View more

I think my post can help you: https://communities.sas.com/t5/Mathematical-Optimization/Find-numbers-whose-summation-is-specified-using-proc-optmodel/td-p/934230 ... View more

Awesome article.   As for my trick of dealing data, I always use "cats()" function in data cleaning processing, due to two reasons: 1. replace "strip()" function. Although "strip()" is more efficient in removing leading and trailing spaces, I use "cats()" when I don't care about efficiency. Because "cats" is a shorter word than "strip".  2. replace "put()" function to transform number to string. The reason is the length of expression, too, if you count the length of format. ... View more

There is a new way now: use the GIT_DELETE_REPO function(https://go.documentation.sas.com/doc/en/workbenchcdc/v_001/vwblefunctionsref/n05xa2vo2wnzzon1ujsxkgduv1bh.htm) Don't be fuzzy about the "GIT" name, this function can be used to delete local file folders, with or without files in it. ... View more