SAS Support Communities

Hi everyone, Anyone seen this type of behavior? : SAS EG 5.1 I have created a fairly simple stored process that has 3 prompts (location, fault type, date range).  Originally I had all three in the same query builder.  Both the location and fault type were dynamic list prompts and have a lot of choices (968 for Location, 560 for fault type).  I allow the user to select up to 10 locations and 5 fault types to filter against and a date range. Everything works great when I run the STP in EG, but when I try to run it from Excel, I get a generic message: SAS Add-In for Microsoft Office has encountered a problem We recommend that you save your work and restart SAS Add-in for MS Office. Under Details: Error creating window handle. When I eliminated the prompt for fault type and hard coded that in, the problem went away and it worked fine from Excel.  Is anyone aware of prompt limitations within the MS Add-in framework? Is there a work around? Thanks, Fred ... View more

Hi everyone, I am trying to create a block or riser map that shows the total cost of each site shown by location.  The riser block height is determined by the cost and it's location on the map should be determined by the Lat/Long.   I have the Lat/Long data, cost and site id...  I tried using MAPS.USCITY since it appears to have both LAT LONG and X  Y (projected Lat/Long in radians).  My dataset has both Lat/long and I calculated X Y in radians as well.  But when I assign USCITY for the Map Data source and my table for Response data source, the only ID Variable(s) Role that shows up are the STATECODE and LAT/LONG.  At first I thought that would be ok, because it would just use the lat/long, but all I ended up with is a blank result report - no map - nothing!  I have read a number of documents concerning the mapping but haven't seen anything that indicates that this is possible. I find that hard to believe, so i must be missing something. Any pointers to the appropriate documentation would be appreciated. Regards, Fred ... View more

ta I get all the fun! :smileyconfused:  I have a task which conceptually is fairly easy, but difficult in practice. I have thousands of Excel files that consist of many tabs or worksheets. The files were created as forms for customers to fill out and return - so there are locked fields, irregular data locations, multiple rows as column headers but not necessarily starting at row 1. There are a lot of legacy forms before someone finally decided that "hey, maybe it would be a good idea to standardize".  After that point, there are files with a revision control (although so far, I have identified at least 20 different revisions).  Way to many files to manually process and originally I started with Python because I don't see an easy way to do this in SAS. The process in Python is pretty straight forward, but.... (and there is always a but!) the Python package uses the Open Office API to open the Excel files and it throws an error when fields or tabs are protected or locked.  So it looks like Python isn't going to work for a vast majority of the files. Here is a subset of my Python code : for f in filelist[:]:     created = time.ctime(os.path.getmtime(f))     modified = time.ctime(os.path.getctime(f))     try:         book = xlrd.open_workbook(f)         sheets = book.sheet_names()         if sheets[1] == '1-Summary':             sheet = book.sheet_by_index(1)             cellC1 = sheet.cell_value(0,2)[:14]         else :             cellC1 = 'Not valid Rev doc'         newline = f + ',' + sheet.name + ',' + created + ',' + modified  + ','+ cellC1 + '\n'         VerList.write(newline)     except Exception:         ExLst.write(f)         ExLst.write('\n') This code loops through all the Excel files found in the subdirectories and opens them, checks for a sheet labelled '1-Summary' and then grabs for a text field out of a specific field which should contain the Revision control number.  This produces two csv files - VerList : contains list of the readable files with the version control field listed and an exception list of files which would not open. Once that list exists, then I can select all the files of a specific version. The data on various tabs and various locations is consistent for any given version.  I have found that I can open the Excel files where Python will not, so it should work. But after numerous google searches, I have yet to see a clean way to determine what sheets exist and then if a specific sheet exists, import but import based on specific Row/Col limits. If anyone knows of a white paper or posting along those lines, it would be greatly appreciated.  Oh, and this could be Base SAS or EG, but I do have to loop across many thousands of files. Thanks! FG ... View more