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 |
proc means? proc sort? proc append? proc freq? proc print? proc content?
what is syntax of proc merge ?
How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;
How to create an external dataset with sas code?
What are the new features included in the new version of SAS Programming Language?
What are the data types does SAS contain?
Identify statements whose placement in the DATA step is critical.
Explain data_null_?
what is the use of proc sql?
what are the three main credit bureau names
1 Answers Synchrony Financial,
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
What is the difference between using drop = data set option in data statement and set statement?