- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I'm tasked with updating an Excel file every week with data I get from SAS however the Excel file has a column with a drop-down box, then a manager does his manual Excel updates and then I read that file in SAS again. Is there a way that SAS can read and write data that is stored in Excel with a drop-down box? Say I have an excel file with 5 columns and 10 rows.. one of the column is a drop-down. I update the 10 rows with info from SAS including some info in the Drop-down column and the my manager makes some additions and some changes, and I want to read that newly created Excel into SAS and then make my change sin Excel including the filed data in the drop-down as it may change with info from SAS. And then the process starts all over again.. week after week..
Thanks in advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Try it 🙂