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
Can you execute a macro within a macro? Describe. : sas-macro
What is maximum number of rows and cols can be handled in SAS?
Tell e how how dealt with..
What is the order of application for output data set options, input data set options and SAS statements?
explain about sas business intelligence? : Sas-bi
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What is the difference between class statement and by statement in proc means?
what are the considerations when picking a SAS/STAT procedure?
explain the key concept of sas? : Sas-administrator
name several ways to achieve efficiency in your program? : Sas programming
What is connection profile? : sas-grid-administration
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
how would you determine the number of missing or nonmissing values in computations? : Sas programming
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
How can you limit the variables written to output dataset in data step?