topic Re: Turning Columns into rows in SAS Programming

Turning Columns into rows

ciccotelli412 — Tue, 05 Sep 2017 12:35:03 GMT

Hey Everyone,

Hope this can be a quick answer

I have a dataset that appears as followed:

HSHLD_NO PLU1 PLU2 PLU3 PLU4 PLU5

00000 234 345 456 567 678

I want it to appear as this:

HSHLD_NO PLU

00000 234

00000 345

00000 456

00000 567

00000 678

How do I go about doing this?

Also, once it is formatted like this, how would I go about removing any duplicate entries?

For example:

HSHLD_NO PLU

00000 234

00000 345

00000 456

00000 234

00000 567

00000 678

How would I remove one of the two entries that has HSHLD_NO = 00000 and PLU = 234

Thank you in advance

Re: Turning Columns into rows

JBailey — Tue, 05 Sep 2017 13:18:38 GMT

Hi @ciccotelli412

Take a look at PROC TRANSPOSE.

Here is the link to the doc...

http://support.sas.com/documentation/cdl/en/proc/70377/HTML/default/viewer.htm#p1n9l1b2dg00w9n1h3tovj0rwlos.htm

Best wishes,
Jeff