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 |
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Name statements that function at both compile and execution time?
what is the difference between proc means and proc summary?
How do you put an elephant in the refrigerator?
What data sets do you need to produce the report?
What is the use of stop statement?
Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.
What is Linear Regression?
Describe the ways in which you can create macro variables? : sas-macro
what is syntax of proc merge ?
How do you read in the variables that you need?
You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20