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

[msimolucasjames]

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

[LinusH · Accepted solution]

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.

[msimolucasjames]

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

and scrutinize.

Thanks,

Regards,

Lucas James Msimo

[msimolucasjames]

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

Regression, Main, Interaction and General

[PaigeMiller]

---

@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?

[ballardw]

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

---