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
- 8139 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 are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
what is study design in while working with SAS? what are screening variables in SAS?
Describe the function and utility of the most difficult SAS macro that you have written?
what is slowly changing dimension? : Sas-di
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
how can you import .csv file in to sas? : Sas programming
how to debug and test the sas program? : Sas-administrator
How do you define proc in sas? : sas-grid-administration
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
How can you limit the variables written to output dataset in data step?
how can you put a "trace" in your program? : Sas programming
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Mention some common errors that are usually committed in sas programming.
explain about various caches available in data integrator? : Sas-di
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
