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

copy value from one variable to another variable

Dhana18 — Mon, 30 Sep 2019 19:24:48 GMT

I have a daset like this

IncidentID	MENSEX	MaleSexPartners
1	1	0
2	10	0
3	1	1
4	1	0
5	2	0
7	5	5
10	5	0
12	5	0
13	5	0

I would like to copy variable from MENSEX variable to malesexpartners variable ONLY if malesexpartners's value is "0". I want my data to look like this

IncidentID	MENSEX	MaleSexPartners
1	1	1
2	10	10
3	1	1
4	1	1
5	2	2
7	5	5
10	5	5
12	5	5
13	5	5

Please help me. Thank you

Re: copy value from one variable to another variable

Reeza — Mon, 30 Sep 2019 19:27:34 GMT

Have you tried an IF/THEN statement?
Or a CASE statement in SQL?

If so, please post the code you've tried that's not working.

Re: copy value from one variable to another variable

Reeza — Mon, 30 Sep 2019 19:27:50 GMT

Or IFN/IFC depending on if the variable is character or numeric.

Re: copy value from one variable to another variable

Dhana18 — Mon, 30 Sep 2019 20:08:32 GMT

Yes, I used if then statement and it worked. Thank you.