How would you keep from overlaying the a SAS set with its
sorted version?
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 2 Yes | 0 No |
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;
| Is This Answer Correct ? | 0 Yes | 0 No |
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What are the criticality that you have faced during your project in SAS?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
How do you debug and test your SAS programs?
What are the Aggregate functions in SQL ?
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
what does the run statement do? : Sas programming
explain the function of substr in sas? : Sas-administrator
How do you specify the number of iterations and specific condition within a single do loop?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What is the order of evaluation of the following operators + - * / ** () ???
What are the data types that sas contain?