Help using Base SAS procedures

Missing observations - Proc transpose

Reply
Occasional Contributor
Posts: 5

Missing observations - Proc transpose

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;

Super User
Posts: 10,044

Re: Missing observations - Proc transpose

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

So What output do you need after transposing dataset ?

Ksharp

Ask a Question
Discussion stats
  • 1 reply
  • 194 views
  • 0 likes
  • 2 in conversation