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 r the job openings SAS for fresher graduates !
Explain proc sort?
Explain the use of proc gplot? : sas-grid-administration
How would you include common or reuse to be processed along with your statements?
What is interleaving in SAS?
What is the work of tranwrd function?
how can you put a "trace" in your program? : Sas programming
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
If a variable contains only numbers, can it be a character data type?
Are you involved in writing the inferential analysis plan? Tables specfications?
what do the pad and dim functions do? : Sas programming
what is treatment emergent events and treatment emregent adverse event
What are the difference between sas functions and procedures?
In SAS explain which statement does not perform automatic conversions in comparisons?
what is sas and what are the functions? : Sas-administrator