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
Mention what are the data types does SAS contain?
What are all the problems you faced while validating tables and reports?
Explain input and put function?
What is SAS? What are the functions does it performs?
What are the new features included in the new version of SAS Programming Language?
What is PROC in SAS?
Difference between SAS STATA & SPSS?
What is PDV?
where to use sas business intelligence? : Sas-bi
Describe crosslist option in tables statement?
What are the prime responsibilities of data integration administrator? : Sas-di
what is the use of proc sql? : Sas programming
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
Give some ways by which you can define the variables to produce the summary report (using proc report)?
Name and describe few sas character functions that are used for data cleaning in brief.