Answer Posted / uma

first sort these datasets by common variable DEPT_ID,Then
use the following:
data left_join;
merge emp (in=a) dept (in=b);
by dept_id;
if a then output;
run;

How would you define the end of a macro? : sas-macro

1127

---

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?

2981

---

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1078

---

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2152

---

What is the use of function Proc summary?

1338

---

What is the function of output statement in a SAS Program?

1119

---

How to test the debugging in sas?

1239

---

explain the proc in sas? : Sas-administrator

1128

---

What can you learn from the SAS log when debugging?

1429

---

How do you specify the number of iterations and specific condition within a single do loop?

1150

---

Mention how to limit decimal places for the variable using proc means?

1167

---

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2083

---

what is star schema? : Sas-di

1182

---

how does sas handle missing values in sort order? : Sas programming

974

---

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1920

---