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 do the pad and dim functions do? : Sas programming

1031


Do you need to know if there are any missing values?

1041


Explain the difference between using drop = data set option in set and data statement?

1159


why a stop statement is needed for the point= option on a set statement?

1082


Mention common programming errors committed in sas ?

1131


What is the order of application for output data set options, input data set options and SAS statements?

1562


What is the difference between proportion and average?

3339


Which date function advances a date, time or datetime value by a given interval?

1156


what is null hypothesis? why do you consider that?

2906


what is program data vector? : Sas-administrator

1080


Describe the ways in which you can create a macro variable?

1085


How to create a permanent sas data set?

1245


explain the difference between proc means and proc summary?

1130


Which function is used to count the number of intervals between two sas dates?

1133


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

2227