topic Re: How to do the data analysis after importing the data Excel sheet in SAS Studio in Statistical Procedures

How to do the data analysis after importing the data Excel sheet in SAS Studio

msimolucasjames — Tue, 07 Nov 2023 07:54:36 GMT

Dear Colleagues in SAS Community I greet you all, and thanks for your help.

I again bag your attention as am new to SAS and SAS community, Now I managed.

To follow the links and your directives and now I have reached at SAS Studio. So, I need more assistance.

from here to go further to my Objective which were to do the data Analysis with SAS Studio. So, my question now is how I can, do the data analysis after importing my Data Excel sheet in SAS Studio, and the type of statistics analysis to be used.

Please find my data files for your advice

Thank you once again in advance,

with kind regards

Lucas James Msimo

Re: How to do the data analysis after importing the data Excel sheet in SAS Studio

LinusH — Tue, 07 Nov 2023 08:00:31 GMT

First step is to make your Excel available to SAS, this can be done using either PROC IMPORT:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acpcref/p0jf3o1i67m044n1j0kz51ifhpvs.htm

Or the Excel LIBNAME engine:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acpcref/n0oj9f6i838mymn148890ckla700.htm

Then it's a bit unclear what kind of data analysis you wish to do. If this is an assignment please share it.

Re: How to do the data analysis after importing the data Excel sheet in SAS Studio

msimolucasjames — Tue, 07 Nov 2023 08:09:09 GMT

Thanks I have already attached the data file in my post for you to see them

and scrutinize.

Thanks,

Regards,

Lucas James Msimo

Re: How to do the data analysis after importing the data Excel sheet in SAS Studio

msimolucasjames — Tue, 07 Nov 2023 08:22:13 GMT

Regarding the kind of data Analysis I wish to do, is GLM Parameterization of classification variables and Effects.

Regression, Main, Interaction and General

Re: How to do the data analysis after importing the data Excel sheet in SAS Studio

PaigeMiller — Tue, 07 Nov 2023 10:57:59 GMT

@msimolucasjames wrote:

Regarding the kind of data Analysis I wish to do, is GLM Parameterization of classification variables and Effects.

Regression, Main, Interaction and General

Since many of us refuse to download Excel (or other Microsoft Office) files, we cannot see the data or the variable names in your data set. The way to provide data is via working SAS data step code (examples and instructions).

The general idea in PROC GLM is like this:

proc glm data=have;
    class classvar1;
    model y = classvar1 x classvar1*x/solution;
run;
quit;

Beyond that, I can't be more specific. Not only do I not know your variable names, I am unclear about exactly what analysis you want to do, as you need to be much more specific. Saying you want to do a GLM isn't really specific enough. What model do you want to use? What statistical tests do you want to perform? What graphics do you wish to produce?

Re: How to do the data analysis after importing the data Excel sheet in SAS Studio

ballardw — Tue, 07 Nov 2023 15:57:39 GMT

When someone asks me for "data analysis" with no detailed guidelines as to what the research questions are, how the data was collected and what any specific variable may actually mean in terms of the "real world" I start asking at $250/hr.

@msimolucasjames wrote:

Dear Colleagues in SAS Community I greet you all, and thanks for your help.

I again bag your attention as am new to SAS and SAS community, Now I managed.

To follow the links and your directives and now I have reached at SAS Studio. So, I need more assistance.

from here to go further to my Objective which were to do the data Analysis with SAS Studio. So, my question now is how I can, do the data analysis after importing my Data Excel sheet in SAS Studio, and the type of statistics analysis to be used.

Please find my data files for your advice

Thank you once again in advance,

with kind regards

Lucas James Msimo