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?
Answers were Sorted based on User's Feedback
Answer / alok karan
data repeat;
x="ramu anji ramu azad ramu";
y=count(x,"ramu");
run;
proc print data=repeat;
run;
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / vivek
Data DS;
INFILE datalines;
input name $;
datalines;
ram
sham
seema
amit
sham
sushil
amit
seema
ravi
run;
proc freq data = ds;
table name;
output out =dsfrq;
run;
| Is This Answer Correct ? | 1 Yes | 2 No |
Can anyone help me about SAS Realtime scenarios in Clinical field
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
What is a pdv and what are its functions?
What is proc sql pass through facility?
Which command is used to save logs in the external file?
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
How can you put a "trace" in your program?
What are the default statistics that proc means produce?
What is the purpose of trailing @ and @@? How do you use them?
What are the joins,types of joins and thier functions?
what is SAS ACCESS AND SAS CONNECT ? Give an example and data statements used.