A few years back, I had to automate the download of attachments from certain emails for a data processing project. Like you, I started with VB code and a rule in Outlook. It worked fine for a while but sometimes skipped emails or didn’t trigger reliably, which was super frustrating.What saved me was looking into Outlook add ins. I found one that handled attachments more effectively—it could automatically download and even rename files based on email content. This freed me from worrying about Outlook’s rules acting up. Once I integrated it with my scripts, everything flowed smoothly. ... View more

In general you want to clearly define what you want. Your "working day" may not be my working day. I know organizations that consider weekends working days but not Monday. My dentist doesn't work on Friday. At least one company I worked for that normally worked on Sundays didn't on Super Bowl Sunday, and another closed for the first week of deer hunting season.   An example for one date does not provide a general rule that could be applied to all months without such details.   Additionally, your pseudo-code is not using order of operations correctly. data _null_; drr = 130 - 76/9; put drr=; run; shows Drr= 121.55555556 (approximately). So your Drr calculation is drr = ( 130 - 76)/9;   ... View more

The error was in my flow. I started the flow with a time-event (wait for 01:00 = the same time the flow was scheduled to run) and that's where it stopped.   Now my biggest problem is that I can't find the embarrassed-emoji... ... View more

To schedule EG projects in SMC you first need to export your projects to SAS programs. These can then be scheduled in SMC via Schedule Manager. I suggest you reach out to your SAS administrator regarding the scheduling setup for your SAS installation.  ... View more

There is no "Files" under "Libraries". Files and Libraries are both parts of the navigation tree for a given server, on the same hierarchy level. Libraries can be hidden by making the physical directory non-readable and non-accessible on the OS level, and/or by making them metadata-bound and setting the permissions in metadata. Folders in Files (file system directories) can not be hidden, only their content. Their names will always show up if a user has read permission for the parent directory. ... View more

Thank you for all your responses !   I tried, according to my knowledge (meaning if for me something doesnt work it is maybe my fault), all the solutions according to my data.   A few key points : -proc transpose on a 800k table doesnt work ; the proc seems ok, but when i try to open the table, infinite lag   -I specified (perhaps not enough) in my original message that the x of the Reachx can be another column (eg Reachx = Base*1.05, meaning there is Base, Reachx AND the colomn with the wanted number of row) ; in that way I cannot make the 2 proposed solutions from @mkeintz (I dont know how to tag) work with a variable column as Reachx (which change each row, see eg above)   -The solution from @Ksharp work with a variable column, but it is unpractipable for a large table like mine ; for 30k rows it took 30sec, for 50k 1m30sec. To keep the continuity of the table it is probably possible tu cut the table into pieces and to make an overlap reconstruction happend after this solution for each cut, but it is not my priority now. But it is good to know ! I am very happy that at least one solution kinda work for me.   I hope this will help others for future similar questions.   I will accept the @Ksharp answer soon.   Thank you 🙂   ... View more

Also for future issues in Model Manager, the Decisioning Community might be better suited to help you: https://communities.sas.com/t5/Decisioning/bd-p/decisioning ... View more

Thank you so much team for your kind help. ... View more

@Toni2 wrote: There are times that EG is slow and takes more time to complete an action and others less.  In this case, look at the logs of the codes you submitted. You may simply have heavier server load at some times. ... View more

@ballardw This worked. Thanks. Also changed the output var name.   ... View more

Your SQL is counting by ID AND Dxseqno. That does not match your description of counting the number of diagnoses. Does the SQL give what you expect?   My guess is that you may not want the Dxseqno in that counting as you will get separate count for ID=1 and DXseqno=1, Id=1 and Dxseqno=2, Id=1 and Dxseqno=3. If there exactly 3 observations for Id=1 that look like that list and you expect a count to be 3 then you want to remove Dxseqno from the Group by  and the Select.     Provide some example data and expected result for that small sample. ... View more

Probably you can take a look at this new solution, have similar effects like DDE (i.e. inject values to any cell of choice in an Excel/ Word/ PowerPoint template), which works well for cloud/citrix server environment. One-Click Report Automation - An automated and user friendly workflow for efficient, flexible, and extendable analysis and reporting (sas.com) ... View more