Missing observations - Proc transpose

[varmac]

Hi all,

The raw data in my dataset is something like:

x variable(character):    y variable(number)    siteid(number)

cohort b                                   40                          1

cohort a                                   50                          2

                                               60                          1

roll_in                                      18                          3

roll_inb                                      5                          4

                                                2                          1

roll_inc                                      5                          1

                                                6            

roll_ind                                      8

When I use the following code, I'm getting a warning message that 26 observations were omitted due to missing id values. Do you have any suggestions on how to correct this?

proc transpose data=tor1 out=tor2;

id x;

by siteid;

var y;

run;

[Ksharp]

You can't do this for the sake of missing value in these variables.

So What output do you need after transposing dataset ?

Ksharp