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 / 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 |
Post New Answer View All Answers
What is maximum number of rows and cols can be handled in SAS?
What is the use of the %include statement?
what has been your most common programming mistake? : Sas programming
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
Define run-group processing?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What is the role of unrestrictive users? : sas-grid-administration
what are informats in sas? : Sas-administrator
Which command is used to perform sorting in sas program?
what is hash files in sas and why we are using this one in sas?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What system options would you use to help debug a macro? : sas-macro
How to specify variables to be processed by the freq procedure?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Can you suggest us materials for sdtm mapping?