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 data types does SAS contain?
which date function advances a date, time or datetime value by a given interval? : Sas programming
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation
What is maximum number of rows and cols can be handled in SAS?
Which statement does not perform automatic conversions in comparisons?
what is study design in while working with SAS? what are screening variables in SAS?
what are some differences between proc summary and proc means? : Sas programming
List down the reasons for choosing sas over other data analytics tools.
How would you identify a macro variable?
What can be the size of largest dataset in SAS?
What are the features of base sas system?
What do the SAS log messages "numeric values have been converted to character" mean?
Describe the ways in which you can create macro variables?