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
- 6729 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 about sas business intelligence? : Sas-bi
what is sas metadata server? : Sas-di
What would you change about your job?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What are the data types that sas contain?
For what purposes have you used sas macros? : sas-macro
What is the use of the %include statement?
How sas treats the dsd delimiters?
What are the applications primarily used by business analyst? : Sas-bi
why a stop statement is needed for the point= option on a set statement?
Can you execute a macro within a macro? Describe. : sas-macro
Why double trailing @@ is used in input statement?
How do you specify the number of iterations and specific condition within a single do loop?
Name some categories in sas 9? : sas-grid-administration
What is the basic syntax style in SAS?
