cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Rajnish
‎09-01-2015
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Importing data in SAS

by Calcite | Level 5 in SAS Procedures
‎06-17-2013 04:27 AM
‎06-17-2013 04:27 AM
Thanks a lot. I managed to import the file correctly but I would like to inform you that I imported the data correctly using SAS Enterprises and not SAS 9.3. I don't know why I was not able to import it using SAS 9.3 but thanks a lot for your help. ... View more

Re: Importing data in SAS

by Calcite | Level 5 in SAS Procedures
‎06-12-2013 03:07 AM
‎06-12-2013 03:07 AM
Thanks for you help but the problem is with the data sheet titled EPS_M. I am also able to import Date_M but while importing EPS_M, I am having problem. I noticed two things: first, in excel when I selected EPS (the second column) and asked for its format, there was no format, whereas when I selected those columns of excel which are imported correctly, they have general format. So I changed all the columns to general format and then tried importing it in SAS but again the problem remained. Very perplexing. ... View more

Re: Importing data in SAS

by Calcite | Level 5 in SAS Procedures
‎06-11-2013 04:17 PM
‎06-11-2013 04:17 PM
Thanks for the help but after changing the TypeGuessRows=0, I am encountered with another problem. Now SAS is not even reading that particular column and observation is getting delete. I have attached the Data file this time. need to read to both sheet, one with date and another with other sheet and then I have merge it after taking the transpose of it. ... View more

Importing data in SAS

by Calcite | Level 5 in SAS Procedures
‎06-11-2013 03:11 PM
‎06-11-2013 03:11 PM
Hi All, I  have been struggling to import a .xlsx file in SAS. I will explain my problem as clearly as possible. Its a very small data but the problem is for few variables there are no observations till row number 25 or more. When I am importing this file using the import wizard, the data set that it creates has some variable in the character format and other variables in the numeric format, though all the variables are in numeric format. So when I am transposing it using a particular identifier, it transposes on the numeric variables and other observations are lost. I have even tried GUESSINGROWS=200 but its of no help. The other way is I can write the entire program using informat, format and input but I don't want to use this because there are many xlsx files for which I won't know number of variables and i find it really tedious. Please suggest a sure shot solution, so that SAS takes all the variables as numeric. Help will be highly appreciated. Thanks in advance ... View more

Importing Excel files in 4.3 (was SAS Enterprise Guide 4.3 related)

by Calcite | Level 5 in SAS Enterprise Guide
‎11-16-2010 01:57 AM
‎11-16-2010 01:57 AM
Hi,More than a reply, its a querry. I am new user of SAS Enterprises 4.3. I found that its is more convenient in importing .xlsx file as compared to SAS 9.1. However the problem is that when I try to use SAS data set created by SAS Enterprises 4.3 in SAS 9.1, some error is coming "The value Comapany name is not recognized". Does anyone can help in this. As I have lots of .xlsx file. I know I can always convert it in csv file and then import it in SAS 9.1. Thanks in advance. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links