03-16-2018 07:22 PM
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.
Select * From Table t1 where Companies = 'A' AND %_eg_whereparam(people.co, companies, IN, Type = S
03-16-2018 09:48 PM
This is a good resource. The link to the paper is at the end if you're not a fan of videos.