DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 37

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

I'm trying to understand what the %_eg_whereparam means in the context of trying to create a prompt in SAS EG

 

What does the syntax mean exactly?

For example, a code would be:

Select 
* 
FROM Table t1
WHERE %_eg_whereparam(people.co, Companies, IN, Type=S)

 

I know Type = S means string, but what about the first 2 positions?  Is it table and column?

Also, if I have this %_eg_whereparam, do not need a where statement.

 

For example:

Select
*
From Table t1
where
Companies = 'A'
AND %_eg_whereparam(people.co, companies, IN, Type = S
Super User
Posts: 22,875

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

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.

Ask a Question
Discussion stats
  • 1 reply
  • 148 views
  • 0 likes
  • 2 in conversation