Hi, I am a SAS beginner that has just started with EG 4.2, so feeling my way around. I have a table of data where the are multiple columns and I would like to count the number of non blank columns in each row and store the count into a new calculated column. So my outcome should looks like this; ID Co1 Col2 Col3 Col4 New Column: Count of Non Blanks 1001 X X 2 1002 X 1234 abc 3 1003 X 1 I've not been able to find any guidance on how to do this type of counting using EG query builder so if anyone could help that would be fab! JW
... View more