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 are the different servers in sas? : sas-grid-administration
How do you convert basic cube to transaction cube and transaction cube to basic cube?
what is proc Index? and what is proc document?
What is substr function?
How you can read the variables that you need?
What is the use of function Proc summary?
What is the maximum length of the macro variable? : sas-macro
Explain data_null_?
Difference between SAS STATA & SPSS?
what is the function of catx syntax? : Sas-administrator
What do you code to create a macro? : sas-macro
How would you define the end of a macro? : sas-macro
what are the categories that sas informats are used to the place the data? : Sas-administrator
What are the differences between proc means and proc summary?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?