Hi, I have one dataset, could you please ans for this.
id amount paid_amount
1 700 400
2 900 250
3 300 300
a 400 250
b 500 320
c 800 650
x 200 190
y 900 250
z 300 180
i want create new dataset having id and paid_amount who are
paid high amount comparing amount.
ex: 1d paid_amount
3 300
c 650
x 190
Answer Posted / ashish
data test1;
set test;
pct=(paid_amount/amount)*100;
run;
proc sort data=test1 out=test2;
by DESCENDING pct;
data test3;
set test2(obs=3);
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the special input delimiters used in SAS?
what is enterprise guide? What is the use of it? : Sas programming
Give e an example of..
What are pdv and it functions?
Explain the main difference between the sas procedures and functions? : Sas-administrator
what type of graphs we will create(for 2+years candidates)?
how to do user inputs and command line arguments in sas?
What sas features do you use to check errors and data validation?
Give an example where SAS fails to convert character value to numeric value automatically?
What is PDV?
What is the role of administrative users? : sas-grid-administration
What are the data types that sas contain?
Are you involved in writing the inferential analysis plan? Tables specifications?
what is data access? : Sas-di
for report generation which one you used proc report or data_null_?