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
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?
And what are the symptoms that "none of them works perfect"?
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.