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
- 7891 Views
- Cap Gemini, L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mention the validation tools used in SAS?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
how to generate the test data in sas without input data? : Sas-administrator
How you can read the variables that you need?
Why double trailing @@ is used in input statement?
Mention common programming errors committed in sas ?
Mention the category in which sas informats are placed?
how to change the execute of macro
How do you use the do loop if you don’t know how many times you should execute the do loop?
Give some examples where proc report’s defaults are same as proc print’s defaults?
For clinical entire study how many tables will create approx?
Explain why double trailing @@ is used in input statement?
Explain how merging helps to combine data sets.
Describe a time when you were really stuck on a problem and how you solved it?
what is the purpose of _error_? : Sas programming
