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 |
explain about various caches available in data integrator? : Sas-di
How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C
What is the registered Key word is sas????
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
Tell me about % include and % eval? : sas-macro
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
How to convert HTML file into SAS dataset?
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
for whom is sas data integration studio designed? : Sas-di
What is the difference between order and group variable in proc report?
what is pdv? how it is related to input buffer in sas?
What statement do you code to tell SAS that it is to write to an external file?