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

Describe the ways in which you can create a macro variable?

1135


How to convert a numeric variable to a character variable?

1260


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

1673


what is SAS OPTIMIZATION?

2354


What is the sas data set? : sas-grid-administration

1031


where are dashboard components are created and maintained? : Sas-bi

1058


What is the role of sas grid administrator? : sas-grid-administration

1347


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2453


how does sas handle missing values in assignment statements? : Sas programming

1072


how does sas handle missing values in formats? : Sas programming

1193


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1546


What are the statements in proc sql?

1149


how many display types available in sas bi dashboard? : Sas-bi

1143


Are you sensitive to code walk-throughs peer review or QC review?

3200


what is program data vector? : Sas-administrator

1126