SAS Data Integration Studio provides a loop transformation that can help with this. Basic Steps: create a job for the "detail" work, add parameters to the job (using job properties) the parameter values will be available as Macro variables so they can be used anywhere create the control job with the loop transformation that will provide the parameter values to the "detail" job ... View more

Please note, that the DELETE function as outline above, can only be used within a SCL (SAS Component Language) program. To delete files or directories from within the DATA Step or a Macro program you need to use the FDELETE function. Bruno ... View more

Hi Bart Stored Process Input parameters are written to the corresponding macro varibales. You could use code similar to the one below to capture the contents of the macro variables: proc sql;   create table myParms as   select     *   from     dictionary.macros   where     name like "/_%" escape "/"   order by     name   ; quit; The code above will only select macro variables starting with "_", but you can change the WHERE clause to get what you need Bruno ... View more

Hi I used the tips from Cynthia and created some sample data and a Proc Report, it should give you a good start: data someData;   infile cards dsd dlm="," missover;   input     countryGroup : $32.     Country : $32.     target : 8.     Day : 8.     dayValue : 8.   ;   cards; NorthAmerica,Canada,200,1,310 NorthAmerica,Canada,200,2,120 NorthAmerica,USA,250,1,10 NorthAmerica,USA,250,2,320 ; proc report data=someData nowindows;   column countryGroup Country target day, dayValue _dummy;   define countryGroup / group;   define country / group;   define target / analysis mean;   define day / across;   define dayValue / analysis sum;   define _dummy / computed;   compute _dummy /;     * depends on the number of days;     array myDays{*} _c4_ _c5_;     * we are in a plain data line;     if missing(_break_) then do;       do i = 1 to dim(myDays);         if myDays{i} > target.mean then do;           call define(vname(myDays{i}), "style", "style={background=cx997086}");         end;       end;       targetTotal + target.mean;     end;     * we are in a summary line;     if upcase(_break_) = "COUNTRYGROUP" then do;       countryGroup = catx(" ", countryGroup, "Total");       target.mean = targetTotal;     end;   endcomp;   break after countryGroup / summarize; run; Bruno ... View more

Ho Soha You can also use the SG... procs to achieve the result, see example below. They allow to overlay plots with some settings for barwidth and discreteoffset you get two bar beside each other. With this example there is no need to change our data data plotData;   infile cards;   input     Region $     Sales2009     Sales2010   ; cards; East  543 487 North 500 565 South 825 750 West  600 700 ; proc sgplot data=plotData;   hbar region /     response=sales2009     discreteoffset=-0.2     barwidth=0.4   ;   hbar region /     response=sales2010     discreteoffset=0.2     barwidth=0.4     transparency=0.5   ; run; ... View more

hi Kamalakar this message indicates, that the font was not found in the SAS registry. To see which fonts are defined in the SAS registry, you can use the following code: proc registry   startat="\CORE\PRINTING\FREETYPE\FONTS"   list ; run; Then check the log. All the fonts that are on your system are usually registered during the install process of SAS. However you can register fonts later using Proc FONTREG, see sample below proc fontreg   mode=add   msglevel=normal   usesashelp ;   truetype "c:\windows\fonts"; run; Please also check the documention for Proc REGISTRY and Proc FONTREG for more information. Bruno ... View more

Please note In order to use a font it has to be registered in the SAS Registry One can use Proc FONTREG to this, see example below. The NOUPDATE option only shows what would happen, but the SAS Registry is not updated proc fontreg   usesashelp   mode=add   noupdate ;   truetype "C:\Windows\Fonts"; run; To use it as suggested, find an example below: proc gslide;   note color=black font="Free 3 of 9" height=10 j=right angle=90 "<123>";   note color=black font="Arial" height=10 j=right angle=90 "<123>";   note color=black font="Free 3 of 9 Extended" height=10 j=right  "<123>";   note color=black font="Arial" height=10 j=right  "<123>"; run; quit; Bruno ... View more

Hi How about using the DLM= option of the FILE statement Data test;   input name $1-1 age $ 3-5 sex $ 6-7; cards; a    m b 14 m c 15 m d 8  f e    f ; data _null_;   set test;   file "c:\temp\someFile.txt" dlm="!";   put name age sex; run; ... View more

hi Find below a working example. Macro variables created within a macro have usually a LOCAL scope. However you can make macro variables global, see example below I have also made some changes to your code sample %MACRO M1(COL,TAB,MACROVAR);   %* make the macro var global;   %global &macrovar;   %*    * we are reading only the first obs of the table    * the TRIMMED option will take away trailing blanks    *;   PROC SQL NOPRINT;     select       &col       into       :&macrovar TRIMMED     from       &tab(obs=1)     ;   quit;   %put _local_; %MEND; %M1(MNEMONIC,SASHELP.ADOMSG,A1) %PUT NOTE: *&A1*; From your code it looks like you want to be able to access some messages from a data sets. Please have a look at the SASMSG http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n0pbh06faefiuyn1paei4vrvft2d.htm and SASMSGL http://support.sas.com/documentation/cdl/en/nlsref/63072/HTML/default/viewer.htm#n1iekis5qclbspn1wd6bno0jhtdq.htm functions as well ... View more