topic Re: Categorizing data in New SAS User

Categorizing data

Ishor — Mon, 27 Feb 2023 20:03:21 GMT

I have following data.

Age Zone

20 FN

21 CN

22 FN

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

Re: Categorizing data

PaigeMiller — Mon, 27 Feb 2023 20:07:45 GMT

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.

Re: Categorizing data

Reeza — Mon, 27 Feb 2023 20:16:00 GMT

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

Re: Categorizing data

ballardw — Mon, 27 Feb 2023 20:36:05 GMT

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.