topic Re: Import file into SAS in SAS Procedures

Import file into SAS

namrata — Fri, 20 Dec 2013 22:39:50 GMT

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

Re: Import file into SAS

art297 — Fri, 20 Dec 2013 22:48:49 GMT

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?

Re: Import file into SAS

ballardw — Fri, 20 Dec 2013 22:57:03 GMT

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

Re: Import file into SAS

namrata — Fri, 20 Dec 2013 23:22:12 GMT

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.

Re: Import file into SAS

art297 — Fri, 20 Dec 2013 23:49:18 GMT

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