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 / 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 |
Post New Answer View All Answers
What do the PUT and INPUT functions do?
What is PDV?
What can you learn from the SAS log when debugging?
what are _numeric_ and _character_ and what do they do? : Sas programming
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
What are the features of SAS?
how do the in= variables improve the capability of a merge? : Sas programming
what type of graphs we will create(for 2+years candidates)?
Which date function advances a date, time or datetime value by a given interval?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
what is sas business intelligence? : Sas-bi
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
What is the function of output statement in a SAS Program?
what is treatment emergent events and treatment emregent adverse event
Explain the main difference between the sas procedures and functions? : Sas-administrator