Categorizing data

[Ishor]

 I have following data.

Age   Zone

20    FN

21    CN

22    FN

20     CN

20   CN

and so on

I need following.

                 Age

Zone   20   21   22   23

FN      1      0    1      0 

CN      2      1    0      0

Thanks in Advance

[PaigeMiller]

Normally, turning a long data set into a wide data set is not a good practice. I would recommend you leave your data set in the long format for most purposes, as almost all SAS PROCs are designed to work on the long data set.

So, why do you want a wide data set? Please explain clearly 

If you want an output report in the wide format, then please state that clearly; again a long data set can be used to create a wide report.

[Reeza]

proc tabulate data=have;
class age zone;
table zone, age*N;
run;

---

@Ishor wrote:

 I have following data.

Age   Zone

20    FN

21    CN

22    FN

20     CN

20   CN

and so on

I need following.

                 Age

Zone   20   21   22   23

FN      1      0    1      0 

CN      2      1    0      0

Thanks in Advance

---

[ballardw]

You should state whether your "need" is for a data set for further manipulation or a report that people will read. The "need" that you show is generally a poor form for most forms of manipulation further.