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
- 8127 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum length of the macro variable?
How to convert a numeric variable to a character variable?
how many types prompting framework can be broken down to? : Sas-bi
Hi, If anyone has base SAS certification dumps, please share.
In sas admin differentiate between roles and capabilities? : sas-grid-administration
What versions of SAS have you used (on which platforms)?
what is broad cast agent? : Sas-bi
Which function is used to count the number of intervals between two sas dates?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
what is data access? : Sas-di
what are the scrubbing procedures in sas? : Sas programming
what is the use of sas management console? : Sas-di
what is the purpose of _error_? : Sas programming
what are informats in sas? : Sas-administrator
List down the reasons for choosing sas over other data analytics tools.
