04-05-2016 10:44 AM
I am new to SAS. I am using SAS Studio University Edition through AWS. I am trying to read a sas7bdat file but not able to do so. After uploading the data from my local machine in the SAS Studio, I run the following program to access it:
proc print data = "/folders/myfolders/TargetFile.sas7bdat";
However, I get the following NOTE:
NOTE: No variables in data set /folders/myfolders/TargetFile.sas7bdat.
Also, I cannot open it by double clicking the file. I get similar error. Looking forward for some help!
04-05-2016 10:58 AM
How did you upload the data? Do you know which version of SAS made the data set? There are a few cross-platform issues that may make the set unreadable by your install.
04-05-2016 11:09 AM
I uploaded the data using the upload functionality of SAS studio in the AWS console. I do not know the version of the SAS in which the data file was prepared but I am using 9.4. I wonder if such basic functionality issues may arise due to cross-platform differences!
04-05-2016 11:06 AM - edited 04-05-2016 11:07 AM
It is possible to create a SAS data set with 0 obersvations and 0 variables, see code below. Run Proc CONTENTS on the data set and have a look at the output. As a general advice, I would avoid the use of physical names for a SAS data set, but rather use a LIBNAME statement.
stop; run; proc contents data=new; run; proc print data=new; run;
04-05-2016 11:20 AM
I have a data file with a X columns and Y rows. But when I read the contents of the data after uploading it in SAS, the data is not read. It shows 0 variables and 0 indexes, 0 observations. However, I want the data to be read as Y observations, X variables.
04-05-2016 11:35 AM
It would help if you could post the output of the Proc CONTENTS from the original SAS data set, if possible, and the one you uploaded to be used in SAS Studio.
04-05-2016 11:55 AM
I am afraid I will not be able to post the original output of the Proc CONTENTS. It is a sas7bdat file (TargetFile.sas7bdat). It has Y Observations and X variables. I am uploading this file in the SAS Studio and then when I am reading it, it says 0 observations, 0 indexes, 0 variables, etc. Also, when I am double clicking the file, it shows me the follwoing error:
File _TEMP5.TARGETFILE.DATA does not exist
Hope this provides some more clarity to the problem.
04-05-2016 12:00 PM
Can you ask the creator of the SAS data set to send you the Proc CONTENTS output?
Was the SAS dataset created by SAS or some other tool?
Is it possible to attach the SAS dataset to this post?
04-05-2016 12:05 PM
I will ask the creator to send the Proc CONTENTS output. However, I dont think I can share the data set as it is a classified one. The data set was created using SAS.
04-07-2016 02:15 PM
I did not get the go ahead of the owner of the SAS file to put the output of the Proc CONTENTS in a forum. But I came to know that the file was created from a database using a Linux system. When I am trying to open the file in SAS 9.4 AWS, it does not open, but when I am opening the file in any PC with SAS installed in it could be opened. So I guess the problem is with the SAS AWS application. Though I have no clue what it can be and how to overcome it.
04-08-2016 02:32 AM
Since you have access to SAS, try uploading some other data and see how this works. I also attached a SAS data set create with SAS 9.4 on a Linux machine for testing.
I suggested you contact SAS technical support for this problem.