Filter on computed column

[adil256]

Hi everyone,

I diidn't find the answer I'm looking for through the forum. I would like to count the number of contracts per  contract and isolate only contracts with duplicates.  I know how to do it in 2 steps with sas eg but I would to do in one step. when i want to filter the observations on the computed column it's just not possible i can't drag it. Here is a picture.

thank you.

[LinusH]

If I recall right you should be able to do that on the filter tab, which would result in a having clause.

[TomKari · Accepted solution]

@LinusH is correct. Here's a reference to a blog post by Chris that describes how to do it.

Tom

http://blogs.sas.com/content/sasdummy/2012/09/18/having-clause-fun-with-sas-enterprise-guide/

[adil256]

Works perfectly. thanks guys 🙂