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
- 8135 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How many ways to overcome a missing values???
Mention what is PROC in SAS?
explain the proc in sas? : Sas-administrator
What are the difference between ceil and floor functions in sas?
what other SAS features do you use for error trapping and data validation?
Mention the validation tools used in SAS?
How to test the debugging in sas?
How do you add a number to a macro variable? : sas-macro
What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?
Name and describe few sas character functions that are used for data cleaning in brief.
What is the difference between reading data from an external file and reading data from an existing data set?
how do you debug and test your sas programs? : Sas programming
Teradata 
