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 is SAS? What are the functions does it performs?

1192


what are several options for creating reports in web report studio? : Sas-bi

1149


what is business intelligence? : Sas-bi

1062


how can you import .csv file in to sas? : Sas programming

1092


Mention few capabilities of sas framework.

1174


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1232


what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1148


What is run-group processing?

1153


What is the difference between the proc sql and data step?

1170


explain what is factor analysis? : Sas-administrator

1111


what versions of sas have you used (on which platforms)? : Sas programming

1068


I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1749


Give e an example of..

2095


name several ways to achieve efficiency in your program? : Sas programming

1062


Define run-group processing?

1035