How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;

2 Answers   HSBC,

---

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

1 Answers   Accenture,

---

Which function is used to count the number of intervals between two sas dates?

0 Answers  

---

What is the difference between informat and format statement?

1 Answers  

---

If money were no object, what would you like to do?

0 Answers   Oracle,

---

Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?

2 Answers  

---

What do the mod and int function do? : Sas programming

0 Answers  

---

what kind of variables are collected in AE dataset?

3 Answers   Accenture, Quintiles, SAS,

---

Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.

2 Answers  

---

Define run-group processing?

0 Answers  

---

what are the best practices to process the large data sets in sas programming? : Sas-administrator

0 Answers  

---

Of all your work, where have you been the most successful?

0 Answers   Oracle, Six Sigma,

---