Missing observations - Proc transpose

varmac — Thu, 03 May 2012 19:56:02 GMT

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

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;

Re: Missing observations - Proc transpose

Ksharp — Fri, 04 May 2012 02:27:47 GMT

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

So What output do you need after transposing dataset ?

Ksharp

topic Re: Missing observations - Proc transpose in SAS Procedures

Missing observations - Proc transpose

Re: Missing observations - Proc transpose