ASSIGNMENT STATEMENT | DATA STEP | SET STATEMENT
OBSERVE THE ASSIGNMENT STATEMENT WHICH IS PLACED WITH ALREADY AVAILABLE VARIABLE WITH SAME NAME AND DIFFERNT NAME..
DATA NEW;
SET SASHELP.CLASS;
GENDER=SEX;
RUN;
PROC PRINT;RUN;
OUTPUT:
| Obs | Name | Sex | Age | Height | Weight | GENDER |
|---|---|---|---|---|---|---|
| 1 | M | 12 | 57.3 | 83.0 | M | |
| 2 | M | 12 | 59.0 | 99.5 | M | |
| 3 | F | 13 | 56.5 | 84.0 | F | |
| 4 | F | 15 | 66.5 | 112.0 | F | |
| 5 | Alfred | M | 14 | 69.0 | 112.5 | M |
| 6 | Alice | F | 13 | 56.5 | 84.0 | F |
| 7 | Barbara | F | 13 | 65.3 | 98.0 | F |
| 8 | Carol | 14 | 62.8 | 102.5 | ||
| 9 | Carol | F | 14 | 62.8 | 102.5 | F |
| 10 | Henry | M | 14 | 63.5 | 102.5 | M |
| 11 | James | M | 12 | 57.3 | 83.0 | M |
| 12 | Jane | F | 12 | 59.8 | 84.5 | F |
| 13 | Janet | F | 15 | 62.5 | 112.5 | F |
| 14 | Jeffrey | M | 13 | 62.5 | 84.0 | M |
| 15 | John | M | 12 | 59.0 | 99.5 | M |
| 16 | Joyce | F | 11 | 51.3 | 50.5 | F |
| 17 | Judy | 14 | 64.3 | 90.0 | ||
| 18 | Judy | F | 14 | 64.3 | 90.0 | F |
| 19 | Louise | F | 12 | 56.3 | 77.0 | F |
| 20 | Mary | F | 15 | 66.5 | 112.0 | F |
| 21 | Philip | M | 16 | 72.0 | 150.0 | M |
| 22 | Robert | M | 12 | 64.8 | 128.0 | M |
| 23 | Ronald | M | 15 | 67.0 | 133.0 | M |
| 24 | Thomas | M | 11 | 57.5 | 85.0 | M |
| 25 | William | M | 15 | 66.5 | 112.0 | M |
DATA NEW1;
SET SASHELP.CLASS;
AGE=Age;
RUN;
PROC PRINT;RUN;
OUTPUT:
| Obs | Name | Sex | Age | Height | Weight |
|---|---|---|---|---|---|
| 1 | M | 12 | 57.3 | 83.0 | |
| 2 | M | 12 | 59.0 | 99.5 | |
| 3 | F | 13 | 56.5 | 84.0 | |
| 4 | F | 15 | 66.5 | 112.0 | |
| 5 | Alfred | M | 14 | 69.0 | 112.5 |
| 6 | Alice | F | 13 | 56.5 | 84.0 |
| 7 | Barbara | F | 13 | 65.3 | 98.0 |
| 8 | Carol | 14 | 62.8 | 102.5 | |
| 9 | Carol | F | 14 | 62.8 | 102.5 |
| 10 | Henry | M | 14 | 63.5 | 102.5 |
| 11 | James | M | 12 | 57.3 | 83.0 |
| 12 | Jane | F | 12 | 59.8 | 84.5 |
| 13 | Janet | F | 15 | 62.5 | 112.5 |
| 14 | Jeffrey | M | 13 | 62.5 | 84.0 |
| 15 | John | M | 12 | 59.0 | 99.5 |
| 16 | Joyce | F | 11 | 51.3 | 50.5 |
| 17 | Judy | 14 | 64.3 | 90.0 | |
| 18 | Judy | F | 14 | 64.3 | 90.0 |
| 19 | Louise | F | 12 | 56.3 | 77.0 |
| 20 | Mary | F | 15 | 66.5 | 112.0 |
| 21 | Philip | M | 16 | 72.0 | 150.0 |
| 22 | Robert | M | 12 | 64.8 | 128.0 |
| 23 | Ronald | M | 15 | 67.0 | 133.0 |
| 24 | Thomas | M | 11 | 57.5 | 85.0 |
| 25 | William | M | 15 | 66.5 | 112.0 |
COMMENT AND SHARE YOUR SYNTAX...
-->PLEASE READ AND COMMENT THE BLOG...
--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...
--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...
--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES
CLICK HERE : https://t.me/SasAll4You
No comments:
Post a Comment