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
What is SAS? What are the functions does it performs?
What are the differences between proc means and proc summary?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
What is the purpose of _character_ and _numeric_?
How do you connect the desktop application to metadata server? : sas-grid-administration
What would be the value of month at the end of data step execution and how many observations would be there?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
I need level 2 to 5 sas using companies in india
Give e an example of..
How would you determine the number of missing or nonmissing values in computations?
What is the difference between proportion and average?
What are the 3 components in sas programming?
What are the new features included in the new version of SAS Programming Language?
How would you identify a macro variable? : sas-macro