Computed column in SAS EG

[Margot89]

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

[Kurt_Bremser · Accepted solution]

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.

[Margot89]

Thank you, this worked wonderfully!