Answer / krish

data spdot;
set spec_char;
if count(name,'.') ge 1 then dot=".";
if count(name,'%') ge 1 then per="%";
if count(name,"-") ge 1 then iph= "-";
col=(dot || per ||iph);
run;proc print;run;

Answer / krish

data spdot;
set spec_char;
if count(name,'.') then dot=".";
if count(name,'%') then per="%";
if count(name,"-") then iph= "-";
col=(dot || per ||iph);
run;proc print;run;

what are methods to identify duplicate observations?

5 Answers   HCL,

---

We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?

5 Answers  

---

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

---

what is proc Index? and what is proc document?

0 Answers   Mind Tree,

---

what is the need of INDEX in datasets?

6 Answers   CitiGroup,

---

what is change analysis in sas di ? : Sas-di

0 Answers  

---

How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

0 Answers   Oracle,

---

where will go the observations that were deleted by delete statement?

2 Answers  

---

what is Business Intelligence?

3 Answers   CitiGroup,

---

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

2 Answers   Cap Gemini, L&T,

---

what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

3 Answers   Cap Gemini,

---

Can anyone help me about SAS Realtime scenarios in Clinical field

0 Answers  

---