Answer / ramesh

First calculate age in B datase


data age;
set b;
age=int(intck('day',bday,today())/365.25);
run;

sort both datasets by the age key variable and Use the
merge statement to combine the both datasets

Answer / vishal

Calculate age in dataset B by using the following code:
data ages;
set b;
retain current;
if _n_=1 then current=today();
format bday current worddate20.;
age=int(intck('month',bday,current)/12);
if month(bday)=month(current) then
age=age-(day(bday)>day(current));
run;

Source: http://support.sas.com/kb/24/567.html

Answer / alok karan

First calculate age in BB dataset:

data bbb;
set bb;
age=round(yrdif(birthdate,today(),'Actual'),1);
run;
proc sort data=bbb;
by age;
drop birthdate;
run;

Now merge both dataset by age variable:
data abc;
merge aa bbb;
by age;
run;

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  

---

How can you create a macro variable with in data step? : sas-macro

0 Answers  

---

Why do we use QUIT commmand for proc datasets and proc sql ???

3 Answers  

---

Hi, If anyone has base SAS certification dumps, please share.

0 Answers  

---

Give some examples where proc report’s defaults are same as proc print’s defaults?

0 Answers  

---

In sas admin differentiate between roles and capabilities? : sas-grid-administration

0 Answers  

---

CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

4 Answers   CybAge,

---

How to merge the data using merge statement and proc format? Is the result is same ?

2 Answers  

---

what is the effect of the options statement errors=1? : Sas programming

0 Answers  

---

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

1 Answers   Accenture, HSBC,

---

How necessary is it to be creative in your work?

0 Answers   Oracle,

---

i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

6 Answers   GSK,

---