getting value from one variable to another

[Dhana18]

Hello,

I have a dataset like this. 9 is Unknown and 1 is male 2 is female and 3 is both. so I would like to copy (not 9) values from gendersp in to gender_sp variable. 

GENDER_SP	GENDERSP
9	1
9	1
1	9
1	9
9	1
1	9
9	1
9	1
1	9
1	9
1	9
9	1
1	9
1	9
1	9
1	9
9	2
2	9
9	2
2	9
9	2
2	9
2	9
2	9
9	2
9	2
2	9
9	2
2	9
9	2
2	9
9	2
2	9
9	2
2	9
3	9

used this code.

if CL_PATIENTID="07898" AND CL_EVENTID="1151" AND GENDERSP="1" then GENDER_SP='1';

if CL_PATIENTID="25346" AND CL_EVENTID="1722" AND GENDERSP="1" then GENDER_SP='1';

if CL_PATIENTID="36391" AND CL_EVENTID="1442" AND GENDERSP="2" then GENDER_SP='2';

 It did not work. Please help me find what is wrong. Thank you.

[maguiremq]

data want;
set have;
if gender_sp ne 9 then do;
	gendersp = gender_sp;
end;
run;

[Dhana18]

I tried the code you sent. The log shows no problem and I checked with one of the id 07898 using proc print. Same patient can have two visits so this is what I see in the output
CL_PATIENTID

CL_EVENTID

VISDATE

GENDER_SP

GENDERSP

16

07898

1073

2019-07-26

1

1

17

007898

1151

2019-07-30

9

1













It did not work.

[Reeza]

---

@Dhana18 wrote:

Hello,

I have a dataset like this. 9 is Unknown and 1 is male 2 is female and 3 is both. so I would like to copy (not 9) values from gendersp in to gender_sp variable. 

---

The section in orange above is unclear. 

Please answer the following:

• You're starting with variable gendersp?
• Does gender_sp variable already exist in the data set?
• If not, you're creating it from gendersp, what are the rules: How do you know when to put a 1 or 2?
• If it's by ID, as you seem to indicate in your code, how do you know that, do you have a list of IDs somewhere?

Spoiler

---

@Dhana18 wrote:

Hello,

I have a dataset like this. 9 is Unknown and 1 is male 2 is female and 3 is both. so I would like to copy (not 9) values from gendersp in to gender_sp variable. 

GENDER_SP	GENDERSP
9	1
9	1
1	9
1	9
9	1
1	9
9	1
9	1
1	9
1	9
1	9
9	1
1	9
1	9
1	9
1	9
9	2
2	9
9	2
2	9
9	2
2	9
2	9
2	9
9	2
9	2
2	9
9	2
2	9
9	2
2	9
9	2
2	9
9	2
2	9
3	9

used this code.

if CL_PATIENTID="07898" AND CL_EVENTID="1151" AND GENDERSP="1" then GENDER_SP='1';

if CL_PATIENTID="25346" AND CL_EVENTID="1722" AND GENDERSP="1" then GENDER_SP='1';

if CL_PATIENTID="36391" AND CL_EVENTID="1442" AND GENDERSP="2" then GENDER_SP='2';

 It did not work. Please help me find what is wrong. Thank you.

---