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
- 8125 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the use of proc gplot? : sas-grid-administration
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
How do you specify the number of iterations and specific condition within a single do loop?
What would be the value of month at the end of data step execution and how many observations would be there?
what are the component of range? : Sas-bi
what is the use of sas management console? : Sas-di
What is the purpose of _character_ and _numeric_?
Explain the purpose of substr functions in sas programming.
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
explain the difference between proc means and proc summary?
What is the length assigned to the target variable by the scan function?
Explain by-group processing?
What is the use of function Proc summary?
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
What are pdv and it functions?
