Help using Base SAS procedures

Import file into SAS

Reply
Contributor
Posts: 52

Import file into SAS

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? Smiley Happy

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

PROC Star
Posts: 7,363

Re: Import file into SAS

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?

Super User
Posts: 10,500

Re: Import file into SAS

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


Contributor
Posts: 52

Re: Import file into SAS

:

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.



PROC Star
Posts: 7,363

Re: Import file into SAS

Ask a Question
Discussion stats
  • 4 replies
  • 221 views
  • 0 likes
  • 3 in conversation