topic Re: How to fo the same effect using add a new computed column? in SAS Enterprise Guide

How to create a new column?

karen8169 — Fri, 26 May 2017 06:41:23 GMT

I want to create a nwe column following the rules.

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.
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.
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?

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

karen8169 — Fri, 26 May 2017 06:22:15 GMT

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

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

RW9 — Fri, 26 May 2017 08:06:43 GMT

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.