BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I wish to open a SAS data source into an existing spreadsheet at a specific cell location, but without including the variable names or variable labels. I'm using AMO 2.1 which has an option to not include the obs values as the first column, but have been unable to find a similar option to not include the variable names as the first row. I find an option to use either the variable names or use the variable labels, but I can't find anything where I can choose to not include. This is very similar to a previous post - 19MAY2006 'Export a SAS dataset to a (or a group of specific cells) in Excel'. In EG4 you can export, but you don't have any of the options like you have with import, i.e. import starting with line nn, etc.
1 REPLY 1
Bill_SAS
SAS Employee
You can stop looking because the option is not there. We did not consider your case when designing the Add-In. I will put it on the list of feature requests.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 1 reply
  • 1239 views
  • 0 likes
  • 2 in conversation