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

Mention what are the data types does SAS contain?

1155


What are all the problems you faced while validating tables and reports?

3478


Explain input and put function?

1147


What is SAS? What are the functions does it performs?

1201


What are the new features included in the new version of SAS Programming Language?

1214


What is PROC in SAS?

1059


Difference between SAS STATA & SPSS?

1128


What is PDV?

1162


where to use sas business intelligence? : Sas-bi

1093


Describe crosslist option in tables statement?

1227


What are the prime responsibilities of data integration administrator? : Sas-di

1074


what is the use of proc sql? : Sas programming

1137


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1264


Give some ways by which you can define the variables to produce the summary report (using proc report)?

1094


Name and describe few sas character functions that are used for data cleaning in brief.

1126