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

Answers were Sorted based on User's Feedback



Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 ..

Answer / naresh

data high_amount;
set amount;
if amount>paid_amount then output;
drop paid_amount;
run;

proc print;run;

Is This Answer Correct ?    1 Yes 1 No

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 ..

Answer / 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

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 ..

Answer / pavan

data inter7;
input id $1-2 sal1 6-9 sal2 13-16;
cards;
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
;
run;

data inter8 ;
set inter7;
if sal1>=sal2 then sal=sal1;
if sal2>=sal1 then sal=sal2;
run;

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More SAS Interview Questions

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  


What are the features of SAS?

0 Answers  


I am looking to buy a sas advance book. So any one can guide me that which one i should buy.

0 Answers  


Why do we use QUIT commmand for proc datasets and proc sql ???

3 Answers  


how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too

5 Answers   CTS,


for what purpose would you use the retain statement? : Sas programming

0 Answers  


/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

5 Answers  


Mention few ways with which a “table lookup’ is done in sas programming.

1 Answers  


how to assign a macro value to a variable?

8 Answers   CitiGroup,


i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?

6 Answers   GSK,


How do you add a number to a macro variable? : sas-macro

0 Answers  


how do you validate sas program?

6 Answers   Accenture,


Categories