I have 2 data sets A & B. Both have a variable called Age in
them, each of them specifying a different functionality.
In my program I use bot these data sets. How do I specify
which Age variable I want to use?
Answers were Sorted based on User's Feedback
Answer / presha badiyani
use rename option
Data a1;
input A $20 @50 age;
Data b1;
input x b age;
Data c;
set a1 b1(rename age=b1_age);
If age = b1_age;
run;
| Is This Answer Correct ? | 6 Yes | 6 No |
Answer / poojavaibhav
Deepak please explain the word functionality in detail.
But if i have to answer above question then i think if you have var that have same name in different dataset and you want to use them both then rename one of the variable and apply condition..
thanks.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / alok karan
Data a1;
input y age;
Data b1;
input x age;
Data c;
set a1 b1(drop=age);
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kush
proc sql;
select Variable_name
from Variable_name.DataSet_name;
run;
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / nbohr02
Use a two level name.
Data a1;
input A $20 @50 age;
Data b1;
input x b age;
Data c
If a1.age = b1.age;
| Is This Answer Correct ? | 1 Yes | 9 No |
Explain how merging helps to combine data sets.
What are the main differences between sas versions 8.2, 9.0, 9.1?
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;
what the use of proc glm
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
explain the difference between proc means and proc summary?
What does PROC print, and PROC contents do?
how can you create zero observation dataset? : Sas programming
How many data types are there in SAS?
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS