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

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

0 Answers  

How do you connect the desktop application to metadata server? : sas-grid-administration

0 Answers  

what are scrubing procedures in SAS?

1 Answers   Oracle,

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

0 Answers  

CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

4 Answers   CybAge,

what are the new features included in the new version of SAS i.e., SAS9.1.3?

5 Answers   College School Exams Tests, Wockhardt,

How would you code the criteria to restrict the output to be produced?

9 Answers  

Give e an example of..

0 Answers  

what is sas? is a package or tool? give me introduction about sas?

11 Answers   Accenture,

How would you delete observations with duplicate keys?

6 Answers  

Can you excute a macro within a macro? Describe.

3 Answers  

what is the usage for assigning error=1 in a dataset ?

2 Answers   Satyam,

For more SAS Interview Questions Click Here
Categories