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;
You can't do this for the sake of missing value in these variables.
So What output do you need after transposing dataset ?
Ksharp
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.