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.
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 SAS? What are the functions does it performs?
what are several options for creating reports in web report studio? : Sas-bi
what is business intelligence? : Sas-bi
how can you import .csv file in to sas? : Sas programming
Mention few capabilities of sas framework.
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What is run-group processing?
What is the difference between the proc sql and data step?
explain what is factor analysis? : Sas-administrator
what versions of sas have you used (on which platforms)? : Sas programming
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
Give e an example of..
name several ways to achieve efficiency in your program? : Sas programming
Define run-group processing?