Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
Accepted Solution

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

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?

 

 


Accepted Solutions
Solution
‎05-20-2016 10:45 AM
Occasional Contributor
Posts: 19

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

Posted in reply to ishakamboj1230

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

 

 

View solution in original post

http://www.sas.com/en_us/software/university-edition.html In this video, you learn to read and generate comma-separated-value files using SAS Studio. DOWNLOAD THE FREE SAS UNIVERSITY EDITION http://www.sas.com/en_us/software/university-edition.html SAS UNIVERSITY EDITION Powerful statistical ...

All Replies
Super User
Posts: 11,343

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

Posted in reply to ishakamboj1230

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.

Super User
Posts: 19,792

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

Posted in reply to ishakamboj1230

Post your full log. 

 

Are you using SAS Academics on Demand?

Occasional Contributor
Posts: 19

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

 I am using SaS on Demand

Super User
Posts: 19,792

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

Posted in reply to ishakamboj1230

Log?

Solution
‎05-20-2016 10:45 AM
Occasional Contributor
Posts: 19

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

Posted in reply to ishakamboj1230

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

 

 

http://www.sas.com/en_us/software/university-edition.html In this video, you learn to read and generate comma-separated-value files using SAS Studio. DOWNLOAD THE FREE SAS UNIVERSITY EDITION http://www.sas.com/en_us/software/university-edition.html SAS UNIVERSITY EDITION Powerful statistical ...
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 333 views
  • 0 likes
  • 3 in conversation