I need to export dataset to already defined Excel template. Template will contain only one sheet but with objects like graphs referring to fixed range (refreshing obcjets is not needed - I can do that in Excel later). Target Excel file should contain many copies of this sheet (with different data depending on data I will be exporting - eg. one sheet per client type). Is there a simple way to do that? ... View more

Hi. I've got problem apparently with some macro execution timing. I've got macro A from which I execute macro C in a loop %do %while%. I need to assure that macro C finished executing in iteration n before executing macro C in iteration n+1. Now I get errors: Line 696: ERROR: The macro C is still executing and cannot be redefined. Line 697: ERROR: A dummy macro will be compiled. and in the log i see that some iterations of macro C did not start at all. Is there a way to force SAS to woit for macro execution? Thanks for help. ... View more

I need to execute  macro with parameters many times. Parameters for subsequent executions are stored in data set. Is there a simple way (other than CALL EXECUTE) to go through data set and execute macro with proper parameters? I tried  CALL EXECUTE but this method seems non-deterministic - macro itself executes but from CALL EXECUTE returns many errors. ... View more

Is there a possibility to easily insert data set into 2-dimensional  array? The data set can have variable column count and names. Is there a way to reference columns by position instead by column name in data step? ... View more

I need to insert into one table values from another. The problem is that  table from which i'm iserting values can change and contain different set of columns in different order (but all of them for sure exist in the table I'm inserting into). So I made a macro variable (c) with set of columns that are being inserted (separated with "," eg. "col1,col2,col3") and use: insert into inserted_table (&c)  select &c from work.source_table s; When I execute it as script everything is ok. When I put it inside marco and execute it from call execute (I need to execute it many times during which &c changes - don't ask why) i get error: ERROR: INSERT statement does not permit correlation with the table being inserted into. ERROR: The reference to col1 appears to refer to a variable in the table being inserted into. I don't know why SAS doesn't from default get columns from proper table and tries to be smarter than god. All columns from select statement (source_table) exist in table (inserted_table) and from SQL syntax is clear what should be done. I don't want to put table alias into macro variable as I don't want to complicate more code. It seems as bug and want to deal with it. Can you help me? ... View more

I have data set X that can have variable number of columns named c1, c2, c3 etc cn. I need to concatenate them in one string. I need to have code that works regardless what the number of those columns is. Is there a way to concatenate with some c: wildcard or similat to that? ... View more

Is there a possibility to direct put statement to sas file ? I need to export i to sas file: Sample code: data COM;    array x[5] $3 ('a' 'b' 'c' 'd' 'e');    array c[3] $3;    array i[3];    n=dim(x);    k=dim(i);    i[1]=0;    ncomb=comb(n,k);    /* The one extra call goes back */    do j=1 to ncomb+1;  /* to the first combination. */       call allcombi(n, k, of i , add, remove);       do h=1 to k;          c =x[i ];       end;       *put @4 j= @10 'i= ' i +3 'c= ' c +3 add= remove=;       put c ;     output ;    end; run; ... View more