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 are the statements that are executed only?
What do the PUT and INPUT functions do?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Explain the main difference between the sas procedures and functions? : Sas-administrator
why a stop statement is needed for the point= option on a set statement?
explain about sas business intelligence? : Sas-bi
Explain the difference between informat and format with an example.
Name few SAS functions?
Are you involved in writing the inferential analysis plan? Tables specifications?
Tell e how how dealt with..
how to debug and test the sas program? : Sas-administrator
what is data integration? : Sas-di
What are the uses of sas?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?