Answer Posted / chandrakanth

proc sql;
create table dataset-name as select * from source-dataset-name group by sorting-variable-name;
quit;

GROUP BY option is for sorting the data.

Please let me know if you have more questions

what is data governance? : Sas-di

1015

---

What are the default statistics that proc means produce?

1033

---

what is the use of proc sql? : Sas programming

1130

---

What are the special input delimiters used in SAS?

1174

---

what is the difference between infile and input? : Sas-administrator

1133

---

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1186

---

What are the implications?

1701

---

what are _numeric_ and _character_ and what do they do? : Sas programming

1147

---

What is the difference between order and group variable in proc report?

1428

---

Mention the difference between ceil and floor functions in sas?

1144

---

explain the use of % includes a statement in sas? : Sas-administrator

998

---

how sas deals with business intelligence? : Sas-bi

1052

---

How do you connect the desktop application to metadata server? : sas-grid-administration

1087

---

Explain the difference between nodup and nodupkey options?

1020

---

what is sas metadata repository? : Sas-bi

1112

---