topic Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1 in SAS Enterprise Guide

Reporting not filtering using a promopt from Stored process under SAS EG 7.1

srihari1 — Thu, 20 Apr 2017 17:36:59 GMT

Hi,

I have created a prompt using the SAS stored process under EG 7.1 - please see the attached prompt window. However, even when i select the Gender = 'M', the report generated from the stored process shows all the records including Gender = 'F'. Can someone see whats going on here.

Please advise.

Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1

TomKari — Thu, 20 Apr 2017 17:45:14 GMT

Very likely you haven't modified that task that uses the filter to exploit it properly. Take a look at that, and try to figure out what you need to do to use the value of your prompt selection...it will be a macro variable.

Tom

Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1

srihari1 — Thu, 20 Apr 2017 18:52:58 GMT

Thanks Tom.

Am looking at the LOG from the Stored process and the macro variable seem to resolve fine - user selects the "M" for Gender. Following is the partial paste from log. Not sure why the report from the Stored process also includes Gender = 'F' along with 'M'.

>>> SAS Macro Variables:

MULTISELECT_GENDER=M

MULTISELECT_GENDER_COUNT=1

Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1

TomKari — Thu, 20 Apr 2017 20:18:12 GMT

Unfortunately, I don't currently have access to an SP environment, so I can't provide a recipe to follow. Someone else will have to pick it up from here.

Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1

Vince_SAS — Fri, 21 Apr 2017 11:48:51 GMT

How is your SAS code using the MULTISELECT_GENDER macro variable? This code should work for the simple case that you show:

proc print data=sashelp.class;
  where (sex eq "&MULTISELECT_GENDER");
run; quit;

Vince DelGobbo

SAS R&D

Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1

srihari1 — Fri, 21 Apr 2017 17:52:42 GMT

Tom, Appreciate for your time.

Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1

srihari1 — Fri, 21 Apr 2017 17:54:30 GMT

Thanks Vince; Now my code works the way it supposed to be.

Re: Reporting not filtering using a promopt from Stored process under SAS EG 7.1

srihari1 — Fri, 21 Apr 2017 17:59:37 GMT

Sorry, missed your question. The MULTISELECT_GENDER is created via the prompt from the Stored Process and then i run your proc print code to make the report work.