Write a SAS macro to calculate number of numbers in an
email address
Answers were Sorted based on User's Feedback
Answer / dey
%macro logic(email=);
data _null_;
length EMAIL $50;
Email=&email;
retain count 0;
do i = 1 to length(EMAIL);
if missing(substr(EMAIL,i,1)*1)=0 then
COUNT= COUNT +1;
end;
call symput('count',count);
RUN;
%put &count;
%mend logic;
%logic(email='dey_anurup123444@yahoo.12co.in')
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / naresh
Use compress function and remove characters and special characters then you will get digits.. Now find the length of the string...
| Is This Answer Correct ? | 0 Yes | 0 No |
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process
How we can call macros with in data step? : sas-macro
How substr function works in sas?
Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT
Describe crosslist option in tables statement?
What are SAS/ACCESS and SAS/CONNECT?
how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too
Explain the use of proc print and proc contents?
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?