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 / vishal

proc sort data=qqq;
by name;
run;

data f;
set qqq;
by name;
if first.name=0;
run;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are numeric and character missing values represented internally?

1605


Explain what is the use of proc gplot?

1124


What are the 3 components in sas programming?

1150


what is ae onset date n what is RDS

2461


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3529


For clinical entire study how many tables will create approx?

1905


How do you debug and test your SAS programs?

1501


is data integration and etl programming is same? : Sas-di

1008


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

942


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

1045


explain about various caches available in data integrator? : Sas-di

993


Which command is used to perform sorting in sas program?

987


What is the purpose of trailing @ and @@? How do you use them?

980


What are the ways to do a “table lookup” in sas?

976


In proc transpose and data step with arrays which one you pick?

3040