Answer / alok karan

data repeat;
x="ramu anji ramu azad ramu";
y=count(x,"ramu");
run;
proc print data=repeat;
run;

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;

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;

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

0 Answers   Satyam,

---

Which is the best training Institute for SAS Business Intelligence course?

6 Answers  

---

How would you delete observations with duplicate keys?

13 Answers   Accenture,

---

which date functions advances a date time or date/time value by a given interval? : Sas programming

0 Answers  

---

HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?

1 Answers   TCS,

---

how many types prompting framework can be broken down to? : Sas-bi

0 Answers  

---

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

1 Answers   Emerio,

---

Have you used macros? For what purpose you have used? : sas-macro

0 Answers  

---

What report output formats can you generate using SAS?

3 Answers   Accenture,

---

Name and describe few sas character functions that are used for data cleaning in brief.

0 Answers  

---

We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B

3 Answers  

---

What are the scrubbing procedures in sas?

0 Answers  

---