Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What are the special input delimiters used in SAS?

1104


what is enterprise guide? What is the use of it? : Sas programming

950


Give e an example of..

2275


What are pdv and it functions?

1038


Explain the main difference between the sas procedures and functions? : Sas-administrator

1015


what type of graphs we will create(for 2+years candidates)?

2241


how to do user inputs and command line arguments in sas?

2977


What sas features do you use to check errors and data validation?

1163


Give an example where SAS fails to convert character value to numeric value automatically?

1028


What is PDV?

1094


What is the role of administrative users? : sas-grid-administration

1028


What are the data types that sas contain?

1120


Are you involved in writing the inferential analysis plan? Tables specifications?

3898


what is data access? : Sas-di

1081


for report generation which one you used proc report or data_null_?

7630