I am writing a description of the problem to Tech Support now. Thanks! I think the ":" in my proc report, code is the problem (as the the description of the error message indicated) . I am trying to pull in a list of variables using the wildcard : and when i remove the variables in the columns statement that have : at the end, the program works. ... View more

Perfect, yes.  I think the ":" in my proc report, code is the problem (as the the description of the error message indicated) . I am trying to pull in a list of variables using the wildcard : and when i remove the variables in the columns statement that have : at the end, the program works. Thanks! ... View more

Yes, that was what im looking for. Thanks Art. ... View more

Thanks for all yout help Cynthia. ... View more

Hi Cynthia-- Thanks again. I think I know why I got the error message "WARNING: A GROUP, ORDER, or ACROSS variable is missing on every observation" When I used my data, when the column "Review of CPS History" generates there is supposed to be no data in it. Just the colum heading. Its like i devider between questions. So if there is no data in the colum but I need to shade in the colum and format it how would do that if I have a colum with the data in it? Matt ... View more

Hi Cynthia-- Thank you again for your help. I have been trying do to reproduce the example you gave me and I can't seem to get it to work. I keep getting the warning message : WARNING: A GROUP, ORDER, or ACROSS variable is missing on every observation. When I look at the dataset, there is mo data in the observations and I can't open the excel file on the network. Here is the log: 2152  ** make some fake data; 2153  data work.matt (keep=d1 cra:); 2154  length d1 $50; 2155    set Prev.sheet1; 2156    d1=name; 2157    cra1 = age; 2158    cra2 = height; 2159    cra3 = weight; 2160    cra4 = age*int(height); 2161    label cra1 = 'Q1' 2162          cra2 = 'Q2' 2163          cra3 = 'Q3' 2164          cra4 = 'Q4' 2165          d1 = "Review of CPS History"; 2166  run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).       2160:18 NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).       2160:13 NOTE: Variable name is uninitialized. NOTE: Variable age is uninitialized. NOTE: Variable height is uninitialized. NOTE: Variable weight is uninitialized. NOTE: Missing values were generated as a result of performing an operation on missing values.       Each place is given by: (Number of times) at (Line):(Column).       22 at 2160:13   22 at 2160:14 NOTE: There were 22 observations read from the data set PREV.SHEET1. NOTE: The data set WORK.MATT has 22 observations and 156 variables. NOTE: DATA statement used (Total process time):       real time           0.25 seconds       cpu time            0.04 seconds 2167 2168  ** Use PROC REPORT to provide style overrides; 2169  ods tagsets.excelxp file="X:\ORE\Scorecard Database\Final Raw Data.xls" 2170       style=minimal 2171       options(sheet_interval='none' sheet_name="DATA1"); NOTE: Writing TAGSETS.EXCELXP Body file: X:\ORE\Scorecard Database\Final Raw Data.xls NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.94, 09/09/12). Add options(doc='help') to the ods statement for more information. 2172 2173  proc report data=work.matt nowd 2174    style(column)={just=c}; 2175    column d1 cra1 cra2 cra3 cra4; 2176    define d1 / order 2177           style(header)={font_size=12pt font_face='Times New Roman'} 2178           style(column)={font_size=10pt font_face='Arial' 2179                          cellwidth=2in background=cxcccccc}; 2180    define cra1 / display 2181           style(column)={cellwidth=.5in}; 2182    define cra2 / display 2183           style(column)={cellwidth=.75in}; 2184    define cra3 / display 2185           style(column)={cellwidth=1.25in}; 2186    define cra4 / display 2187           style(column)={cellwidth=.75in}; 2188  run; WARNING: A GROUP, ORDER, or ACROSS variable is missing on every observation. NOTE: There were 22 observations read from the data set WORK.MATT. NOTE: PROCEDURE REPORT used (Total process time):       real time           0.07 seconds       cpu time            0.03 seconds 2189  ods tagsets.excelxp close; 2190  ods listing; Thank you so much. ... View more

Hi Cynthia-- This is incredibly helpful, thank you! I have questions:  how do I apply styles to the question lists from the dictionary tables I create? Like &List5a and &list10a. The amount of columns contained in these lists will vary from run to run. Thank you. Matt-- ... View more

GREAT THANKS! ... View more

Hi Art-- I'm not sure how I would add ',' to this statment. select name  into : list1 separated by ' '   from dictionary.columns    where name like 'cra52a_%' and libname='WORK' and memname='WANT'; ... View more

Hi KSharp-- Thanks again. I do have one more question. I want to try and use Proc SQL as oppssed to the Data Step to make the final organized data steps.  Its easier when outputting to spreadsheets. I got an error message I don't understand. Proc SQL; Create table FINAL as select Quest_, Case_Number,  Case_FirstName, Case_FirstName, &list1, Agency_Name, &list2, cra5, program_name, cra14, &list3 from work.want; quit; NOTE: Line generated by the macro variable "LIST1". 1      cra52a1 cra52a_1 cra52a_2 cra52a_3 cra52a_4 cra52a_5 cra52a_6 cra52a_7 cra52a_8                --------                22                76 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, (, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS,               BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE,               NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=. ... View more

Hold on I see what I did. This works perfectly!!!! Thanks so much! ... View more