Answer / kiran

Yes, we can use a macro with in another macro

for example:

%MACRO REPORT; ---MACRO
statement 1;
statement 2;
....
....
%MACRO REPORT1();--BEGINING OF NEW MACRO "REPORT 1" WITH
IN "REPORT" MACRO
%MEND REPORT1;---STATEMENT TO TELL THE END OF REPORT1 MACRO
%MEND REPORT;----STATEMENT TO TELL THE END OF REPORT MACRO

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 Answers  

---

how to remove the duplicates by proc sql?

2 Answers   Genpact,

---

How do i read multiple spaces in datasets?

4 Answers   Quintiles,

---

How could you generate test data with no input data?

6 Answers   Quintiles,

---

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

6 Answers  

---

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data set to a second data set, and the non-matches of the right-most data set to a third data set?

2 Answers  

---

What is the difference between input and infile statement?

0 Answers  

---

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,

---

what has been your most common programming mistake? : Sas programming

0 Answers  

---

Can we replace a dataset into view?

6 Answers   CliniRx,

---

Explain the difference between nodup and nodupkey options?

0 Answers  

---

Differences between where and if statement?

0 Answers  

---