converting mulitple disorganized rows and am trying to get into organized rows

converting mulitple disorganized rows and am trying to get into organized rows

Post by aaamad » Fri, 11 Jul 2008 11:26:28


Hi Everyone,
I have a csv file that is in multiple disorganized rows and am
trying to get into organized rows. I can use Excel but it will take
me a long time to keep copying and pasting the rows. Does anyone
know a quick way of converting the following data using SAS? The
first row contains the variable name.

Raw Data is in the following format:
Item PurchaseDate PurchaseTime TagNumber
Hats 01/01/2004
06:06AM 0A105F
06:30AM 4A102N
06:32AM 0B101F
06:36AM 0T108T
Shirts 01/01/2004
07:01AM 0B101M
07:02AM 0A105J
07:25AM 5G630T
07:30AM 5T108T
08:22AM 0A102D
08:36AM 0B101T
08:48AM 0B101F

Need output to be in this format:
Item PurchaseDate PurchaseTime TagNumber
Hat 1/1/2004 06:06AM 0A105F
Hat 1/1/2004 06:30AM 4A102N
Hat 1/1/2004 06:32AM 0B101F
Hat 1/1/2004 06:36AM 0T108T
Shirt 1/1/2004 07:01AM 0B101M
Shirt 1/1/2004 07:02AM 0A105J
Shirt 1/1/2004 07:25AM 5G630T
Shirt 1/1/2004 07:30AM 5T108T
Shirt 1/1/2004 08:22AM 0A102D
Shirt 1/1/2004 08:36AM 0B101T
Shirt 1/1/2004 08:48AM 0B101F

If it's too difficult and time consuming then I understand, but if
anyone knows of a quick way to do it, then I really appreciate your
help.

Thanks.