About Martin_Bryant

Martin_Bryant · ‎03-26-2024

Hi, Many thanks for this. I'll look into Stored Procs as I have never used them in SAS, only SQL. As for the scheduler, we already use that but it has the limitation that we can't use libraries that require a login as the scheduler runs without a client. Very helpful though. 🙂

Martin_Bryant · ‎03-15-2024

Excellent, yes. As demonstrated here. Solved: Macro within a macro - SAS Support Communities Many thanks.

Martin_Bryant · ‎03-15-2024

I have several programs embedded with my SAS EG project. One of these programs exists to control the others. If I save the other programs externally as .SAS files, then I can call them with %include, but is there a way to call embedded programs in a similar way?

Martin_Bryant · ‎03-14-2024

Ah, my mistake. Never done C#. I will certainly take a look at this. Thanks again.

Martin_Bryant · ‎03-13-2024

Custom tasks look interesting. Not used them before. The problem here is that I suspect our SysAdmin won't let me write C++ code and the last time I wrote C++ was probably 30 years ago. Never really mastered OO languages. I'm a Functional Language man. 🙂

Martin_Bryant · ‎03-13-2024

We are on SAS EG 7.12. Yes, paths from the server. Thanks, I am familiar with the location as per the program properties, I just haven't used this path when referencing code.

Martin_Bryant · ‎03-13-2024

Many thanks. All of our files are stored on the server and we only get relative names, so I'm not sure that this will work for us, but it looks very useful if I can work out how to access our paths. Many thanks. We aren't allowed to store files externally to the server. Sigh.

Martin_Bryant · ‎03-13-2024

Thanks. I had a nasty feeling that would be the case. OK. I'll start making a macro... 😞 Martin

Martin_Bryant · ‎03-13-2024

Well, I'm hoping that the call to run this multiple times can still be within SAS EG code and therefore I can use prompts to guide this. At worst I can have a SAS EG project to write the values to a data table that the main code can read and use to control the loop. My question all hangs on the mechanics of how to code the loop. I am am pretty sure that I can do it with a macro but it wouldn't be a very tidy solution. I just don't think that macros are a very tidy solution to anything though. In fact I am really not very impressed with the majority of the SAS language. Is it possible to get one SAS EG project to call another?

Martin_Bryant · ‎03-12-2024

Hi, I have a large SAS EG project containing programs and reports that needs to be run multiple times, each time with a different parameter value. Currently it is a project with a date prompt. I need to run this multiple times (and regularly) with different dates. Sticking everything into a macro would be a lot of work and messy. Is there a way to either... Call a project with the prompt value in a script? Call put all of the programs and reports in a single program? (Then I can use a macro around a %include) Anything else that will solve this tidily? I will probably have to apply the solution to multiple projects so I'd like to do it right first time. Happy to answer questions. Thanks.

Martin_Bryant · ‎07-19-2022

@Reeza and that's my point. According to the code that is linked here, there are more options that that. This is the macro header... /* Build where clauses from stored process parameters */ %macro _eg_WhereParam( COLUMN, PARM, OPERATOR, TYPE=S, MATCHALL=_ALL_VALUES_, MATCHALL_CLAUSE=1, MAX= , IS_EXPLICIT=0, MATCH_CASE=1); But these aren't explained anywhere and the code itself isn't commented so you have to really understand macros well in order to understand it. Anyway hope this discussion helps others understand %_eg_whereparam better.

Martin_Bryant · ‎07-19-2022

Yes. I've looked it over and got what I need, but I don't claim to fully understand it at all.

Martin_Bryant · ‎07-18-2022

I've worked out a solution that whilst not entirely generic, I think is best one. My prompt is CountryPrompt and by default nothing is selected. If the user leaves it this way, they I'm going to assume they want all countries. Too many to have selected initially and the most likely scenario is that the user wants just one, so this is the best solution for them. One is then easy to select. So my where clause is now... where .... and ( %_eg_WhereParam(Cust_Country, CountryPrompt, IN, TYPE=S) or &CountryPrompt_count. = 0) This works because the prompt is from a static list and whilst CountryPrompt remains undefined, CountryPrompt_count doesn't. It also saves faffing around with all of the macro stuff.

Martin_Bryant · ‎07-18-2022

Re: please explain %_eg_whereparam(....) for me. Posted 03-16-2018 09:48 PM (5494 views) | In reply to mrdlau https://blogs.sas.com/content/sastraining/2012/03/14/three_examples_of_egwherepara/ This is a good resource. The link to the paper is at the end if you're not a fan of videos. Unfortunately, the videos appear to have been removed.

Martin_Bryant · ‎07-18-2022

@Tom wrote: The macro just emit a string of characters that look like a condition expression. So to play around with it just use it in a %PUT statement. %let mvar=XXX; %put %_eg_WhereParam( varname, mvar, EQ, TYPE=S ); Results varname EQ "XXX" I'm sorry, but this doesn't help me understand which parameters I can add to the call though, does it? I need something to tell me what options I can pass and with which values and what those values mean. Maybe %_eg_WhereParam( varname, mvar, EQ, TYPE=S, JONNY=FISH ); is a valid option, but I'll never know unless I'm told somewhere.

Online Status	Offline
Date Last Visited	‎04-04-2024 09:43 AM

Re: What is the best way to call a group of programs and reports repea...

Re: How to call one embedded program from another in SAS EG

How to call one embedded program from another in SAS EG

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

What is the best way to call a group of programs and reports repeatedl...

Re: What is the best way to call a group of programs and reports repea...

Re: Where is the documentation for _eg_WhereParam

Re: please explain %_eg_whereparam(....) for me.

Re: please explain %_eg_whereparam(....) for me.

Re: How can I Find Code that opens a given dataset?

Allow the option for programs to automatically be embedded in projects

Re: What is the best way to call a group of programs and reports repea...

Re: How to call one embedded program from another in SAS EG

How to call one embedded program from another in SAS EG

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

Re: What is the best way to call a group of programs and reports repea...

What is the best way to call a group of programs and reports repeatedl...

Re: please explain %_eg_whereparam(....) for me.

Re: please explain %_eg_whereparam(....) for me.

Re: Where is the documentation for _eg_WhereParam

Re: please explain %_eg_whereparam(....) for me.

Re: please explain %_eg_whereparam(....) for me.