Learning SAS? Welcome to the exclusive online community for all SAS learners.

Not able to upload excel into SAS university edition

Reply
New Contributor
Posts: 4

Not able to upload excel into SAS university edition

Hi All;

 

When i am uploading an excel file into SAS . I am not able to see the file in Work Libaray. Can somebody please help me out 

Super User
Posts: 8,055

Re: Not able to upload excel into SAS university edition

Posted in reply to Rahul_Rama

You do not "upload" a file into UE. You store the file in the shared folder, and import it from there. Only then (after your data has been converted to a SAS dataset) can you see it in the target library.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: Not able to upload excel into SAS university edition

Posted in reply to KurtBremser
I have kept the file in shared path and then imported using the import option , still the uploaded file is not reflecting in Work lib.
Super User
Posts: 8,055

Re: Not able to upload excel into SAS university edition

Posted in reply to Rahul_Rama

Please show the complete log of the import step. Use the advice in https://communities.sas.com/t5/help/faqpage/faq-category-id/posting?nobounce how to post code or logs (for logs, the {i} button is best).

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
New Contributor
Posts: 4

Re: Not able to upload excel into SAS university edition

Posted in reply to KurtBremser

i have not used any codes i just kept the file in shared path then refreshed the browser , the file started reflecting in Myfolder of SAS UE after that i right clicked the file and selected the import option .

New Contributor
Posts: 4

Re: Not able to upload excel into SAS university edition

Posted in reply to KurtBremser
 

Capture.PNG

Super User
Posts: 8,055

Re: Not able to upload excel into SAS university edition

Posted in reply to Rahul_Rama

PS I moved your topic to the SAS Analytics U community.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 20,224

Re: Not able to upload excel into SAS university edition

Posted in reply to Rahul_Rama

To use an Excel workbook in SAS UE, please follow these steps:

 

1. Place the excel file in the myfolders or a shared folder. 

2. Import the Excel file using PROC IMPORT or the GUI task. See the video here: http://video.sas.com/detail/video/3862987502001/import-a-microsoft-excel-spreadsheet?autoStart=true&...

3. Test the data using proc contents.

 

Steps 2 & 3 will look like below:

 

proc import out=myData datafile='/folders/myfolders/MyExcel.xlsx' dbms=xlsx replace; run;

proc contents data=myData;
run;
Ask a Question
Discussion stats
  • 7 replies
  • 208 views
  • 0 likes
  • 3 in conversation