topic Re: Data not detected in SAS Studio in SAS Studio

Data not detected in SAS Studio

sk2706 — Tue, 05 Apr 2016 14:44:24 GMT

Hi,

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";

run;

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!

Thanks,

Santanu

Re: Data not detected in SAS Studio

ballardw — Tue, 05 Apr 2016 14:58:45 GMT

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.

Re: Data not detected in SAS Studio

BrunoMueller — Tue, 05 Apr 2016 15:07:55 GMT

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.

data new;
stop;
run;

proc contents data=new;
run;

proc print data=new;
run;

Bruno

Re: Data not detected in SAS Studio

sk2706 — Tue, 05 Apr 2016 15:09:05 GMT

Hi ballardw,

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!

Re: Data not detected in SAS Studio

sk2706 — Tue, 05 Apr 2016 15:20:16 GMT

Hi Bruno,

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.

Thanks,

Santanu

Re: Data not detected in SAS Studio

BrunoMueller — Tue, 05 Apr 2016 15:35:52 GMT

Hi Santanu

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.

Bruno

Re: Data not detected in SAS Studio

sk2706 — Tue, 05 Apr 2016 15:55:15 GMT

Hi Bruno,

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.

Thanks,

Santanu

Re: Data not detected in SAS Studio

BrunoMueller — Tue, 05 Apr 2016 16:00:37 GMT

Hi Santanu

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?

Bruno

Re: Data not detected in SAS Studio

sk2706 — Tue, 05 Apr 2016 16:05:02 GMT

Hi Bruno,

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.

Thanks,

Santanu

Re: Data not detected in SAS Studio

sk2706 — Thu, 07 Apr 2016 18:15:37 GMT

Hi Bruno,

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.

Thanks,

Santanu

Re: Data not detected in SAS Studio

BrunoMueller — Fri, 08 Apr 2016 06:32:08 GMT

Hi Santanu

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.

Bruno