10-02-2013 12:37 AM
I am using eg sas 5.1. I am importing a 144 column excel spreadsheet into sas for data analysis. Examples of my column names are Department ID, Agency, Hire Date, Date Last Promoted, would I have to do a catx('-',variable name) on all 144 columns? Is there another way? I want column names to have underscores with a character type because I will need to use them in formulas
10-02-2013 12:52 AM
The option is
in EG the default is Any. There's probably a button to click somewhere but I don't know. This can help you google it anyways.
10-02-2013 03:33 AM
If you are using the import task in Enterprise Guide there is a checkbox within the import process where you can specify to convert variable names to SAS variable names (or something like that). If you check this box then any special character or space is converted to an underscore for the variable name.