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 |
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
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
Thanks @Reeza that worked for me! I was missing the 'in' and parantheses.
Best!
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.