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.
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
How is character variable converted into numeric variable and vice versa?
Mention common programming errors committed in sas ?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
What are the features of base sas system?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
What are the default statistics that proc means produce?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What is interleaving in SAS?
what is factor analysis? : Sas-administrator
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
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 would you include common or reuse to be processed along with your statements?
Which statement does not perform automatic conversions in comparisons?
How would you invoke a macro? : sas-macro
What is the basic structure of the SAS base program?