Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 8010 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
explain what is factor analysis? : Sas-administrator
What are the main differences between sas versions 8.2, 9.0, 9.1?
What is the difference between %local and %global? : sas-macro
what is the difference between SET and MERGE?
What is the order of application for output data set options, input data set options and SAS statements?
How would you define the end of a macro?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Differentiate between format and informat? : sas-grid-administration
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
How substr function works in sas?
what can you learn from the sas log when debugging? : Sas programming
6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK
Teradata 
