topic Re: SAS in New SAS User

Import an Excel file and do a T-test

Sammie — Tue, 30 Nov 2021 09:12:14 GMT

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

Re: SAS

PaigeMiller — Sat, 27 Nov 2021 16:35:43 GMT

You can use PROC IMPORT to import the Excel file.

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

Re: SAS

Sammie — Sat, 27 Nov 2021 18:36:36 GMT

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

Re: SAS

sbxkoenk — Sat, 27 Nov 2021 19:06:09 GMT

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

Re: SAS

Kurt_Bremser — Sat, 27 Nov 2021 20:03:16 GMT

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

Re: SAS

sbxkoenk — Sat, 27 Nov 2021 20:53:55 GMT

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

Re: SAS

Kurt_Bremser — Sun, 28 Nov 2021 09:11:32 GMT

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.