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
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
Can you execute macro within another macro? : sas-macro
How would you define the end of a macro? : sas-macro
Mention sas system options to debug sas macros.
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Explain bmdp procedure?
What are the functions which are used for character handling functions?
How do you debug and test your SAS programs?
What is data _null_?
Mention the validation tools used in SAS?
Mention the category in which sas informats are placed?
how are numeric and character missing values represented internally? : Sas programming
how does sas handle missing values in functions? : Sas programming
Differentiate between proc means and proc summary.
Give some examples where proc report’s defaults are same as proc print’s defaults?