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
- 5130 Views
- I also Faced
- E-Mail Answers
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
Give an example where SAS fails to convert character value to numeric value automatically?
What is the role of sas grid administrator? : sas-grid-administration
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
what is sas business intelligence? : Sas-bi
What does the trace option do?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
What are the advantages of using sas?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
what is transformation in sas data integration? : Sas-di
How to sort in descending order?
What can you learn from the SAS log when debugging?
explain the use of % includes a statement in sas? : Sas-administrator
What are the special input delimiters used in SAS?
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
