Hello, All I have following code (which is very similar to my real work): %let string=0=Emergency Services, 1=Tele Call, 2=Cusstomet Answer, 3=TAB, 4=Ptt Mute Voice, 5=Com User Voice Control, 6=Com System User Call, 7=ABC, 8=Disc, 9=XYZ, 10=Exe News, 11=ABC Ext Source, 12=MNGFR Com and BFC MUYH, 13=Not Req; data test; infile cards delimiter="=," ;     length var $ 30;     input @@;     _infile_ = resolve(_infile_);     input var @@; cards; &string ; proc print data=test; run; The code runs ok; however the result is kind of strange; there is only 10 rows in the result: Obs var   1 0   2 Emergency Services   3 1   4 Tele Call   5 2   6 Cusstomet Answer   7 3   8 TAB   9 4 10 Ptt Mute Voice Why does the code stop reading at Ptt Mute Voice ? ... View more

Hello, All I have following codes: %let string=%str(cards; 1 2 3 4); data test;         input var @@;         &string     ; proc print data=test; run; I am expecting it will work as: data test; input var @@; cards; 1 2 3 4 ; However, it doesn't work. How should I re-write the code to make it work? Thanks. ... View more

Dear All Suppose I have following two datasets, test1 and test2: data test1; input key1 $ value1; cards; ABC 8 XYZ  9 ; data test2; input key2 $ value2; cards; ABC1 88 XYZ1  99 ABC2 888 XYZ2  999 ; I want to join the two datasets based on SIMILARITY between key1 and key2; such as: proc sql; create table test as select a.key1 as key,          b.key2 as key_alias,          a.value1 as value1,          b.value2 as value2 from test1 a        inner join        test2 b on a. value1 SIMILAR TO b.value2; quit; The desired result would be: KEY   KEY_ALIAS VALUE1  VALUE2 ABC    ABC1          8             88 ABC    ABC2          8             888 XYZ     XYZ1           9             99 XYZ     XYZ2           9             999 My question is: how should I write the sql statement (the one that is colored red)? ... View more

Hello, I have following codes: data test; input var $; cards; BACABBAD ; data test; set test; position=index(var,"A"); run; here, position=2, which is the position of first "A" in the string. Now, my question is: how can I get the position of third (or second, fourth, ...) "A" in the string? ... View more