Desktop productivity for business analysts and programmers

How to create a new column?

Reply
Contributor
Posts: 39

How to create a new column?

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?

Contributor
Posts: 39

How to fo the same effect using add a new computed column?

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.) 5.PNG.

Esteemed Advisor
Esteemed Advisor
Posts: 7,253

Re: How to fo the same effect using add a new computed column?

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.

Ask a Question
Discussion stats
  • 2 replies
  • 114 views
  • 0 likes
  • 2 in conversation