topic Re: Filter on computed column in SAS Enterprise Guide

Filter on computed column

adil256 — Fri, 05 May 2017 15:02:00 GMT

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.

Re: Filter on computed column

LinusH — Fri, 05 May 2017 15:53:52 GMT

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

Re: Filter on computed column

TomKari — Fri, 05 May 2017 15:57:08 GMT

@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/

Re: Filter on computed column

adil256 — Mon, 08 May 2017 07:52:22 GMT

Works perfectly. thanks guys 🙂