Calculate the rank according to the marks in ascending order and if an

1.	Calculate the rank according to the marks in ascending order and if any marks value is repeated the rank should be the same for both.
Answer» The PAD OPTION can be used to READ the source data having the variable length RECORDS, so to read the variable length of records we can USE the PAD option, the PAD option can be used with the infile statement; example data Test; infile 'C:\Users\Anshu\Desktop\test.txt' PAD; input @1name $6. @10 sex $1. @12 marks 3. @14 salary 8.; run; proc print data=Test; run;

Calculate the rank according to the marks in ascending order and if any marks value is repeated the rank should be the same for both.

Answer»

The PAD OPTION can be used to READ the source data having the variable length RECORDS, so to read the variable length of records we can USE the PAD option, the PAD option can be used with the infile

statement;

example

data Test; infile 'C:\Users\Anshu\Desktop\test.txt' PAD; input @1name $6. @10 sex $1. @12 marks 3. @14 salary 8.; run; proc print data=Test; run;

Discussion

No Comment Found

Related InterviewSolutions

What are the different joins in proc SQL and unlike data step why SQL don’t require sorting before joins?
What is a monotonic function and how useful is it?
What is intnx function and how powerful it is?
What is reverse function in sas?
How to count missing value in SAS?
What is N function in sas?
How to concatenate multiple variables in a single variable through SAS?
How to create a numeric date if month Year and day is given through SAS?
Write a macro that shows the use of symget in an if condition.
What are the different ways to handle a case in sas?

Calculate the rank according to the marks in ascending order and if any marks value is repeated the rank should be the same for both.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment