Try adding this to your code . This will help figure out how many weekdays left available in the month.   format endofmonth date9.; endofmonth=intnx("month",today(),0,"end"); wdleft=intck("weekdays",today(),endofmonth+1,"c"); ... View more

Now to your main question, you can schedule an EG project. This must be done via EG.  I would speak to a system admin at your organization to enable the capability of using windows scheduler. That is what EG uses when you are scheduling a project from within EG. If this gets fixed by the system admin, your problem is solved, and you can schedule your jobs via EG.   If you don't have permission from the system admin to allow the windows scheduler from running on your local machine. The only other alternative i see, is you could - use a third-party scheduler or export the entire EG project into a SAS program and schedule that in the Management console as you suggested in your question.   Before doing down that route be sure to contact your SAS administrator for help. He/she will be able to tell you if the MC has been configured to execute jobs in batch from MC.      ... View more

Not sure if this is what you are looking for ....please take a look. Created an array with do loops to complete. Storing the next highest value in a new column called xhreach1 ...   data have; input ID Base Reach1 Reach3 Reach6 Reach10 Reach15 :BEST12.; array txtcol(5) $7 _temporary_ ("Reach1" "Reach3" "Reach6" "Reach10" "Reach15"); array Reach(5) Reach1 Reach3 Reach6 Reach10 Reach15; array xhReach(5) $7 xhReach1 xhReach3 xhReach6 xhReach10 xhReach15; retain prevalue 0; do j=1 to 5; /* if reach(j) = . then do; found=1 ; end; */ if reach(j) ne . then do; prevalue=reach(j);end; found=0; do i=1 to 5; if reach(i) ne . and prevalue < reach(i) and found ne 1 then do; xhReach(j)=txtcol(i); found=1; end; if i=5 and found=0 then xhReach(j)="N/A"; end; end; cards; 1 5 1 1 1 9 10 2 6 1 1 1 8 9 3 8 1 1 2 7 8 4 4 1 1 1 6 7 5 9 1 3 4 5 6 6 2 1 2 3 4 5 7 1 1 1 2 3 4 8 5 1 1 1 2 3 9 6 1 1 1 1 2 10 10 1 1 1 1 1 11 25 1 2 3 . . 12 2 1 1 2 . . 13 4 1 1 1 . . 14 6 . . . . . ;run; ... View more

It will depend on what system you are using, in both you would need elevated privileges, example sas viya allows you to do this via SAS security but only person that can do that would be the SAS administrator. On SAS 9.4 environment the only way to get something similar would be to have an system administrator set permission on server(operating system) to hide folders from others.   Please contact your SAS Administrators for more information. ... View more

As you didn't include a complete example i have made a test macro below. Here is one method by creating a macro program that calls your history_data macro call with all the values you listed.   options mprint mlogic symbolgen; %macro history_data(yrt=);      %put its working...here is the value &yrmt; %mend;     %macro historycall(value); %let i=1; %do %until(&yrmt=); %let yrmt=%scan(&value,&i); %if &value= %then %put NOTE: Processing complete.; %else %do; %history_data(yrt = &yrmt); %let i=%eval(&i+1); %end; %end; %mend historycall;     %historycall(202007 202006 202004 202009 202010) ... View more

Here is a quick way to get the results you are looking for. data test ; input textstr $31.; newtextstr=substr(textstr,1,length(textstr)-4); newtextstr=substr(newtextstr,7); datalines ; TR_U8_FORTE_BDERT_GT_RPJ GD_FT_LAMAN_TRITE_SRTI_GT_RPJ VB_7P_VELON_SUTI_RPJ ; run; ... View more

For this type of question you might be better off submitting a track with tech support.   https://www.sas.com/en_us/contact/technical-support.geo.html ... View more

Next time please include a data example as i have included.  Seem like the code is working fine. see below also you could get rid of the data step procedure and include this line in your sql . where calculated diagct < 2;  (hint- in-between the from and the group by)     data denomip ; input claimheaderid dxSeqNo icd ; datalines ; 10 3 1 40 1 2 40 1 2 40 2 2 10 1 2 10 3 2 10 2 2 40 1 3 40 3 3 40 2 3 ; run; proc sql; create table diagcount as select claimheaderid, dxSeqNo, count(icd) as diagct from denomip group by claimheaderid, dxSeqno; run; /*less than or equal to 2 dx codes per claimheaderid*/ data diagct; set diagcount; by claimHeaderId; where diagct <=2; run;   ... View more

Hello, we can normally help you with specific answers to questions about the SAS software. For this type of question you will need to ask someone from your organization. Typically you can speak to a SAS administrator that works in your organization to get more details about your installation and how it has been setup to be able to answer the questions you listed.    Hope this helps.   Carmine ... View more

Seems you have an issue with the logic and you dropped the column paramcd, so i have modified code and included below.   data d1 ; input VISIT PARAMCD $3-10 PATHOGEN $11-13 subject $14-16; datalines ; 10 param3 P1 1 40 param1 P2 1 40 param3 P2 1 40 param2 P2 1 10 param1 P2 2 10 param3 P2 2 10 param2 P2 2 40 param1 P3 3 40 param3 P3 3 40 param2 P3 3 ; run; Data param1 param2 param3 ; set d1 ; if paramcd='param1' then output param1 ; if paramcd='param2' then output param2 ; if paramcd='param3' then output param3 ; run ; data d2 ; merge d1 (in=a where= (visit ne . )) param1 (in=param1 ) param2 (in=param2 ) param3 (in=param3 ) ; by subject visit pathogen ; if paramcd='param1' and param1 then do ; paramcd= 'new1' ; output ;end; if paramcd='param2' and param1 then do ; paramcd= 'new2' ; output ;end; Run; ... View more

Hello ,       I would suggest you take the free e-learning Programming 1 course. 😉  Very helpful and last section speaks about joining tables.   https://support.sas.com/edu/schedules.html?crs=PROG1&ctry=CA#s1=3   Also we have lots of free videos that you can use to learn how to join tables and working in CAS too. https://video.sas.com/detail/video/6154951158001/sas-tutorial-%7C-introduction-to-cas-and-coding-in-casl-in-sas-viya?q=joining       ... View more