topic Re: getting value from one variable to another in SAS Programming

getting value from one variable to another

Dhana18 — Fri, 13 Sep 2019 17:00:41 GMT

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.

Re: getting value from one variable to another

maguiremq — Fri, 13 Sep 2019 17:05:17 GMT

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

Re: getting value from one variable to another

Reeza — Fri, 13 Sep 2019 17:07:28 GMT

@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?

@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.

Re: getting value from one variable to another

Dhana18 — Fri, 13 Sep 2019 17:30:44 GMT

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.