Example :
Data Test_Sample;
set Test;
employeedept = SUBSTR(dept,1,5);
run;
Result
employeedept
MATH
HINDI
I have dept 'SC' also with 2 bytes. Can if else statement work here?
some thing like:
Data Test_Sample;
set Test;
employeedept = SUBSTR(dept,1,5);
If employeedept = SUBSTR(dept,1,2)...