Answer Posted / pambrose

Assuming the question is intended to automate the code..lets say for a monthly report.

here is the outlook of the code

data run_report;
day1 = day(today());
if day1 = 1 then call execute('%monthlyreports');
else.........
....
.........
run;

%monthlyreport;
SAS report generation
%mend;

How are numeric and character missing values represented internally?

1654

---

What is the maximum length of the macro variable?

1173

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2920

---

what are some good sas programming practices for processing very large data sets? : Sas programming

920

---

What is the difference between %put and symbolgen? : sas-macro

1231

---

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1229

---

Why double trailing @@ is used in input statement?

1216

---

what is star schema? : Sas-di

1123

---

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

1102

---

What is PDV?

1140

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1042

---

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

1036

---

Give e an example of..

2093

---

How to create a permanent sas data set?

1219

---

describe the interaction table in sas di? : Sas-di

1028

---