Hi,   I have a report where I'm using ods excel to create a main tab that has summary tables and graphs and a secondary tab with a data dump using proc export. I do this by closing ods excel and using proc export to do the dump. However,  I don't like the ods excel layout where all cells don't have borders. In fact, i'd rather use the default excel look with the grey borders on every cell but I cant seem to find anything on ods that allows me to enable the borders/gridlines. I thought it was options(gridlines="on") but that doesnt seem to have an effect on the output report.     Does anyone have a solution for this?   ... View more

Hi!   Currently, I am trying to write an etl process to update a main table with periodic updates(these updates could either be changes to existing rows or could contain new rows or both)    For example:   Main table has 5 rows with 2 columns(name and age):    Name            Age John Doe        13 John Smith     15 Bo Derek        21 Randy Snow   28 Matt Damon    38   New incoming table(6 rows, one update to the age and 1 new row) Name               Age Bo Derek          28 Camilla White   39 John Doe          13 John Smith        15 Matt Damon      38 Randy Snow     28     Ideal Result Table:   Name            Age John Doe        13 John Smith     15 Bo Derek        28 Randy Snow   28 Matt Damon    38 Camilla White   39   What i'm hoping to do is merge the two tables(main_tbl and updt_tbl)  into a new table and have "Bo Derek"'s age be updated with the new age in the second table and the insertion of the new row "Camilla White" all to the result_tbl. The repeated rows in the update table should not be appended to the new table to prevent duplicates.     proc sql; create table s.result_tbl as select * from s.main_tbl, s.updt_tbl where main_tbl.name  = updt_tbl.name order by name;   is my current solution, but I don't think that's the right way at all of approaching this. I would prefer to stick with using proc sql; and not having to resort to data steps. What would be the most efficient and effective way of achieving the desired outcome? Thanks! ... View more

Hi,   I've created an excel sheet that contains numeric values and monetary values.   Initially, whenever I export the data to a .xlsx file. The formats that I set in SAS are never retained in the excel spreadsheet. For example, numeric values with leading 0's would get removed if I were to double click the column. The same for supposed Currency columns, the $ sign would stay, however, I can't aggregate the cells because they're neither Numeric nor Currency columns. So pretty much, whenever, I run an excel export. Every column is "General" in terms of formatting.   My approach to this was to concatenate an apostrophe to every field that was numeric or monetary.  For example: '0001111   This avoids the 0's from being removed when I double click it. However, every time an export is ran. The apostrophes are visible and the formats are still considered "General." The upside to this is that when I double click the fields, nothing is removed, but the apostrophes, which is halfway to the desired outcome.   So, I'm wondering right now, what can I do to export an excel sheet that only shows apostrophes when looking at a cell from the Formula box. I don't want to see any apostrophes on the bare spreadsheet until I click a cell and view its Formula Box.    Or I can skip the concatenating of apostrophes and have the ability to retain formats when exporting to Excel. ... View more