Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is data _null_?

1077


List down the reasons for choosing sas over other data analytics tools.

1213


What are the different versions of sas that you have used until now? : sas-grid-administration

1272


What are the default statistics for means procedure?

1167


What is substr function?

1116


what do you mean by data staging area? : Sas-di

1064


What are the difference between sas functions and procedures?

1068


what is metadata? : Sas-bi

968


Do you need to rearrange the order of the data for the report?

2252


What are the differences between sum function and using “+” operator?

1031


how can you put a "trace" in your program? : Sas programming

1004


How do you add a number to a macro variable? : sas-macro

952


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

1006


How many data types are there in SAS?

1005


what is data governance? : Sas-di

970