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

How to import excel files in SAS On Demand for Academics

Reply
New Contributor
Posts: 3

How to import excel files in SAS On Demand for Academics

[ Edited ]

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?

Super User
Posts: 17,780

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

[ Edited ]

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

New Contributor
Posts: 3

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

[ Edited ]

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.

Super User
Posts: 17,780

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

Create a library and move the data there. 

 

This has been covered in the forums if not documentation. 

New Contributor
Posts: 3

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

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

New Contributor
Posts: 4

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

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)

Ask a Question
Discussion stats
  • 5 replies
  • 792 views
  • 0 likes
  • 3 in conversation