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 ... View more

Hi Everyone,   Currently I am working in SAS Enterprise Guide. I'm trying to create a new column from two columns using advanced expression. The idea is this: There is a column named 'Department' and one named 'Project'. If in 'Project' the characters contain 'XYZ', then the value in 'Department' needs to be adjusted to 'ABC'. If, in 'Project' the characters do not contain 'XYZ', we need to keep using the value already present in 'Department'. So basically I'm trying to replace a value in 'Department', based on the values in 'Project'. I'm trying to use FIND within a IF ELSE statement, but so far it's not working. Searches online are not really helping.    Does anyone have a suggestion as to how I can achieve this result? Many thanks! ... View more