Dears, I am new to sas so please accept my appologies if you feel the question is a little too basis. Here is the problematic I am facing: I am currently working with a fairly large dataset wich contains a column with an extended key or longkey variable. The longkey variable is always the concatenation of a prefix, a short key and a suffix. To a short key always corresponds a single longkey, i.e the associated prefix and suffix only depend on the short key. Here is a sample dataset: data longKeys;
input @1 longkey $14.
@16 value 8.;
datalines;
HLKB_key7_BEGO 80926681
KGEH_key4_HLQB 88209836
KGEH_key9_HLQB 94053433
CHOA_key6_ABKQ 82703104
CHOA_key3_ABKQ 92174044
CHOA_key3_ABKQ 35849309
ABCD_key0_DFHG 17346360
CHOA_key6_ABKQ 28834207
ABCD_key0_DFHG 23090564
QOAG_key2_GCBL 74019736
KGEH_key4_HLQB 19951212
HLKB_key7_BEGO 11353465
CHOA_key3_ABKQ 33063093
CHOA_key1_ABKQ 28276788
QOAG_key2_GCBL 29987914
HLKB_key5_BEGO 07296540
CHOA_key3_ABKQ 74638169
CHOA_key3_ABKQ 71900903
ABCQ_key8_QOHG 90651346
CHOA_key3_ABKQ 48446188
KGEH_key9_HLQB 64205650
ABCD_key0_DFHG 58012348
HLKB_key7_BEGO 73923915
KGEH_key4_HLQB 97173720
QOAG_key2_GCBL 51450320
ABCQ_key8_QOHG 56699883
CHOA_key1_ABKQ 64852517
QOAG_key2_GCBL 74892582
HLKB_key7_BEGO 08070758
CHOA_key3_ABKQ 46544906
CHOA_key3_ABKQ 22765177
ABCQ_key8_QOHG 36334812
ABCQ_key8_QOHG 78318514
KGEH_key4_HLQB 17058785
HLKB_key7_BEGO 15515760
ABCQ_key8_QOHG 55507915
HLKB_key5_BEGO 74279902
ABCD_key0_DFHG 52472477
ABCD_key0_DFHG 52305871
CHOA_key3_ABKQ 49451187
ABCQ_key8_QOHG 59462988
CHOA_key3_ABKQ 08492549
HLKB_key7_BEGO 02140768
QOAG_key2_GCBL 36946856
QOAG_key2_GCBL 50707226
; What I am trying to do is reconstruct the mapping table between the list of short keys and the list of long keys, by reading the longkey variable. The expected answer should be as below. Any idea how this could be effeciently implemented in SAS? In advance, many many thanks for your help...
... View more