Computed column in SAS EG

Margot89 — Mon, 28 Sep 2020 12:26:38 GMT

Hi Everyone,

I'm working on a SAS EG querybuilder, and i'm trying to make a new computed column. This one needs to find certain letters in an existing column. Accordingly, in the new column, it's supposed to show certain words, based on which letter was found. In the original column (let's call it Column A) there is a string of one letter, followed by a bunch of numbers. For example: C.0974893938. There can be four different letters at the beginning of this code. L & S mean it's a project, C is for capacity and P is for pricing. Right now, this is my code:

case when find(t1.'Column A'n, 'C') then 'Capacity' or find(t1.'Column A'n, 'P') then 'Pricing' else 'Project' end

I have never tried 'then' twice in one code (and it appears to not be working), but I don't really know any other way to solve this one. Can you help me? Many thanks!

Best,

Margot

Re: Computed column in SAS EG

Kurt_Bremser — Mon, 28 Sep 2020 12:44:16 GMT

case 
  when find(t1.'Column A'n, 'C') then 'Capacity' 
  when find(t1.'Column A'n, 'P') then 'Pricing'
  else 'Project'
end

each THEN needs a WHEN.

Re: Computed column in SAS EG

Margot89 — Mon, 28 Sep 2020 15:22:49 GMT

Thank you, this worked wonderfully!

topic Re: Computed column in SAS EG in SAS Enterprise Guide

Computed column in SAS EG

Re: Computed column in SAS EG

Re: Computed column in SAS EG