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.

Answers were Sorted based on User's Feedback



here is a string like chq.2312244%4452- from that i want only special characters in a column. do..

Answer / krish

data spdot;
set spec_char;
if count(name,'.') ge 1 then dot=".";
if count(name,'%') ge 1 then per="%";
if count(name,"-") ge 1 then iph= "-";
col=(dot || per ||iph);
run;proc print;run;

Is This Answer Correct ?    6 Yes 2 No

here is a string like chq.2312244%4452- from that i want only special characters in a column. do..

Answer / 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

More SAS Interview Questions

How many ways to overcome a missing values???

0 Answers   HSBC,


Mention what is PROC in SAS?

0 Answers  


explain the proc in sas? : Sas-administrator

0 Answers  


What are the difference between ceil and floor functions in sas?

0 Answers  


what other SAS features do you use for error trapping and data validation?

3 Answers   Quintiles,


Mention the validation tools used in SAS?

0 Answers  


How to test the debugging in sas?

0 Answers  


How do you add a number to a macro variable? : sas-macro

0 Answers  


What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?

8 Answers  


Name and describe few sas character functions that are used for data cleaning in brief.

0 Answers  


What is the difference between reading data from an external file and reading data from an existing data set?

0 Answers  


how do you debug and test your sas programs? : Sas programming

0 Answers  


Categories