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
- 6742 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 |
What do you feel about hardcoding?
Why do we use QUIT commmand for proc datasets and proc sql ???
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
what are informats in sas? : Sas-administrator
Approximately what date is represented by SAS date value of 730
What is the difference between verification and validation?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
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?
Please write codes to merge two datasets and keep every record in the first dataset.
How would you code the criteria to restrict the output to be produced?
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
Teradata 
