98.MACRO FUNCTIONS | %INDEX | %SUBSTR | %SCAN | %LOWCASE | %UPCASE

MACRO FUNCTIONS | %INDEX | %SUBSTR | %SCAN | %LOWCASE | %UPCASE 

%LET A=RAMA SHANKAR VARAPRASDARAO;

%LET B=%INDEX(&A,SHANKAR);

%PUT NAME &B;

%PUT &A;

LOG:

3    %PUT NAME &B;

NAME 6

4    %PUT &A;

RAMA SHANKAR VARAPRASDARAO

%LET A=SHIVA SHANKARA VARAPRASADARAO SURAKANTI;

%LET B=%SUBSTR(&A,15,4);

%LET C=%SUBSTR(&A,7);

%PUT &A;

%PUT &B;

%PUT &C;

LOG:

8    %PUT &A;

SHIVA SHANKARA VARAPRASADARAO SURAKANTI

9    %PUT &B;

VAR

10   %PUT &C;

SHANKARA VARAPRASADARAO SURAKANTI

%LET A=SHIVA SHANKARA VARAPRASADARAO SURAKANTI;

%LET B=%SCAN(&A,-2);

%PUT &B;

%PUT &A;

LOG:

13   %PUT &B;

VARAPRASADARAO

14   %PUT &A;

SHIVA SHANKARA VARAPRASADARAO SURAKANTI

%LET A=RaNGA rao bhuphaThi;

%LET B=LaXmipATHI NarayANraO oRaganTI;

PROC PRINT DATA=SASHELP.CLASS;

TITLE %LOWCASE (&A);

FOOTNOTE %UPCASE (&B);

RUN;

OUTPUT:            

ranga rao bhuphathi

Obs	Name	Sex	Age	Height	Weight
1		M	12	57.3	83.0
2		M	12	59.0	99.5
3		F	13	56.5	84.0
4		F	15	66.5	112.0
5	Alfred	M	14	69.0	112.5
6	Alice	F	13	56.5	84.0
7	Barbara	F	13	65.3	98.0
8	Carol		14	62.8	102.5
9	Carol	F	14	62.8	102.5
10	Henry	M	14	63.5	102.5
11	James	M	12	57.3	83.0
12	Jane	F	12	59.8	84.5
13	Janet	F	15	62.5	112.5
14	Jeffrey	M	13	62.5	84.0
15	John	M	12	59.0	99.5
16	Joyce	F	11	51.3	50.5
17	Judy		14	64.3	90.0
18	Judy	F	14	64.3	90.0
19	Louise	F	12	56.3	77.0
20	Mary	F	15	66.5	112.0
21	Philip	M	16	72.0	150.0
22	Robert	M	12	64.8	128.0
23	Ronald	M	15	67.0	133.0
24	Thomas	M	11	57.5	85.0
25	William	M	15	66.5	112.0

LAXMIPATHI NARAYANRAO ORAGANTI

TRY AND COMMENT YOUR CODE...

-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM  CHANNEL FOR MORE UPDATES

   CLICK HERE : https://t.me/SasAll4You