Answer / tangyoulei

proc sort data=*** out=###;
by;
run;

Answer / hsong001

I agree that we can use the out= options in proc sort to
create a new data set for the sorted version. However,
sometimes we just forgot it. To prevent overwritten the
original data set that in a permanent library, we can specify:
options noreplace;
This will prevent accidentally overlaying the original data
set in case out= option is not specified.

Answer / siri

keep a new dataset name to the sorted version.

Answer / ganesh

first create the dataset by giving some name after that
sort the data by specifying out option by giving new
dataset name. The dataset can be sorter either ascending or
descending by default it going to be an ascending.

Data god;
input name no sal;
datalines;
ab 12 3500
bc 13 4500
;
run;
proc sort data=god out=man;
by name;
run;

what is the primary data source for the wrs? : Sas-bi

0 Answers  

---

Hi All.I am looking for Good Institute who could Provide the online SAS BI+DI Training along with software.Primarily in Delhi/NCR or in Hyderabad Please help with name and contact number of concerned person!! Thanks in Advance! :)

1 Answers  

---

How we can call macros with in data step? : sas-macro

0 Answers  

---

how can get the first and last observations in a dataset using Proc SQl?

4 Answers   Satyam,

---

Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.

2 Answers  

---

Which is the best training institute for SAS in hyderabad.

112 Answers   Stansys Software Solutions,

---

Are you familiar with special input delimiters? How are they used?

4 Answers   Accenture,

---

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 Answers  

---

How would you delete observations with duplicate keys?

6 Answers  

---

How do you delete duplicate observations in sas?

0 Answers  

---

How could you generate test data with no input data?

6 Answers   Quintiles,

---

What is difference between N and n????

2 Answers   Sciformix,

---