Hello everyone,   I have a made a Word cloud in SAS VA and there is a warning that only the 100 most frequent words are used for the cloud. Which is nice as this is what I told SAS to do. But now I am stuck with this warning, and it even exports to PDF, and I cannot really show that to someone. Is there any way to hide the warning?   Thanks a lot for your help   ... View more

Hello everyone,   I have several data sets that all contain the same variables. Problem is, one date variable is sometimes stored as a date variable, sometimes as a character variable. There is not apparend systematic to which is which and I dont want to check every data set (there are about 50).   So far I have this code: it works well, when the variable (published) is a character variable, but when it is a datetime variable it just gives me missing. %macro published(have); %do i=1 %to 50; DATA work.want set &have._&i.; published_1 = input(published ,ANYDTDTE16.); format published_1 date9.; RUN; %end; %mend published; %published(have) Any Idea how I could run this for all data sets?     (Btw: when published is stored as a date variables it is a datetime variable, and I only need the date.)   Thanks a lot! ... View more

Hello everyone,   I have a dataset that looks pretty much like this: data have; infile datalines dsd; input word $ article ; datalines; word1, 123456 word2, 123456 word3, 123456 word4, 123456 word5, 123456 word1, 234567 word2, 234567 word3, 234567 word5, 234567 word1, 345678 word3, 345678 word6, 345678 ; Now, I want to know which word appears with another word in how many articles. For example word1 and word2 appear 2 times together, word1 and word3 3 times.   word1 word2 word3 word4 word5 word6 word1 3 2 3 1 2 1 word2 2 2 2 1 2 0 word3 3 3 3 1 2 1   The output I want to generate should look like this or similar, you get the idea 🙂 I have tried this for a long time now, but everything I managed just resulted in error messages.   Is there some easy way to do it? Or do you have an idea how I could approach the problem?   Thanks a lot in advance. ... View more

Hello everyone,   I am currently facing the problem of subsetting a dataset by words listed in a wordlist. The dataset I have is quite large and includes the variables word and collection. I want to subset this dataset based on the observations in the variable word. For this I have several wordlists that include up to 60 words. As I do not want to write them all in a data step (especially as the word lists may change later on) I wrote myself a macro: OPTIONS MPRINT; %macro subset(cat); proc sql ; select distinct word into :word_list_&cat separated by " " from work.&cat; quit; data work.subset_&cat; set work.insurance; %do i=1 %to 50; %if word="qscan(&word_list_&cat,&i)" %then output; %end; run; %mend subset; %subset(fire) I am quite new to working with macros, so this does not work, obviously. The error I get is "WARNING: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks." which I understand, SAS obviously reads the whole word list into the quotes, but I only want the first, second, third, and so on at one time.   I would be very grateful if someone could help me out with this problem.   ... View more