Dear all, I have a macro variable with a comma separated list of numbers: %let a = 1,2,3,4,5. I'd like to create a sas data set now with one var called id that has 5 rows of which one row contains one number from the comma separated list. Just like in: data myoutput; input id 1; datalines; 1 2 3 4 5 ; run; I though I could mybe do this: data myoutput; input id 1; datalines; &linebreaklist; run; And create the Makrovariable &linebreaklist like this: %let linebreaklist = %sysfunc(tranwrd(%str(1,2,3,4,5),%str(,),\n)); Of course with the above statement I get 1\n2\n3\n4\n5 But I'd like to have 1 2 3 4 5 Does anybody know how I'd have to specify the linebreak in the tranwrd() function? Best wishes Eva
... View more