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
- 5280 Views
- I also Faced
- E-Mail Answers
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
How do you define proc in sas? : sas-grid-administration
where are dashboard components are created and maintained? : Sas-bi
How to include or exclude specific variables in a data set?
Explain the use of proc print and proc contents?
What is the order of application for output data set options, input data set options and SAS statements?
Are you involved in writing the inferential analysis plan? Tables specfications?
Give e an example of..
What are the difference between ceil and floor functions in sas?
What are common programming errors committed in sas
what are the types of interactive display types? : Sas-bi
Tell me more about the parameters in macro? : sas-macro
What is the difference between using drop = data set option in data statement and set statement?
Differentiate between format and informat? : sas-grid-administration
what is enterprise guide? What is the use of it? : Sas programming
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
