Answer Posted / amar

Proc sort data=dataset;
by idnumber ;
run;

In ARRAY processing, what does the DIM function do?

712

---

Give e an example of..

1655

---

Do you need to rearrange the order of the data for the report?

1835

---

what are validation tools that are used in sas? : Sas-administrator

593

---

how will you locate the sas platform applications? : Sas-bi

586

---

---

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

576

---

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;

1969

---

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2265

---

what are input dataset and output dataset options? : Sas programming

563

---

Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?

1768

---

what is SAS OPTIMIZATION?

1817

---

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.

1801

---

What is the difference between nodupkey and nodup options?

595

---

Explain what Proc glm does?

637

---

What are the automatic variables for macro? : sas-macro

677

---