I have an import problem. I am using the following code to import a datafile, which is an Excel Workbook produced by a different agency:   PROC IMPORT OUT= WORK.Q1_2015X DATAFILE= "\\filepath\filename.xls" DBMS=XLS REPLACE; SHEET= "Q1 Oct-Dec14 (Items 15-29)"; DATAROW=6; RUN;   It's imbedded in a Macro program, which is designed to import the data for many quarters at a time. Their first four rows have a bunch of staggered headers with merged cells that don't make for good variable names. Row 5 would be a good alternative for row headers, but I don't know how to tell it to use them, so I've used the code above which mostly names the variables after the Excel columns. This was working great until my Macro program wouldn't compile because it thought there were unenclosed "DO" loops - because one of the columns is "DO" and I have a rename statement DO = CELL_262.   How can I fix this problem? Is there a better way to import this data sheet so that I can get better header names (using Row 5), or is there a way to rename the automatically created variable "DO" without the Macro program compiler thinking I am starting a DO loop?   I'm running BASE SAS 9.4. I do have SAS ACCESS/PC FILES and could do some other types of import from Excel, I'm just not very familiar with the different options available. ... View more

I am a Base SAS user that has been learning Enterprise Guide (6.1) over the last couple months.  As I've been converting some of my Base SAS programs over to EG as a learning exercise, I've come across a problem - I get slightly different results with a weighted frequency depending on which program I use.  My data is a survey sample of 3,508 observations that includes a weight variable to extrapolate the information to approximately 535,000 cases. In Base SAS, I'm running a simple Proc Freq table on a single variable and weighting it with the "WEIGHT" statement.  I get a total of 316,666 observations for the conditions set. When I run a Summary Tables task on the SAME dataset, and assign the weight variable to the "Frequency Count" task role, I get a total of 315,461 observations for the same conditions. Am I missing something in how to weight data properly in Enterprise Guide? ... View more