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,'.') 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
Explain what is the use of proc gplot?
explain what is data set in sas? : Sas-administrator
What is the difference between %put and symbolgen? : sas-macro
how would you create multiple observations from a single observation? : Sas programming
what do you mean by data staging area? : Sas-di
What is maximum number of rows and cols can be handled in SAS?
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 to read the variables in sas? : Sas-administrator
Approximately what date is represented by the SAS date value of 730?
What is the difference between the proc sql and data step?
How we can call macros with in data step? : sas-macro
What are the differences between proc means and proc summary?
What are symget and symput? : sas-macro
If a variable contains letters or special characters, can it be numeric data type?
Differentiate between format and informat? : sas-grid-administration