Answer / naresh

%macro update_table(demo1)
%let X = "JAN,FEB,MAR,APR";

%do i = 1 %to 4
%let y = scan(&x,i,',');

data &Master_table;
update &Master_table &y;
by acc_id;
run
%let i = %eval(&i+1);
%end;
%mend update_table;

Answer / satheesh

%macro sam (&mon);
data &mon1.;
set &mon.;
run;

proc append base = sav.appendData data = &mon.;
run;
%mend;
%sam(Jan);
%sam(Feb);
%sam(Mar);

What is substr function?

0 Answers  

---

Name few SAS functions?

0 Answers  

---

what are the scrubbing procedures in sas? : Sas programming

0 Answers  

---

Identify statements whose placement in the DATA step is critical.

6 Answers   Accenture, Labasol,

---

How would you include common or reuse to be processed along with your statements?

0 Answers  

---

explain the key concept of sas? : Sas-administrator

0 Answers  

---

Give some examples where proc report’s defaults are different than proc print’s defaults?

0 Answers  

---

What is the difference between an informat and a format. Name three informats or formats.

6 Answers  

---

how sas deals with business intelligence? : Sas-bi

0 Answers  

---

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 Answers  

---

what is portability of sas programmes?

2 Answers   Capital One,

---

Differentiate input and infile.

0 Answers  

---