SPSS Statistics

Hello! 

I am a medical student, new to SPSS, without any opportunity to take classes or courses for this program. And we now need to utilize this program for a research assignment. 

As you can imagine, we have hit a bump in the road, and I could really need your help. 

I'll try to explain the idea and our current layout, and then what we need:

So, we are going to gather patient data from journals. Our variables are in the bottom if needed. We will fill them out for each patient, we have about 60 or so. So we have our desired variables. Each patient gets and ID-number to be able to be anonymous. So from 1 to 60. My point is that each patient will be submitted more than once, maybe 5-15 times, in the period we wish to look at. And I wonder if anyone of you have any suggestions of a smart layout for this? We have so little experience with SPSS and don't know how to solve this in the best way. 

Our current plan is to to something like this: Patient 1's first hospitalization will be put as number one. Then the same patients second hospitalization will be put as 101, next as 102, 103, 104. Then patient 2's first hospitalization will be put as number 2, the same patients second as 201, 202, 203 and so on. 

If anyone of you have any good ideas for this, it would be greatly appreciated! 

Thanks in advanced!

B


1. Sex
2. Age
3. Age when submitted to hospital
4. Time since transplantation
5. Other diagnoses
6. How many UTI's over the whole period
7. How many times submitted to hospital in the whole period
8. What kind of bacteria they are infected with
9. The bacterias resistance
10. If they have bacteria in their blood
11. Days in hospital each time
12. What antibiotics they have used the last 6 months

------------------------------
BENDIK BRUNVOLL
------------------------------

#SPSSStatistics

Each patient should have a unique ID number and within each of those, some number of hospitalizations. These variables would look something like below. Open a syntax window in SPSS, copy this syntax, run it, and look at the dataset.

DATA LIST FREE /PtID (N4) HospNumber (N5).
BEGIN DATA.
0001 0101
0001 0102
0001 0103
0002 0201
0003 0301
0003 0302
0004 0401
0005 0501
0005 0502
0005 0503
0005 0504
0005 0506
6001 6001
6001 6002
END DATA.
VARIABLE LABELS PtID "Unique Patient ID Number"
  HospNumber "Patient's Hospitalization Number".
LIST.

Obviously I made up the data to make the point. The point is that each combination of patient ID and hospitalization number makes up one unique row of the dataset. Of course, you would add whatever variables you wanted in addition to what I have listed here.

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Wed March 17, 2021 08:43 AM
From: BENDIK BRUNVOLL
Subject: Beginner in need help for a simple layout idea

Hello! 

I am a medical student, new to SPSS, without any opportunity to take classes or courses for this program. And we now need to utilize this program for a research assignment. 

As you can imagine, we have hit a bump in the road, and I could really need your help. 

I'll try to explain the idea and our current layout, and then what we need:

So, we are going to gather patient data from journals. Our variables are in the bottom if needed. We will fill them out for each patient, we have about 60 or so. So we have our desired variables. Each patient gets and ID-number to be able to be anonymous. So from 1 to 60. My point is that each patient will be submitted more than once, maybe 5-15 times, in the period we wish to look at. And I wonder if anyone of you have any suggestions of a smart layout for this? We have so little experience with SPSS and don't know how to solve this in the best way. 

Our current plan is to to something like this: Patient 1's first hospitalization will be put as number one. Then the same patients second hospitalization will be put as 101, next as 102, 103, 104. Then patient 2's first hospitalization will be put as number 2, the same patients second as 201, 202, 203 and so on. 

If anyone of you have any good ideas for this, it would be greatly appreciated! 

Thanks in advanced!

B


1. Sex
2. Age
3. Age when submitted to hospital
4. Time since transplantation
5. Other diagnoses
6. How many UTI's over the whole period
7. How many times submitted to hospital in the whole period
8. What kind of bacteria they are infected with
9. The bacterias resistance
10. If they have bacteria in their blood
11. Days in hospital each time
12. What antibiotics they have used the last 6 months

------------------------------
BENDIK BRUNVOLL
------------------------------

#SPSSStatistics

First of all, thanks so much for your help. We really appreciate it!

The first time I tried to run it, I got an error telling me ''LIST'' isn't acceptet as it isn't a command. I just tried clicking one more time, and ended up with this. Is this the correct list you imagined? I just want to be sure, because of the error-message. 

And now I just add my variables on the top as usual? I just manually put in extra patients and/or hospitalizations as I need below, I don't need to use the Syntax for this? 

Again, this was so helpful, thanks a lot for your help! SPSS is quite challenging to begin with, without any courses. 







------------------------------
BENDIK BRUNVOLL
------------------------------

Original Message:
Sent: Wed March 17, 2021 11:38 AM
From: Rick Marcantonio
Subject: Beginner in need help for a simple layout idea

Each patient should have a unique ID number and within each of those, some number of hospitalizations. These variables would look something like below. Open a syntax window in SPSS, copy this syntax, run it, and look at the dataset.

DATA LIST FREE /PtID (N4) HospNumber (N5).
BEGIN DATA.
0001 0101
0001 0102
0001 0103
0002 0201
0003 0301
0003 0302
0004 0401
0005 0501
0005 0502
0005 0503
0005 0504
0005 0506
6001 6001
6001 6002
END DATA.
VARIABLE LABELS PtID "Unique Patient ID Number"
  HospNumber "Patient's Hospitalization Number".
LIST.

Obviously I made up the data to make the point. The point is that each combination of patient ID and hospitalization number makes up one unique row of the dataset. Of course, you would add whatever variables you wanted in addition to what I have listed here.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Wed March 17, 2021 08:43 AM
From: BENDIK BRUNVOLL
Subject: Beginner in need help for a simple layout idea

Hello! 

I am a medical student, new to SPSS, without any opportunity to take classes or courses for this program. And we now need to utilize this program for a research assignment. 

As you can imagine, we have hit a bump in the road, and I could really need your help. 

I'll try to explain the idea and our current layout, and then what we need:

So, we are going to gather patient data from journals. Our variables are in the bottom if needed. We will fill them out for each patient, we have about 60 or so. So we have our desired variables. Each patient gets and ID-number to be able to be anonymous. So from 1 to 60. My point is that each patient will be submitted more than once, maybe 5-15 times, in the period we wish to look at. And I wonder if anyone of you have any suggestions of a smart layout for this? We have so little experience with SPSS and don't know how to solve this in the best way. 

Our current plan is to to something like this: Patient 1's first hospitalization will be put as number one. Then the same patients second hospitalization will be put as 101, next as 102, 103, 104. Then patient 2's first hospitalization will be put as number 2, the same patients second as 201, 202, 203 and so on. 

If anyone of you have any good ideas for this, it would be greatly appreciated! 

Thanks in advanced!

B


1. Sex
2. Age
3. Age when submitted to hospital
4. Time since transplantation
5. Other diagnoses
6. How many UTI's over the whole period
7. How many times submitted to hospital in the whole period
8. What kind of bacteria they are infected with
9. The bacterias resistance
10. If they have bacteria in their blood
11. Days in hospital each time
12. What antibiotics they have used the last 6 months

------------------------------
BENDIK BRUNVOLL
------------------------------

#SPSSStatistics

Your dataset looks like mine. That was the idea.

Of course, I just made up data. I don't know how many hospitalizations any patient actually had. Use what I did as a starting point and modify it to suit exactly what you have - either by changing the syntax I created or by going to the actual dataset you created from my syntax and deleting whatever rows you don't need and adding others.

Either way, remember that each row will be a unique combination of patient and one of their hospitalizations, and each column will be different variables you listed in your first note to us.

Another thing you could do, if you are more comfortable, is to enter all of your data in a spreadsheet, save it as an XL file, and "import" it into SPSS (in the menu, see "File > Import Data".

Good luck.

Rick

------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------

Original Message:
Sent: Thu March 18, 2021 03:08 AM
From: BENDIK BRUNVOLL
Subject: Beginner in need help for a simple layout idea

First of all, thanks so much for your help. We really appreciate it!

The first time I tried to run it, I got an error telling me ''LIST'' isn't acceptet as it isn't a command. I just tried clicking one more time, and ended up with this. Is this the correct list you imagined? I just want to be sure, because of the error-message. 

And now I just add my variables on the top as usual? I just manually put in extra patients and/or hospitalizations as I need below, I don't need to use the Syntax for this? 

Again, this was so helpful, thanks a lot for your help! SPSS is quite challenging to begin with, without any courses. 







------------------------------
BENDIK BRUNVOLL

Original Message:
Sent: Wed March 17, 2021 11:38 AM
From: Rick Marcantonio
Subject: Beginner in need help for a simple layout idea

Each patient should have a unique ID number and within each of those, some number of hospitalizations. These variables would look something like below. Open a syntax window in SPSS, copy this syntax, run it, and look at the dataset.

DATA LIST FREE /PtID (N4) HospNumber (N5).
BEGIN DATA.
0001 0101
0001 0102
0001 0103
0002 0201
0003 0301
0003 0302
0004 0401
0005 0501
0005 0502
0005 0503
0005 0504
0005 0506
6001 6001
6001 6002
END DATA.
VARIABLE LABELS PtID "Unique Patient ID Number"
  HospNumber "Patient's Hospitalization Number".
LIST.

Obviously I made up the data to make the point. The point is that each combination of patient ID and hospitalization number makes up one unique row of the dataset. Of course, you would add whatever variables you wanted in addition to what I have listed here.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Wed March 17, 2021 08:43 AM
From: BENDIK BRUNVOLL
Subject: Beginner in need help for a simple layout idea

Hello! 

I am a medical student, new to SPSS, without any opportunity to take classes or courses for this program. And we now need to utilize this program for a research assignment. 

As you can imagine, we have hit a bump in the road, and I could really need your help. 

I'll try to explain the idea and our current layout, and then what we need:

So, we are going to gather patient data from journals. Our variables are in the bottom if needed. We will fill them out for each patient, we have about 60 or so. So we have our desired variables. Each patient gets and ID-number to be able to be anonymous. So from 1 to 60. My point is that each patient will be submitted more than once, maybe 5-15 times, in the period we wish to look at. And I wonder if anyone of you have any suggestions of a smart layout for this? We have so little experience with SPSS and don't know how to solve this in the best way. 

Our current plan is to to something like this: Patient 1's first hospitalization will be put as number one. Then the same patients second hospitalization will be put as 101, next as 102, 103, 104. Then patient 2's first hospitalization will be put as number 2, the same patients second as 201, 202, 203 and so on. 

If anyone of you have any good ideas for this, it would be greatly appreciated! 

Thanks in advanced!

B


1. Sex
2. Age
3. Age when submitted to hospital
4. Time since transplantation
5. Other diagnoses
6. How many UTI's over the whole period
7. How many times submitted to hospital in the whole period
8. What kind of bacteria they are infected with
9. The bacterias resistance
10. If they have bacteria in their blood
11. Days in hospital each time
12. What antibiotics they have used the last 6 months

------------------------------
BENDIK BRUNVOLL
------------------------------

#SPSSStatistics

This is perfect, I am very grateful. Thanks so much!

Have a nice day!

B

------------------------------
BENDIK BRUNVOLL
------------------------------

Original Message:
Sent: Thu March 18, 2021 07:29 AM
From: Rick Marcantonio
Subject: Beginner in need help for a simple layout idea

Your dataset looks like mine. That was the idea.

Of course, I just made up data. I don't know how many hospitalizations any patient actually had. Use what I did as a starting point and modify it to suit exactly what you have - either by changing the syntax I created or by going to the actual dataset you created from my syntax and deleting whatever rows you don't need and adding others.

Either way, remember that each row will be a unique combination of patient and one of their hospitalizations, and each column will be different variables you listed in your first note to us.

Another thing you could do, if you are more comfortable, is to enter all of your data in a spreadsheet, save it as an XL file, and "import" it into SPSS (in the menu, see "File > Import Data".

Good luck.

Rick

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Thu March 18, 2021 03:08 AM
From: BENDIK BRUNVOLL
Subject: Beginner in need help for a simple layout idea

First of all, thanks so much for your help. We really appreciate it!

The first time I tried to run it, I got an error telling me ''LIST'' isn't acceptet as it isn't a command. I just tried clicking one more time, and ended up with this. Is this the correct list you imagined? I just want to be sure, because of the error-message. 

And now I just add my variables on the top as usual? I just manually put in extra patients and/or hospitalizations as I need below, I don't need to use the Syntax for this? 

Again, this was so helpful, thanks a lot for your help! SPSS is quite challenging to begin with, without any courses. 







------------------------------
BENDIK BRUNVOLL

Original Message:
Sent: Wed March 17, 2021 11:38 AM
From: Rick Marcantonio
Subject: Beginner in need help for a simple layout idea

Each patient should have a unique ID number and within each of those, some number of hospitalizations. These variables would look something like below. Open a syntax window in SPSS, copy this syntax, run it, and look at the dataset.

DATA LIST FREE /PtID (N4) HospNumber (N5).
BEGIN DATA.
0001 0101
0001 0102
0001 0103
0002 0201
0003 0301
0003 0302
0004 0401
0005 0501
0005 0502
0005 0503
0005 0504
0005 0506
6001 6001
6001 6002
END DATA.
VARIABLE LABELS PtID "Unique Patient ID Number"
  HospNumber "Patient's Hospitalization Number".
LIST.

Obviously I made up the data to make the point. The point is that each combination of patient ID and hospitalization number makes up one unique row of the dataset. Of course, you would add whatever variables you wanted in addition to what I have listed here.

------------------------------
Rick Marcantonio
Quality Assurance
IBM

Original Message:
Sent: Wed March 17, 2021 08:43 AM
From: BENDIK BRUNVOLL
Subject: Beginner in need help for a simple layout idea

Hello! 

I am a medical student, new to SPSS, without any opportunity to take classes or courses for this program. And we now need to utilize this program for a research assignment. 

As you can imagine, we have hit a bump in the road, and I could really need your help. 

I'll try to explain the idea and our current layout, and then what we need:

So, we are going to gather patient data from journals. Our variables are in the bottom if needed. We will fill them out for each patient, we have about 60 or so. So we have our desired variables. Each patient gets and ID-number to be able to be anonymous. So from 1 to 60. My point is that each patient will be submitted more than once, maybe 5-15 times, in the period we wish to look at. And I wonder if anyone of you have any suggestions of a smart layout for this? We have so little experience with SPSS and don't know how to solve this in the best way. 

Our current plan is to to something like this: Patient 1's first hospitalization will be put as number one. Then the same patients second hospitalization will be put as 101, next as 102, 103, 104. Then patient 2's first hospitalization will be put as number 2, the same patients second as 201, 202, 203 and so on. 

If anyone of you have any good ideas for this, it would be greatly appreciated! 

Thanks in advanced!

B


1. Sex
2. Age
3. Age when submitted to hospital
4. Time since transplantation
5. Other diagnoses
6. How many UTI's over the whole period
7. How many times submitted to hospital in the whole period
8. What kind of bacteria they are infected with
9. The bacterias resistance
10. If they have bacteria in their blood
11. Days in hospital each time
12. What antibiotics they have used the last 6 months

------------------------------
BENDIK BRUNVOLL
------------------------------

#SPSSStatistics