Hi,   I have written a code in base sas to extract all the words in a string/paragraph.   I want to create a macro for it. But I failed. Requesting help. Thanks   Below are the Codes which is successfully running and the macro code which is not. Please advise.   =======running========================================= data test; i = 1; word = 'I am using scan and index function in sas together and I got successful'; do while (find(word,scan(word,i),'t')>0); w = scan(word,i); output; i+1; end; keep w i; run; =============================================== ==========Error============================== %macro wordparsin(word); data test; i = 1; /* word = 'I am using scan and index function in sas together and I got successful'; */ %do %while (%find(&word,%scan(&word,i),'t')>0); w = %scan(&word,i); output; i+1; %end; keep w i; run; %mend; %wordparsin(I am using scan and index function in sas together); ========================================     ... View more

I want to create my dataset using macro which should have 10 variables (e.g. Var1 to Var10) and want to insert values using iteration. something like    Var1   Var2   Var3   Var4   Var5...........Var10 1         2         3        4        5   I want 1 2 3 4...10 using iteration  in dataline statement.   Code I tried is(which is not working):   %macro sqr_cub(iteration); data iteration(drop = j); infile datalines;   input var_1-Var_10; datalines; do j = 1 to &iteration.; x = j**2; output ; end; run; %Mend; %sqr_cub(10);   Please help ... View more