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
Describe the ways in which you can create a macro variable?
How to convert a numeric variable to a character variable?
What is maximum number of rows and cols can be handled in SAS?
what is SAS OPTIMIZATION?
What is the sas data set? : sas-grid-administration
where are dashboard components are created and maintained? : Sas-bi
What is the role of sas grid administrator? : sas-grid-administration
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how does sas handle missing values in assignment statements? : Sas programming
how does sas handle missing values in formats? : Sas programming
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What are the statements in proc sql?
how many display types available in sas bi dashboard? : Sas-bi
Are you sensitive to code walk-throughs peer review or QC review?
what is program data vector? : Sas-administrator