Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

what r the job openings SAS for fresher graduates !

2391


Explain proc sort?

1027


Explain the use of proc gplot? : sas-grid-administration

927


How would you include common or reuse to be processed along with your statements?

2315


What is interleaving in SAS?

1062


What is the work of tranwrd function?

1178


how can you put a "trace" in your program? : Sas programming

1002


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2053


If a variable contains only numbers, can it be a character data type?

1032


Are you involved in writing the inferential analysis plan? Tables specfications?

2172


what do the pad and dim functions do? : Sas programming

959


what is treatment emergent events and treatment emregent adverse event

2325


What are the difference between sas functions and procedures?

1068


In SAS explain which statement does not perform automatic conversions in comparisons?

1261


what is sas and what are the functions? : Sas-administrator

930