10-02-2013 06:24 AM
Hello . I'm new to SAS EG. I have an issue that intuitively feels that it should be really easy to resolve in SAS EG, but for the life of me I can't find the solution/function to make it work. I'm sure I'll be embarrassed by the answer.
How can I calculate the columns "Count of A", "Count of B" and "Count of null"? The N function only seems to work with number formats and the Count function only seems to work within one column - but I'm happy to be corrected.
Incidentally in real life there could be upwards of 30 columns to check.
|CustomerID||Product||2011_01||2011_02||2011_03||2011_04||2011_05||2011_06||Count of A||Count of B||Count of null|
Thanks in advance for any tips.
10-02-2013 07:33 AM
Does the following help?:
length var1-var6 $ 1;
count_of_a =count(cat(of var1-var6),'A');
count_of_b =count(cat(of var1-var6),'B');
10-02-2013 08:14 AM
I don't know! I was hoping I could do this simply in a computed column, for example. I don't have any experience of inputting code in SAS EG.
10-05-2013 11:52 AM
The easiest way to do this is a little roundabout; the advantage is that you won't need to worry about how many date columns you have.
Give this a try, and let us know what you think.
Step 1: Transpose the data
Run the task. You should see a result with just three columns, but the date columns have been converted to rows. Now any of the SAS analysis tools will work. Here's an example:
Step 2: Produce the table
Run the task. You should see something like this: