Not sure if anyone else has figured out any elegant solutions to export data to a delimited text file using the variable labels as column headers, but this would definitely be a good feature to have. Currently running into issues because some files exceed the maximum number of records that can be included in an MS Excel file (creating the need for a delimited flat file in its place instead). The only potential work around I can think of is to cast all the data as string, insert a new record containing the variable labels, add a new variable to define the sort order to place this newly inserted row in the first record, and then exporting the file as delimited text using the novarnames option.
With the exception of functionality that is specific to MS Excel (e.g., worksheet names, etc...), it would be nice if the -export excel- and -export delimited- commands used the same option set.
With the exception of functionality that is specific to MS Excel (e.g., worksheet names, etc...), it would be nice if the -export excel- and -export delimited- commands used the same option set.
Comment