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


Please Help Members By Posting Answers For Below Questions

What are the different servers in sas? : sas-grid-administration

598


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1770


what is proc Index? and what is proc document?

1994


What is substr function?

623


How you can read the variables that you need?

651






What is the use of function Proc summary?

651


What is the maximum length of the macro variable? : sas-macro

617


Explain data_null_?

609


Difference between SAS STATA & SPSS?

676


what is the function of catx syntax? : Sas-administrator

643


What do you code to create a macro? : sas-macro

576


How would you define the end of a macro? : sas-macro

606


what are the categories that sas informats are used to the place the data? : Sas-administrator

611


What are the differences between proc means and proc summary?

599


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1096