topic Copy some selects into another variable in SAS Programming

Copy some selects into another variable

Gladis6680 — Wed, 05 Jun 2019 17:19:03 GMT

Sample Data:

I would like to know how to copy values of MILK from B to C

OBS	A	B	C
1	COFFEE	$16.80	$16.80
2	COFFEE	$27.14	$27.14
3	COFFEE	$49.20	$49.20
4	COFFEE	$65.00	$65.00
5	COFFEE	$66.70	$66.70
6	MILK	$38.46	$0.00
7	MILK	$128.20	$0.00
8	MILK	$66.50	$0.00
9	MILK	$32.05	$0.00
10	MILK	$30.06	$0.00
11	MILK	$14.85	$0.00
12	TEA	$34.60	$34.60
13	TEA	$1.73	$1.73
14	TEA	$70.93	$70.93
15	TEA	$6.92	$6.92
16	EXPRESSO	$34.60	$0.00
17	EXPRESSO	$10.38	$0.00
18	EXPRESSO	$17.30	$0.00

Re: Copy some selects into another variable

Reeza — Wed, 05 Jun 2019 17:23:13 GMT

data want;
set have;

if a = 'MILK' then C = B;

run;

You can use a conditional IF statement.

@Gladis6680 wrote:

Sample Data:

I would like to know how to copy values of MILK from B to C

OBS A B C

1 COFFEE $16.80 $16.80

2 COFFEE $27.14 $27.14

3 COFFEE $49.20 $49.20

4 COFFEE $65.00 $65.00

5 COFFEE $66.70 $66.70

6 MILK $38.46 $0.00

7 MILK $128.20 $0.00

8 MILK $66.50 $0.00

9 MILK $32.05 $0.00

10 MILK $30.06 $0.00

11 MILK $14.85 $0.00

12 TEA $34.60 $34.60

13 TEA $1.73 $1.73

14 TEA $70.93 $70.93

15 TEA $6.92 $6.92

16 EXPRESSO $34.60 $0.00

17 EXPRESSO $10.38 $0.00

18 EXPRESSO $17.30 $0.00

Re: Copy some selects into another variable

Gladis6680 — Wed, 05 Jun 2019 17:29:25 GMT

Thank you so much.