Date:         Tue, 9 Mar 2010 12:06:18 -0500
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: How to code my question?
Comments: To: windofoct@GMAIL.COM

You said you can transpose the dataset to get the desired structure,
that seem to match your "final" dataset too. So what is exactly you
want, if you already know how to do it?

On Mon, 8 Mar 2010 08:11:59 -0800, Ruby <windofoct@GMAIL.COM> wrote:

>Hi SAS experts,
>
>I have one survey dataset. I would like to create a variable to mark
>each answer options within each survey question. The value for the new
>created variable will show as "A", "B", "C" and so on. Then, I can
>transpose the dataset to get the desired data structure. So, can you
>help me coding this question? Thanks very much!
>
>ID   Name
>1   A
>1   B
>1   C
>2   A
>2   B
>3   A
>3   B
>3   C
>3   D
>
>/** final dataset ***/
>ID   _1A _1B _1C _2A _2B _3A _3B _3C _3D