Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8130 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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;
| Is This Answer Correct ? | 6 Yes | 2 No |
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;
| Is This Answer Correct ? | 5 Yes | 2 No |
how to write code for left outer join in SAs using datastep?
How do i read multiple spaces in datasets?
Under what circumstances would you code a SELECT construct instead of IF statements?
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 ?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Name and describe three SAS functions that you have used, if any?
how do you validate tables abd reports?
2 Answers Accenture, Quintiles,
i want to upload titles and footnotes to excel file?how it is possible?
Can we create datasets by proc step ? (Proc contents, Means)?
What is the role of sas grid administrator? : sas-grid-administration
How do you add a prefix to some or all variables in a dataset using a SAS macro?
what is sas data set?
Teradata 
