Your code looks ok.
If your data is like you say there should be no problem.
I'm expecting to have below result:
Table tmp
Id Code Type
————————
1 A OK
2 A OK
3 B Fail
or at least below result if the code cannot be mapped:
Table tmp
Id Code Type
————————
1 A
2 A
3 B
But I just cannot understand why I can get below result (with Code value became all NULL)
Table tmp
Id Code Type
————————
1
2
3
Provide your data as a DATA Step.
See this post on how to do it:
Since your data is simple, you can write the DATA Step quite easy yourself, see example below
data tmp;
input
Id
Code $
;
cards;
1 A
2 A
3 B
;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.