An Idea Exchange for SAS software and services

by Super User
on ‎10-29-2013 11:01 AM

I would be very concerned about someone using this to append data in a different structure than the original data. Especially with text or spreadsheet file formats.

by PROC Star
on ‎10-29-2013 03:34 PM

I would restate it, slightly, so that it explicitly refers to "an existing file, worksheet or table" rather than just "an existing file".  That said, it has my vote!

by New Contributor Zin
on ‎10-30-2013 05:23 PM

Thanks for the feedback.

Could build in some aspect to check the name of the variables in the source dataset to the destination file, worksheet or table.

If the source and destination are different (mismatch in variable names and data type, for example) then have the procedure generate an error and not append the data?

by Super User
on ‎10-30-2013 07:51 PM

Since Text and spreadsheet format files do not recquire column headings or variable names ... I know that the proc will put them by default but image updating a file NOT created by proc export.

Idea Statuses
Top Liked Authors