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
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 |
how many types prompting framework can be broken down to? : Sas-bi
What is difference between (a-z) and (a--z)
what is AE onset date and what is RDS?
: and & modifiers.
What is the function of output statement in a SAS Program?
What are the criticality that you have faced during your project in SAS?
what is the difference between DUPKEY and NODUPKEY???
What is the difference between input and infile statement?
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
How do you connect the desktop application to metadata server? : sas-grid-administration
In a shcool there are 1000 students. After completion of every test in 6 subjects , each subject teacher submit the marks of every student at different times and loaded in the database commonly. How will you seperate the top two subject marks for each each studet using SAS?
explain what is factor analysis? : Sas-administrator