you have a data set like this.
data qqq;
input name $ total;
cards;
qq 22
ww 33
qq 22
ee 44
rr 33
ww 44
;
run;
and you want output like this.........
name total
qq 22
ww 44
Do it by data set step.
Answer Posted / bharath
data abc1;
set qqq end=a;
if _n_=1 or a=1;
proc print data=abc1;
run;
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Given an unsorted data set, how to read the last observation to a new data set?
explain the concepts and capabilities of business object? : Sas-bi
What are the different servers in sas? : sas-grid-administration
What is the basic structure of the SAS base program?
What are all the problems you faced while validating tables and reports?
Explain proc sort?
Which are the statements whose placement in the data step is critical?
what is metadata? : Sas-bi
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
how does sas handle missing values in functions? : Sas programming
describe how to adjust the performance of data integrator? : Sas-di
Do you need to rearrange the order of the data for the report?
What is SAS? What are the functions does it performs?
Can you execute a macro within a macro? Describe. : sas-macro
For clinical entire study how many tables will create approx?