12-20-2013 05:39 PM
I have tried to import this file in csv, excel, text formats but none of them works perfect.
This dataset initially had missing values for both the columns but I have filtered them out.
Could anybody please help me?
I have attached the dataset I need to import ind_index.xls. I have also attached the original data set just incase.
Thank you so much!
12-20-2013 05:48 PM
Since you only posted xls files, show the code you used in trying to import the Excel files. Also, do you have sas/access for pcfile formats, what version of sas are you on, are you running 32 or 64 bit sas, and which operating system are you using?
12-20-2013 06:22 PM
This is my code for xls file import:
I am using SAS 9.3 and I guess it is 64 bit SAS(sorry, am not sure about the bit part and the sas/access part) and am using Windows 7.
In case of the text file, I was getting errors like invalid data. Incase of xls import, some of the errors were:
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement