Answer Posted / raghava

proc sql;
select *
from one left join two
on one.X=two.X;
quit;

The above is code for lefjoin.

what is slowly changing dimension? : Sas-di

1064

---

What is the role of sas grid administrator? : sas-grid-administration

1229

---

what are the categories that sas informats are used to the place the data? : Sas-administrator

987

---

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2434

---

what are the component of range? : Sas-bi

1015

---

Name types of category in which SAS Informats are placed?

1084

---

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

980

---

what is study design in while working with SAS? what are screening variables in SAS?

2174

---

What is proc sort?

1133

---

what is hash files in sas and why we are using this one in sas?

2153

---

Mention some common errors that are usually committed in sas programming.

994

---

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

949

---

Name any two sas spawners? : sas-grid-administration

978

---

what is the effect of the options statement errors=1? : Sas programming

999

---

What are the difference between ceil and floor functions in sas?

1274

---