I have got data on Pressure Injuries. Each row tells me how many pressure injuries each person has. Then I also have variables such as toe, foot, hand, and so on, which specify the stage of pressure injury. I want to break these variables apart but I am missing something. Current data is as follows:
ID No of PI Foot1 Arm Hand
1 1 Stage1
2 3 Stage 3 Stage 3 Stage 1
3 2 Stage 4 Stage 1
I want the data to look like:
D No of PI PI 1 Location PI 1 Stage PI 2 Location PI 2 stage
1 1 Foot 1 Stage1 Arm Stage 1
2 3 Foot 1 Stage 4 Hand Stage 2
3 2 Foot 1
I have tried using the recode and compute function and it works for the first pressure injury. But it doesn't seem to work for the second and so on.
Can you please offer suggestions, thanks in advance .
Hi Daniela,
Thanks for responding.
The reason, primarily for breaking the variable apart is because we have currently got multiple other files in the required format and these will eventually be merged. Also we may only possibly examine the certain stages of the PUs, and if the data is organized as such might make it a bit tricky. Another reason is because we have approximately 26 locations and collapsing them in to one variable might make it manageable. Location 1 is not the most severe pressure injury.
All of the variables are numeric. Basically, it is simply not getting the values from the other variables and I get a blank variable.
Hi Daniela,
Thanks. Yes I have used DO-IF ELSE-IF but I think I am missing something somewhere because it seems to work only for the first pressure injury. Location depends on no of PIs yes. But it would eventually be coded as a categorical variable with 1, 2, 3 etc. referring arm, knee, thigh, etc. Unfortunately we might have to do it manually I feel- we do quite massive database so it going to be quite time consuming.
Once again, thanks so much.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Statistics
- Statistical Software
- SPSS