I have bunch of character values that I need to use to filter data. Below is my code. proc sql; select distinct abc into :def separated by "," from work.table1 where abc is not null; quit; /* making a macro */ data _null_; call symput('test',"&def."); run; Below is what I get. 'C0003923','00003953','C0003952','00004014','00003931','C0003930','00004821','00004426','00004427','C0004425','00 004429','00004430','C0004428','00004621','00001953','00001954','C0001952','00005850','00005851','C0005849','C0002034','0 2 The SAS System 10:26 Tuesday, June 28, 2016 0002035','C0002048','00002049','C0002306','C0002658','00002659' WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 0002035','C0002048','00002049','C0002306','C0002658','00002659' '00000302','00000301','C0000300','00000418','00000417','C0000416','00002145',.... As you can see, it does not put "," after the value '00002659' I know it has something to do with the length of the string. but do not know what to do with it. Please help. Thanks
... View more