How to create a new column?

[karen8169]

I want to create a nwe column following the rules.

1. Under the same COUN, VILL and HOUSE, if the age in the P1_5 is the smallest and in P1_4 is male, we set 1.
2. Under the same COUN, VILL and HOUSE, if the age in the P1_5 is the smallest and in P1_4 is female, we set 0.
3. Under the same COUN, VILL and HOUSE, if the age in the P1_5 is the smallest and in P1_4 are twins (both male and female) , we set 3.

How to get the result by using Add A New Computed Column?

[karen8169]

I want to create a new cloumn to do the same effect. Under the same COUN, VILL and HOUS, I can calculate the mount of male and female in P1_4 using Add A New Computed column.  The picture I attached is made by summary tables (that's the effect I want.) .

[RW9]

Post test data in the form of a datastep!!

Look at the guidance found when entering a new post.  Show your test data clearly as as datastep - attachments are not recommended as they are a security risk.  Then present your logic between the two.  From the given output it looks like you want a proc report output for this not a dataset, so you can use across variables in the proc report:

http://www2.sas.com/proceedings/forum2008/265-2008.pdf

Although as you have not followed the guidance I am just guessing here.