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...

i have a dataset with 25 obs; 10th obs has like
ramu,anji,ramu,azad,ramu like this. i want to know how many
times the word repeats in that obs?

Answer Posted / aarti

Data DS;
INFILE datalines;
input name $;
datalines;
ram
sham
seema
amit
sham
sushil
amit
seema
ravi
run;
proc sql;
create table rep as
select name,count(name) as cnt from ds group by 1;
quit;
proc print data=rep;

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you execute a macro within a macro? Describe. : sas-macro

1096


What is maximum number of rows and cols can be handled in SAS?

1555


Tell e how how dealt with..

2210


What is the order of application for output data set options, input data set options and SAS statements?

1539


explain about sas business intelligence? : Sas-bi

1118


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2741


What is the difference between class statement and by statement in proc means?

1264


what are the considerations when picking a SAS/STAT procedure?

3350


explain the key concept of sas? : Sas-administrator

983


name several ways to achieve efficiency in your program? : Sas programming

1042


What is connection profile? : sas-grid-administration

1152


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1213


how would you determine the number of missing or nonmissing values in computations? : Sas programming

1125


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1268


How can you limit the variables written to output dataset in data step?

1305