Hi,  I don't know how to change it directly in your SGPANNEL statement, but you could export the GTL template with the tmplout="path" and then edit GTL template.   In the begingraph statement you could use BACKGROUNDCOLOR, BORDER and BORDERATTRS to modify the background and borders.     After that, you could use your edited template with proc sgrender.   I hope that could be usefull ... View more

Hi,   I think that the problem is your group sentence, since you are grouping by employee id and name, is counting diferents pairs of id and names. Since your names and id's don't have bijection, there are four observations on each year.   If you like to count group by employee id use the following code proc sql; create table results as( select count(distinct employee_id) as count, Year from _data_ group by year ); quit;       ... View more

Hi,   I have also use VBS sometimes to work with excel. I don't now if its the same problem, but in my case, I try to acces a file before that Excel process it. To solve this I use the function sleep() that make that sas wait a determinet number of time.   Also I use sleep in a do bucle until the file is editable when is related to a file, making that SAS wait until file could be edited (not in used by other program).   I hope that this could hep you. ... View more

Hello,   If in your reports you want to break every 3 lines or X lines, you could edit the page size with    options ps=3; This will make that the natural break page change to the 3th line.   Also you could create a group variable as you have said and create a compute after like this break after GROUPING_VAR / page; This will create the break "_PAGE_" character at the end of each group.   I hope that this help you       ... View more

Wich is the SAS ERROR that appears to you? ... View more

Hi,  I don't know if it's a proper solution, but you always could extrat your TPL code from the SGPLOT (option TMPLOUT) and edit the layout XAXISOPTS with something like that if you know the number of weeks. Layout overlay / XAXISOPTS= (LINEAROPTS=(tickvaluelist=(1 2 3) tickdisplaylist=('01' '02' '03')))   ... View more

Hi ScottEgg,   you have used  IF ROW=1 THEN DO Your input dataset have ROW variable? If not, you should do that your second dataset have ROW=_N_; Doing that, you will have a kind of '_N_' for the second dataset ... View more

Sorry for the delay, I was out of the office.   To add SAS code I click on the "Running Man" and a Pop-up windows appear. If you use the Pop-up windows all work fine. For example Proc freq test; by var; run; Imagine that you forget about to type the by var and added out of the pop-up windows, in the resulting gray box. You get something like Proc freq test;   by var; run; The result doesn't respect enters and things like that, even when in the text or preview two text look equal   ... View more

yes, something like %macro %log_analysis(parameter1=&files); ... View more

You coud use the macro of http://support.sas.com/kb/45/805.html This macro search all files in a directory %macro drive(dir,ext); %local filrf rc did memcnt name; %let filrf=mydir; /* Assigns the fileref of mydir to the directory and opens the directory */ %let rc=%sysfunc(filename(filrf,&dir)); %let did=%sysfunc(dopen(&filrf)); /* Returns the number of members in the directory */ %let memcnt=%sysfunc(dnum(&did)); /* Loops through entire directory */ %do i = 1 %to &memcnt; /* Returns the extension from each file */ %let name=%qscan(%qsysfunc(dread(&did,&i)),-1,.); /* Checks to see if file contains an extension */ %if %qupcase(%qsysfunc(dread(&did,&i))) ne %qupcase(&name) %then %do; /* Checks to see if the extension matches the parameter value */ /* If condition is true prints the full name to the log */ %if (%superq(ext) ne and %qupcase(&name) = %qupcase(&ext)) or (%superq(ext) = and %superq(name) ne) %then %do; %qsysfunc(dread(&did,&i)) %end; %end; %end; /* Closes the directory */ %let rc=%sysfunc(dclose(&did)); %mend drive; %let FILES=%drive(&path);; This macro return names separated by spaces not by #, so adapt the file ... View more

%macro import_files(File_names=); %local i actual_file; %do i=1 %to %sysfunc(countw(&File_names)); %let actual_file=%scan(&File_names,&i,%str(#)); *Now you have a parameter Actual_file with the i-th file that could be use as macro parameter in a data _null_ or proc import; data log.output_file ; infile "&path/&actual_file..txt" firstobs=2 truncover ; input fname $400. ; run; %end; %mend;%import_files(File_names=File1#File2#OtherFile); I think that you want to do something like that, since it use the &path macro variable, it depend on want you put in this macro var ... View more