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

[srihari1]

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.

[TomKari]

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

[srihari1]

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

[TomKari]

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.

[srihari1]

Tom, Appreciate for your time.

[Vince_SAS · Accepted solution]

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

[srihari1]

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

[srihari1]

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.