Desktop productivity for business analysts and programmers

Filter on computed column

Accepted Solution Solved
Reply
Contributor
Posts: 30
Accepted Solution

Filter on computed column

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.

Attachment

Accepted Solutions
Solution
‎05-08-2017 03:51 AM
Trusted Advisor
Posts: 1,056

Re: Filter on computed column

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

View solution in original post


All Replies
Esteemed Advisor
Posts: 5,198

Re: Filter on computed column

If I recall right you should be able to do that on the filter tab, which would result in a having clause.
Data never sleeps
Solution
‎05-08-2017 03:51 AM
Trusted Advisor
Posts: 1,056

Re: Filter on computed column

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

Contributor
Posts: 30

Re: Filter on computed column

Works perfectly. thanks guys Smiley Happy

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 132 views
  • 2 likes
  • 3 in conversation