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
- 8023 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
how sas deals with business intelligence? : Sas-bi
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
explain the key concept of sas? : Sas-administrator
how to do user inputs and command line arguments in sas?
how will you locate the sas platform applications? : Sas-bi
what is broad cast agent? : Sas-bi
why is sas considered self-documenting? : Sas programming
What is program data vector (pdv)?
where to use sas business intelligence? : Sas-bi
What is the sas data set? : sas-grid-administration
which date function advances a date, time or datetime value by a given interval? : Sas programming
How do you use the do loop if you don’t know how many times you should execute the do loop?
Which function is used to count the number of intervals between two sas dates?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
Explain the difference between informat and format with an example.
