Import file into SAS

[namrata]

Hi

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!

Namrata

[art297]

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?

[ballardw]

And what are the symptoms that "none of them works perfect"?

[namrata]

:

This is my code for xls file import:

import out=ind_code

datafile="E:\second year-recent\data_d2013\ind_index.xls"

DBMS=excel replace;

getnames=yes;

run;

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

thanks.

[art297]

Take a look at: 37412 - Errors occur when you import Microsoft Excel or Microsoft Access files into SAS® 9.2