Difference Between Scan and Substr
Answers were Sorted based on User's Feedback
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 |
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 |
What are the differences between sum function and using “+” operator?
what is program data vector? : Sas-administrator
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
What is the size of PDV?
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
what is the difference between nodup and nodupkey options? : Sas programming
what is AE onset date and what is RDS?
How do you put an elephant in the refrigerator?
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?
How to get part of string form the source string without using sub string function in SAS?
I have a dataset with variables empid and doj how to calculate retirement age?