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
- 3 Answers
- 5147 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is the difference between %local and %global?
Give some ways by which you can define the variables to produce the summary report (using proc report)?
how can you put a "trace" in your program? : Sas programming
What are the differences between proc means and proc summary?
how do you derive descriptive statistics?
1 Answers Accenture, Quintiles,
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
What is PDV?
What can you learn from the SAS log when debugging?
how many display types available in sas bi dashboard? : Sas-bi
Can you explain the process of calendar?
Explain what is the use of proc gplot?
What is the difference between Regression and Logistic Regression? Can u explain the Assumptions/Conditions?
Teradata 
