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...

  1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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.

Question Posted / ram

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 would you include common or reuse to be processed along with your statements?

0 Answers  

what is the primary variable in your study?

3 Answers   Accenture,

who is the best SAS clinical Trainer in Hyderabad?

3 Answers  

What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

2 Answers   Accenture,

what has been your most common programming mistake? : Sas programming

0 Answers  

what is proc Index? and what is proc document?

0 Answers   Mind Tree,

What are the implications?

0 Answers   Quintiles,

What is the order of evaluation of the comparison operators: + - * /** ()?

3 Answers   Quintiles,

In ARRAY processing, what does the DIM function do?

0 Answers  

explain the key concept of sas? : Sas-administrator

0 Answers  

What is highest missing value for numeric?

1 Answers  

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 Answers  

For more SAS Interview Questions Click Here
Categories