Hi all, I have a problem. So I wanted to do a macro which imports a txt file into sas. The txt contains random words in one line. So basically I want to do is that put them into one column. My method would do it, but it's keep saying ERROR. The ERROR: "NOTE: Invalid data for words in line 12 1-4. 12 down, 5 words=. _ERROR_=1 _N_=12" and so on. Or it just doesn't show any words. Just a '.' Here is my code: %macro wordfreq(x);
data test.wrd;
infile "D:\Munka\&x..txt"
DLM=',';
input words;
run;
%mend;
%wordfreq(wrd);
The txt contains:
random, words, coming, up, right, now, here, random, words, here, coming, down, up, word, coming, random, way Thank you for your help! ps.: My main tast is to do a freq macro which group the same words and show the frequency of each ones. 🙂
... View more