Need help in SAS code

[Steward007]

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) then 'SC';
else MATH or HINDI;
run;

Please help me with your inputs.

 

[ChrisW75]

What are you actually trying to do?

Your If... then.. construction seems wrong, looks more like a CASE statement construction from SQL.

Chris.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.