topic Re: Not able to access csv or any txt file in sas studio in SAS Data Science

Not able to access csv or any txt file in sas studio

ishakamboj1230 — Mon, 16 May 2016 22:14:25 GMT

Hi,

i uploaded a csv file after creating a folder inside the sas studio using upload option . i also created and defined a library called ' libish' in the same folderthe same folder. now i am trying to access this csv file via this code:

data libish.filename;

infile 'path of the file inside the sas studio' dlm=',' firstobs='2';

input variable names ;

run;

but output data showing only variable name without any data inside and its giving below error:

'The data set LIBISH.filename may be incomplete. When this step was stopped there were 0 observations and 7 variables'

how to solve this problem?

Re: Not able to access csv or any txt file in sas studio

ballardw — Mon, 16 May 2016 22:37:40 GMT

That is a status message. Often the Log of the submitted code will have an underscore character under one of the lines of code and an actual error message.

Look for file not found type things.

Also look through the data import tasks. Some of the installations of Studio with a server cannot see your local harddrive from base code but using the tasks it can.

Re: Not able to access csv or any txt file in sas studio

Reeza — Tue, 17 May 2016 02:27:47 GMT

Post your full log.

Are you using SAS Academics on Demand?

Re: Not able to access csv or any txt file in sas studio

ishakamboj1230 — Tue, 17 May 2016 10:30:43 GMT

I am using SaS on Demand

Re: Not able to access csv or any txt file in sas studio

Reeza — Tue, 17 May 2016 12:13:23 GMT

Log?

Re: Not able to access csv or any txt file in sas studio

ishakamboj1230 — Fri, 20 May 2016 11:49:31 GMT

finally i got solution to my problem which i want to share

to open csv file in sas . first create a fólder from files and folder option . and then upload your file from upload option on the top .

then go to snippet- data- import csv file -double click on it. snippet will open on the right side. now make changes in the snippet.

add path of the file in the filename csv " path of csv file in the folder"

if you want to change the library change accordingly. and the press run option .

for video:

https://www.youtube.com/watch?v=OSX5ZPt-B5A