Hi,   I didn't manage yet to get the tableeditor work correctly for me, fulfilling all the requirements I had. So I chose to work with ODS Tagset ExcelXp to output my data and added some vbs   This paper helped me to program my pivot table directly from SAS, works like a charm http://www2.sas.com/proceedings/sugi31/035-31.pdf   After inserting the pivot I convert my xml to a native xlsx file one way to do this can be found here: http://support.sas.com/kb/43/496.html   Finally i noticed that I had to refresh the xlsx. Although it can be done with 3 clics in excel, I chose to do this directly from SAS   The main vbs code you need to do this (using the proceedings described in the above paper) is:   put " Dim oXL "; put " Dim objWorkBook"; put " Set oXL = CreateObject(""Excel.Application"")"; %*Open xlsx file, refresh (pivot) Table and save; put " Set objWorkBook = oXL.Workbooks.Open(""&xlsxFileName."")"; put " objWorkBook.RefreshAll"; put " oXL.ActiveWorkBook.SaveAs ""&xlsxFileName."",51"; put " oXL.DisplayAlerts = True"; put " oXL.ActiveWorkBook.Close SaveChanges = True"; put " oXL.Quit"; ... View more

Transfer 1 ID     PARAM          RESULT A      DueDate         xyz A      AmountPaid    xyz A      Datepaid         xyz Transfer 2 ID     PARAM          RESULT B      DueDate         xyz B      AmountPaid    xyz B      AmountDue    xyz B      Datepaid         xyz Set the two together.  However if its only one additional variable, then just set the two datasets together.  This should all be in your transfer specifications document which documents what is to be transfered, the structure, schedule of transfer etc.  I.e you should know what is to be received and when, so just setup from there. ... View more

I am using SAS Add-in for Excel. Unfortunately my original file broke and is not working so I did a quick remake. PROC TABULATE DATA=_TEMP.ce_nursing_assistant_course ; VAR CE_STUDENTS; CLASS COLLEGE_NM / ORDER=UNFORMATTED MISSING; CLASS REPORTING_YEAR / ORDER=UNFORMATTED MISSING; CLASS MASTER_COURSE_LIST_ID / ORDER=UNFORMATTED MISSING; TABLE /* Page Dimension */ MASTER_COURSE_LIST_ID, /* Row Dimension */ COLLEGE_NM ALL={LABEL="Total"}, /* Column Dimension */ REPORTING_YEAR*   CE_STUDENTS*     Sum   ; ; RUN; ... View more

I think what gets you confused is the 'variable name' and 'variable type' in the Hash definition. The quoted notion such as 'student_skey'  in  e.definekey('student_skey'); has nothing to do with the 'variable type', it merely addresses the 'variable name', where the variable can be either Char or Num, defined by incoming table or PDV. See following example,  data _null_;      if _n_=1 then            do;                 if 0 then                      set sashelp.class;                 declare hash h(dataset: 'sashelp.class');                 /*   h.definekey('age');*/                 new_age='age';                 h.definekey(new_age);                 h.definedata('name');                 h.definedone();            end;      rc=h.output(dataset:'help'); run; So quoted or not merely saying whether it is a 'string' or a variable. If it is a 'string', then 'string' itself is the variable name, if not quoted (variable), the content of the variable is the variable name. Haikuo ... View more

It works when the data is NUMERIC.  Does not work for character data. ... View more

Thanks Chris! I am able to create the map, but my coordinates are not coming out correctly. Basicly, I need to flip the coordinates. I am using Enterprise Guide to create the map with mapsas.counties for the map data source. My East and West are reveresed. I am trying to figure out how to correct this. ... View more