Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between x=substr(name,1,2);
and substr(name,1,2)='x';
- 3 Answers
- 11926 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sattwik panda
x=substr(name,1,2) will return first two character of a string whereas substr(name,1,2)='x' will replace first two character by 'x'.
Please try using the code below to get an idea.
data test;
name="Sattwik";
x=substr(name,1,2);
substr(name,1,2)='x';
run;
x will have the first two characters of name:'Sa'.
substr(name,1,2)='x' will replace first two characters of "Sattwik". So, now the name will contain "xttwik".
| Is This Answer Correct ? | 46 Yes | 2 No |
Answer / oanhntt
x=substr(name,1,2) means you assign x value equal to the
first 2 characters of variable "name" while
substr(name,1,2)='x' just compare these fist 2 characters to
value 'x', so this seem useless without condition syntax
(correct one should be: if substr(name,1,2)='x' then /*do
some thing*/;).
| Is This Answer Correct ? | 4 Yes | 16 No |
I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak
How would you delete duplicate observations?
How do you define proc in sas? : sas-grid-administration
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
What is the Program Data Vector (PDV)? What are its functions?
If a variable contains letters or special characters, can it be numeric data type?
Why double trailing @@ is used in input statement?
where will go the observations that were deleted by delete statement?
How would you include common or reuse code to be processed along with your statements?
how to assign a macro value to a variable?
what is the difference between compiler and interpreter? give any one example (software product) that act as a interpreter?
36 Answers Accenture, College School Exams Tests, CTS, IBM, IHRD, Infosys, Sylhet Engineering College, TCS, Wipro,
How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.
Teradata 
