@anushagandla
If these are US states and you don't have to deal with typos as well then below code should do the job.
data have;
infile datalines dlm=',';
input states:$40. @@;
output;
datalines;
CT, NY, NJ, IL, AZ, CA,COLORADO, DELAWARE, FLORIDA, INDIANA
;
run;
proc sql;
create table cntlin_source as
select distinct
'StateToCode' as fmtname
, 'c' as type
, statename2 as start
, statecode as label
from
sashelp.zipcode
;
quit;
proc format cntlin=cntlin_source;
run;
data want;
set have;
state_codes=put(upcase(compress(states)),$StateToCode.);
run;
... View more