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 / ashish
data op;
set qqq end=last;
if _n_=1 or last=1 then output;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is data _null_?
List down the reasons for choosing sas over other data analytics tools.
What are the different versions of sas that you have used until now? : sas-grid-administration
What are the default statistics for means procedure?
What is substr function?
what do you mean by data staging area? : Sas-di
What are the difference between sas functions and procedures?
what is metadata? : Sas-bi
Do you need to rearrange the order of the data for the report?
What are the differences between sum function and using “+” operator?
how can you put a "trace" in your program? : Sas programming
How do you add a number to a macro variable? : sas-macro
What are the different servers in sas? : sas-grid-administration
How many data types are there in SAS?
what is data governance? : Sas-di