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


Difference Between Scan and Substr

Answers were Sorted based on User's Feedback



Difference Between Scan and Substr..

Answer / yachna

There is only one difference between Scan & Substr..Just look at below example

eg. String = rajesh chauhan
   If we want first four letter of the string then we can use Substr function here not scan..Scan function can pick first word.
  SubName=Substr(String,1,4);
  ScanName=Scan(String,1,' ');

      Subname = raje
      ScanName=rajesh

Is This Answer Correct ?    18 Yes 1 No

Difference Between Scan and Substr..

Answer / sudhir kumar

Both are function scan function Extracts nth position word
from string separated key dlm if n is -ve then starts at
end. and substr function extracts char string from start
position and with length .

Is This Answer Correct ?    9 Yes 0 No

Post New Answer

More SAS Interview Questions

What are the differences between sum function and using “+” operator?

0 Answers  


what is program data vector? : Sas-administrator

0 Answers  


what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,


libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 Answers  


What is the size of PDV?

2 Answers   L&T,


How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...

7 Answers  


what is the difference between nodup and nodupkey options? : Sas programming

0 Answers  


what is AE onset date and what is RDS?

4 Answers   Accenture,


How do you put an elephant in the refrigerator?

6 Answers   Oracle,


I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?

6 Answers  


How to get part of string form the source string without using sub string function in SAS?

3 Answers  


I have a dataset with variables empid and doj how to calculate retirement age?

1 Answers  


Categories