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 |
calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
What are the different servers in sas? : sas-grid-administration
What do you feel about hardcoding?
1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What is the function of Stop statement in a SAS Program?
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
Which command is used to perform sorting in sas program?
What is the use of divide function?
what is SAS OPTIMIZATION?