In case of when the macro vars are in single quotes. So they are not resolved. Use double qoutes instead. In the case of if did you try checking the case of values and if the values have padded blanks? ... View more

data have; infile datalines dlm=" " dsd missover; input Var1 $ var2 $ var3 $ var4 $ var5 $ var6 $; length similar_char_vars similar_num_vars $32767.; array _c{*} _character_; array _n{*} _numeric_; do i = 1 to dim(_c); similar_char_vars=''; do j= i+1 to dim(_c); if _c[i] = _c[j] and not missing(_c[i])then similar_char_vars = strip(similar_char_vars)||' '||vname(_c[i])||' '||vname(_c[j])||' '||strip(_c[j]); end; if ^missing(similar_char_vars) then output; end; do i = 1 to dim(_c); similar_num_vars=''; do j= i+1 to dim(_c); if _c[i] = _c[j] and not missing(_c[i])then similar_num_vars = strip(similar_num_vars)||' '||vname(_c[i])||' '||vname(_c[j])||' '||strip(_c[j]); end; if ^missing(similar_char_vars) then output; end; drop i j; put similar_char_vars=; datalines;; 1 a 4 6 a 1 9 l 6 g l 5 8 d 5 y d 7 & 7 y 6 ;;; run; ... View more

In here you are not merging the datasets but concatenating one to the bottom of the other. What about the overlapping records? ... View more

data output; merge a(in=ina) b(in=inb); by <byvar list>; if ina and inb then exists='inainb'; else if ina then exists ='ina'; else if inb then exists ='inb'; run; ... View more

First of all more code and data samples would be handy. I do not see a need for go to unless you want to do some logic and return back to the main code. If your sole objective is to skip records that do not match a certain criteria and you do not want them in the output you can just add the following line the code   if some_date = current_date;   The lines following that conditional statement including output will only be executed if the conditional is true. ... View more

There is current_date and add months feature in oracle can’t you use them? Can’t you put double quotes around macro variables to_date(“&date1.”,'DDMMYYYY'). What did you try and did not work. ... View more

1. Build a format based on your fiscal date begin and end i.e. begin and end marking a fiscal period      1Apr2011 - 31Mar2012 = 31Mar2012 2. Apply your format to your first dataset. 3. after doing that join it with the second dataset. 4. If there are overlapping ranges then it will be a problem   Idea 2: Work backwards 1. On dataset build the start of fiscal year for each row. 2. do a sql join based on your id and date from dataset 1 falls between start and end dates of fiscal year in dataset 2 ... View more

Do you know why there are special characters in your log? one of the quoting functions as suggested by novinosrin might help. If you are just getting counts and description you can use a format and proc means or proc summary to get all the information in a single go. ... View more

can you provide the log please. My hunch is around the line  label Q&n = &o; change it to label Q&n = "&o"; ... View more