Prev: Mock ups
Next: ACCESS SQL program into SAS code
From: Ruby on 8 Mar 2010 11:11
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
From: Ya Huang on 9 Mar 2010 12:06
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(a)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
 | 
Pages: 1
Prev: Mock ups
Next: ACCESS SQL program into SAS code