topic Rename rows in a column to new names in a new column in SAS Programming

Rename rows in a column to new names in a new column

kaufjd01 — Wed, 27 Oct 2021 15:06:36 GMT

Agriculture data set. Need to rename all similar pens 1 and 3 into treatment = A and rename all similar pens 2 and 4 into treatment = B. Treatment would be a new column. How do I setup up this code? It seems like it would be simple, but I am struggling. Thanks!

Pen
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4

Re: Rename rows in a column to new names in a new column

Reeza — Wed, 27 Oct 2021 15:15:58 GMT

data want;
set have;

if PEN in (1,3) then Treatment = 'A';
else if PEN in (2, 4) then Treatment = 'B';

run;

@kaufjd01 wrote:

Agriculture data set. Need to rename all similar pens 1 and 3 into treatment = A and rename all similar pens 2 and 4 into treatment = B. Treatment would be a new column. How do I setup up this code? It seems like it would be simple, but I am struggling. Thanks!

Pen

1

1

1

1

1

1

1

1

1

1

2

2

2

2

2

2

2

2

2

2

3

3

3

3

3

3

3

3

3

3

4

4

4

4

4

4

4

4

4

4

Re: Rename rows in a column to new names in a new column

kaufjd01 — Wed, 27 Oct 2021 15:19:10 GMT

Thanks @Reeza that worked for me! I was missing the 'in' and parantheses.

Best!