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 do the pad and dim functions do? : Sas programming
Do you need to know if there are any missing values?
Explain the difference between using drop = data set option in set and data statement?
why a stop statement is needed for the point= option on a set statement?
Mention common programming errors committed in sas ?
What is the order of application for output data set options, input data set options and SAS statements?
What is the difference between proportion and average?
Which date function advances a date, time or datetime value by a given interval?
what is null hypothesis? why do you consider that?
what is program data vector? : Sas-administrator
Describe the ways in which you can create a macro variable?
How to create a permanent sas data set?
explain the difference between proc means and proc summary?
Which function is used to count the number of intervals between two sas dates?
Are you involved in writing the inferential analysis plan? Tables specfications?