Interested to Buy Any Domain ? << Click Here >> for more details...
We have a string like this "kannafromsalembut" ,from this i
want to get only "fromsal" (but one condition with out
using substring function)here we can not use scan because in
the given string there is no delimeter? so give ans without
out using substring ?
- 5 Answers
- 8155 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abcds
data _null_;
file print;
tranw = tranwrd('kannafromsalembut','kanna',' ');
tranw1 = tranwrd(tranw,'embut',' ');
tranw2 = strip(tranw1);
put tranw2= ;
run;
this is the correct one.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kumarravi123
One will get appreciate from our team members if u give
correct answer
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / ramkgupta
thank you abcds for correcting my small mistake.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nagmani
data p;
input @6 x$ 7.;
cards;
kannafromsalembul
;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
What is the purpose of the trailing and How would you use them?
Explain proc sort?
what is OLAP?
Describe the function and utility of the most difficult SAS macro that you have written?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
List down the reasons for choosing sas over other data analytics tools.
explain about various caches available in data integrator? : Sas-di
Which command is used to save logs in the external file?
Do you prefer Proc Report or Proc Tabulate? Why?
what do the pad and dim functions do? : Sas programming
For what purpose would you use the RETAIN statement?
Teradata 
