Hello all, I have the following task and would like to discuss my solution approach with you: In my SAS application, I have data that I want to export to an excel document. It is important that the data is written to the excel file in a certain format. I have an excel document that has a table structure template at the very top of a worksheet. In this table structure, variable names are given, such as Name1. I want to replace these with the variable value of my SAS variable (e.g. mySASVariable1) from my SAS application.   This table structure should then be repeated for each SAS observation in the excel document: The whole thing reminds me of the mail merge function from Word, where you access the data from an excel table.   My idea was now the following: 1. read in the excel document with the template table structure. 2. loop through my SAS dataset. 3. replace the Excel variables with the values from the SAS application. 4. write each table structure replaced with SAS variables into the previously opened Excel document.   I hope this will preserve the table structure and formatting. Is this "a good way to do", or would you take a different approach?   Thanks in advance, ... View more

Hi! I would like to use the proc format in a more dynamic way. Instead of  proc format; value points_range 25-high='High' 15-<25='Medium' other ='Low'; run; I would like to reference a table I created earlier to make it more dynamic. There are two variables in the table: One is a comparison value and the second contains the desired assignment value. Something like   proc format; value points_range $referenceTable1.var1 = $referenceTabl1.var2 run;  Is this possible? Is *this* the way to go? Is there a better way? Does anyone have a hint for me? Thanks in advance! ... View more

Dear SAS community,   since days I am fighting with the following problem, and growing desperate...!   Simply, I do just intend to check a CHAR column col1 for whether its value is missing - trivial for numeric values, but - at least for me - the promise it's the same for characters doesn't seem to come true.           After anonymizing the namings, my code is about (which for numeric columns works perfectly well): = 8< ====================================================================== data  Out_Tab1;        set Input_Tab1;        missing_z=missing( col1);               keep missing_z  col1 ; run;   proc summary data= Out_Tab1;         by  missing_z;         var col1;         output out=Out_Tab2   sum=; run; = 8< ======================================================================   Once trying to do the same on a character column, however (having tried out uncounted imaginable variations), I regularly receive an error message like this:   = 8< ====================================================================== ... ERROR: Variable col1 in list does not match type prescribed for this list. WARNING: The data set Out_Tab2 may be incomplete.  When this step was stopped there were 0 observations and WARNING: Data set Out_Tab2 was not replaced because this step was stopped. ERROR: SAS ended due to errors. ERROR: Errors printed on pages 9,10. ... = 8< ======================================================================   What needs to be done, that I do not see?? And, where to find documentation on this that is neither terse nor cryptic??   Thank you so much in advance - I really need your help, Teona ... View more