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
- 8012 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
What is your favorite all time computer book? Why?
Explain translate function?
How do you specify the number of iterations and specific condition within a single do loop?
explain what is data set in sas? : Sas-administrator
Can you execute a macro within a macro? Describe. : sas-macro
How long can a macro variable be? A token? : sas-macro
why is sas data integration studio important? : Sas-di
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
How do you test for missing values?
Explain how merging helps to combine data sets.
Name any two sas spawners? : sas-grid-administration
for what purpose would you use the retain statement? : Sas programming
Explain the difference between informat and format with an example.
what is change analysis in sas di ? : Sas-di
What is run-group processing?
