SAS Tutorial | How to import data from Excel to SAS

preview_player
Показать описание
In this SAS How To Tutorial, Kathy Kiraly shows two ways to import data from Excel to SAS. The first approach uses the LIBNAME statement, and Kathy shares the power of the DATA step and other procedures. The second approach leverages PROC IMPORT in SAS.

To import Excel data to SAS using these approaches, note that you must be running SAS version 9.04.01M2 or higher. Not sure which version you're on? Kathy shows you how to check. Both methods also require SAS/ACCESS software for integrating SAS and third-party databases.

Chapters
0:00 – LIBNAME statement example
8:42 – PROC IMPORT example

Related Content

SUBSCRIBE TO THE SAS USERS YOUTUBE CHANNEL #SASUsers #LearnSAS

ABOUT SAS
SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

CONNECT WITH SAS
Рекомендации по теме
Комментарии
Автор

This is very good. I have great access to sas training since my firm is a partner, but i must say that getting properly started with sas basic programming has been hard, so these vidoe helps. i dont think the learning video on the website are as good as these ones..

emach
Автор

You are the best, easy, fast and straight forward, I wish you would make more videos

fatemehkamkar
Автор

Does the upload option create a SAS dataset?

CaribouDataScience
Автор

Very good Tutorial l learn the Task performing Data from excel to SAS.

femiogunyemi
Автор

I believe this session it will help me a lot in my future project.

alvinmodales
Автор

Thanks for posting this, I encoutered a quesiton today on excel, sheets.

himself
Автор

Great Video Very Helpful. Actually in sas 9.4 By using LIBNAME XLSX STATEMENT DATASETS ARE PREPARED BUT THESE ARE NOT OPENING. ITS SHOWS SOME ERROR. HOW CAN WE OPEN THESE DATASETS.

srinubabu
Автор

Is it possible if we can add more colours into sheet after importing excel sheet into SAS?

jatinchaudhary
Автор

Please teach me, I have 4 sheets in excel, 1 is working sheet, some 3 are data sheets, So im copying each data from each sheets and them paste it to working sheet. So now, i wanna use sas by click just 1 button and the result be altogether in 1 sheet and then with final report together.

darshiniravimalar
Автор

Hi excellent and shortest. I got exactly the same information after running the version code. I got X lib successfully and the first part of the proc contents and lib X empty. When I look at your folder, I can see the c: / and know idea how one can see that on your sever folder. Nobody's has C:/. What is my problem?

My_Super
Автор

Good day!
For the information of everyone it would be my first time to use SAS 9.4 but this time my question is, Is it possible for me to import data let say 67 Variables in columns and 900, 000 data in rows.
Thank you very much.

alvinmodales
Автор

How to use “park type “ variable to work in a dataset?

Nagarjunapathuri
Автор

Thanks for this useful tutorial. Trying to apply both procedures on small fictitious EXCEL datasets I realize that, when the last observation has a missing value for the last variable, this last observation is correctly taken into account by PROC IMPORT but is not included in the dataset when the LIBNAME way is taken. How to cope with this problem? Thanks in advance.

joelcharme
Автор

I cant see these excel tables(parks, species visits) in the library i created, it shows in the log that its successfully created but when i see on the libraries panel its please help....

sahasss
Автор

Hello ! I have a question please 😊:

Is it possible to import an excel template that have formulas inside into sas and not reading the values resukting if the formula as its done automatically ?

SKAmabs
Автор

When I do the first step, the program runs and doesn't show any errors but for some reason it does not actually upload the excel file. Can anyone help? I am using SAS on demand. Thanks!

TheLizafication
Автор

Hello, These videos are great and detailed. Could you please do one for SAS stored Process with good example ?

sivarams
Автор

This is helpful. To clarify, can you specify the location on your computer of your excel file that you were trying to import?

I’m asking because I’m getting stopped at the very early step of proc print.

I have an H drive, but my institute doesn’t provide me access to a C drive.

When I run proc print, I receive a warning: “ERROR: file WORK.cyhy.data does not exist”.

Meanwhile, libname and proc contents worked fine.

harryyoon
Автор

I just want to ask if im going to import data in sas from excel, is it possible for me to import data whether i have only one sheet in one workbook?

alvinmodales
Автор

If possible could you help us about use of SAS on demand for academics (SAS ODA) ? We ask to analyze my PHD student data in SAS ODA. We used GLIMMIX in SAS script. Is it possible to use GLIMMIX in SAS ODA. If possible could write how can call data from excel and do analyz via GLIMMIX in SAS ODA. Thank you so much.

userbester