Interested to Buy Any Domain ? << Click Here >> for more details...
How would you keep from overlaying the a SAS set with its
sorted version?
- 4 Answers
- 9708 Views
- I also Faced
- E-Mail Answers
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 |
One way of creating a new variable in Macros is by % Let....What is the other way..?
Differentiate input and infile.
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
How would you code a merge that will keep only the observations that have matches from both sets?
what is broad cast agent? : Sas-bi
what is sas business intelligence? : Sas-bi
i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance
SAS using companies in chennai
how many types of MERGE?
how could you generate test data with no input data? : Sas programming
Explain append procedure?
what are 5 ways to perform a table lookup in sas? : Sas-administrator
Teradata 
