Answer Posted / richa

The PROC SQL step does not require a RUN statement. PROC
SQL executes each query automatically. If you use a RUN
statement with a PROC SQL step, SAS ignores the RUN
statement, executes the statements as usual, and generates
the note shown below in the SAS log:

NOTE: PROC SQL statements are executed immediately;
The RUN statement has no effect.

As per SAS certification guide.

Enlist the functions performed by sas.

1128

---

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2372

---

How can you limit the variables written to output dataset in data step?

1317

---

Tell me more about the parameters in macro? : sas-macro

1053

---

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1792

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

2206

---

what is operational data and operational system? : Sas-di

1115

---

What is slibref?

1281

---

Difference between nodup and nodupkey options?

1195

---

how do the in= variables improve the capability of a merge? : Sas programming

1436

---

How do you control the number of observations and/or variables read or written?

1250

---

For what purposes have you used sas macros? : sas-macro

1001

---

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2126

---

Explain proc univariate?

1031

---

explain the proc in sas? : Sas-administrator

1092

---