I have a file that has unique identifiers that are in the format "nn-nnnn", however, everytime I export the file to CSV or XLSX using proc export, the unique identifiers for some keep converting to a date. for example: The unique identifier "10-8806" keeps converting to a date "10/1/8806". I've tried formatting the columns in excel to "Text" before exporting and that doesn't seem to work. Is there an option I should be including in the proc export to prevent the identifier from converting to a date? proc export data=defn DBMS=XLSX REPLACE LABEL OUTFILE="C:\Users\roster.XLSX"; SHEET="Roster"; run; Thanks!
... View more