Import an Excel file and do a T-test

[Sammie]

How do I import a data (excel) and do a t test

[PaigeMiller]

You can use PROC IMPORT to import the Excel file.

You can use PROC TTEST to do a t-test.

[Sammie]

Once I import the data. Do I need to save it under lib name? Not sure if I am making sense

[sbxkoenk]

If the data is imported from Excel it is already in a SAS-library.

Maybe it is in the WORK library.

The WORK library is temporary (it disappears when you sign out of your SAS-session), meaning you will have to import your Excel data again next time.

If you import your Excel data in a permanent library or you copy your data from WORK library to a permanent library after import, you only need to import once.

Hope you can make it work,

Koen

[Kurt_Bremser]

I STRONGLY suggest that you work through the free online Programming 1 course, where the basics of SAS are dealt with.

[sbxkoenk]

Hello,

I fully agree with @Kurt_Bremser .

You can start here :

https://www.sas.com/en_be/training/offers/free-training.html

It's the SAS website for the SAS Belgium-Luxembourg subsidiary / branch of SAS, but that does not matter of course.

Koen

[Kurt_Bremser]

And if it has escaped your attention: this whole website deals with one thing only, namely the SAS software. Therefore, using just "SAS" as a subject line is about as non-descript as possible, and does not shine a bright light on either your mental powers or your willingness to spend some effort. As does the terseness of your whole post.

Please correct that by using the Edit feature.