topic How to import excel files in SAS On Demand for Academics in SAS Software for Learning Community

How to import excel files in SAS On Demand for Academics

akkiiss55 — Fri, 30 Jul 2021 20:51:25 GMT

Hello everyone.I use sas on demand for academics.As I understand it supports csv xls etc files.

PLEASE , is there anyone who can guide me through the process step by step on how to import a file on sas?

Re: How to import excel files in SAS On Demand for Academics

Reeza — Fri, 24 Jun 2016 20:28:03 GMT

1. Upload your file. Go to File & Folders on left hand side and find the upload tool.

This talks about uploading SAS datasets, but the process is the same for an Excel file, ignore the libname portion (up to page 4)

2. Follow instructions here on how to import using Task>Utilities>Import data.

http://support.sas.com/training/tutorial/studio/index.html

In general, besides uploading data, the rest of the SAS Studio tutorials will apply to SAS Academics on Demand

Re: How to import excel files in SAS On Demand for Academics

akkiiss55 — Sat, 25 Jun 2016 09:13:22 GMT

ok so now that i uploaded the file and imported it,i can see it as a temporary file in work library.how can i make it a permanent one now?the instructions are not very clear.

Re: How to import excel files in SAS On Demand for Academics

Reeza — Sat, 25 Jun 2016 13:08:25 GMT

Create a library and move the data there.

This has been covered in the forums if not documentation.

Re: How to import excel files in SAS On Demand for Academics

akkiiss55 — Sat, 25 Jun 2016 14:32:48 GMT

Thank you for helping me out,the problem is now solved

Re: How to import excel files in SAS On Demand for Academics

Evaldas — Sat, 13 May 2017 14:38:22 GMT

Maybe anyone knows how to import excel/csv files to SAS enterprice miner for academics? or maybe anyone know how to change excel/CSV files to SAS files ( becouse i know how to import SAS files)

Re: How to import excel files in SAS On Demand for Academics

nandanosho — Tue, 07 Nov 2017 16:51:55 GMT

Re: How to import excel files in SAS On Demand for Academics

matthewparker0 — Mon, 01 Mar 2021 20:20:25 GMT

Follow the steps below to import an Excel file into SAS OnDemand for Academics and Create a SAS data set　

1) Login to SAS OnDemand for Academics

2) Select a folder under Files(Home) to upload the data to

3) Under 'Server Files and Folders on the left hand side, choose the 'Upload' option

4) select 'Choose Files' and find the file on your computer

5) Select 'Upload'

6) right click on the file in your folder and choose 'Import Data'

This will generate code.

If you wish to edit this code. Choose 'Edit'

7) Run this code to generate the SAS Dataset.

NOTE: By default the dataset will be put into your WORK library.

You can change this by editing the OUT= statement in the PROC IMPORT procedure.

I hope this helps!

Editor's note: SAS trainer @DominiqueMoon created this video to help new users of SAS OnDemand for Academics get started.

Re: How to import excel files in SAS On Demand for Academics

sunnyinkansas — Mon, 28 Jan 2019 11:05:53 GMT

Thank you, this did help.

Re: How to import excel files in SAS On Demand for Academics

lschmid — Sun, 07 Feb 2021 16:47:26 GMT

When I click upload on the excel file, nothing happens on the SAS Studio side..??

Re: How to import excel files in SAS On Demand for Academics

rushi2 — Sat, 02 Oct 2021 09:20:57 GMT

Is this functionality still working? I tried importing CSV and Excel file but it doesn't do anything. Can someone please help me with this issue? Thanks!

Re: How to import excel files in SAS On Demand for Academics

BeverlyBrown — Mon, 04 Oct 2021 10:59:42 GMT

Hi @rushi2, sorry you're having trouble! Few will see a recent comment on this much older thread. The fastest way to get help is to post a new question on the SAS Software for Learning Community, where experts keep an eye out for new topics: https://communities.sas.com/t5/SAS-Software-for-Learning/bd-p/sas-learning; look for the orange Start a Topic button in the upper-right corner.