01-14-2013 04:45 PM
I am trying to import excel files using sas eg 5.1v. The column names are not getting imported as in using pc sas. For ex. in pc sas the column name "policy #' will be changed to 'policy__' / 'policy number' will be changed to 'policy_number' automatically. How can I get that in sas EG?
01-15-2013 10:13 AM
I encountered a similar problem, I imported an excel file into EG and exported out to SAS in a folder, the transition is fairly smooth. However, when I tried to open to viewtable to view the converted dataset in PC/SAS. It prompted and error saying that those variable(like 'Sequence Number') is a invalid SAS variable because he EG did not replace the space with an '_'.