topic Re: How to analyze individual variables in SAS Programming

How to analyze individual variables

mpatts — Wed, 15 Apr 2015 15:42:33 GMT

I am trying to perform basic chi square and logistic regression with two separate variables (Var1 and Var2) , but I cannot seem to figure out the coding to perform the analysis for just Var1 or just Var2. Do I need to create 2 separate excel documents to analyze the two variables separately? I feel like there is an easier way to perform the analysis. In other SAS programs, I simply used an "If-then-delete" statement, but that statement isn't working with the SAS University Edition. Can anyone help me with this coding? Hopefully this makes sense.

Re: How to analyze individual variables

ballardw — Wed, 15 Apr 2015 17:11:50 GMT

I would start with

proc freq data=datasetname;

tables var1 var2 /chisq;

run;

And I have no idea why Excel would enter the situation at all.

Re: How to analyze individual variables

mpatts — Wed, 15 Apr 2015 18:20:57 GMT

I might have worded my question poorly. I am trying to perform chi square between variables in two separate categories. The categories are DineHal1 and DineHal2. I want to do the chi square analysis between Salads1 and NEplates ONLY under DineHall1. Then I want to do the same chi square analysis for DineHal2. The problem I am running into is that the data for DineHal1 and DineHal2 are combining and the chi square analysis is looking at all of the data for Salads1 and NEplates for both DineHal1 and DineHal2.

DineHall Salads1 NEplates

DineHal1 1 3

DineHal1 0 2

DineHal1 1 1

DineHal1 1 2

DineHal1 0 1

DineHal2 1 3

DineHal2 0 3

DineHal2 0 1

DineHal2 1 2

This is roughly how the data looks in the excel sheet if that helps explain my situation any better.

I have previously coded:

proc freq; tables (Salads1 NEplates)*DineHall/chisq; run;

The program runs the analysis, and it looks at DineHal1 and DineHal2 combined. So to look at chi square for just DineHal1, I tried this coding:

If DineHall="DineHal2" then delete; run;

When I run that analysis, it comes up with multiple errors.

How do I look solely at the variables under DineHal1 or DineHal2?

Re: How to analyze individual variables

Reeza — Wed, 15 Apr 2015 18:32:33 GMT

I'm not 100% sure what you're doing is valid but here's how you would technically do it. You also don't include all your code so its hard to see how you've pieced things together.

Your IF statement is correct, if it was included in a data step but not in the proc freq.

Assuming your data set is called HAVE

proc freq DATA= HAVE;

WHERE DineHall='DineHal1';

tables (Salads1 NEplates)*DineHall/chisq;

run;

proc sort data=have;

by DineHall;

run;

proc freq DATA= HAVE;

BY DineHall;

tables (Salads1 NEplates)/chisq;

run;

Re: How to analyze individual variables

mpatts — Thu, 16 Apr 2015 01:48:51 GMT

This is all of the coding I have thus far:

proc import datafile="/folders/myfolders/Trayless/DHDataSAS.xlsx"

out=WORK.Analysis

DBMS=XLSX

Replace;

proc print data=WORK.Analysis; run;

proc freq; tables (Salads1 NEplates)*DineHall/chisq; run;

Should the coding mentioned in the above comment still work?

Re: How to analyze individual variables

Reeza — Thu, 16 Apr 2015 16:03:01 GMT

Try it?

Re: How to analyze individual variables

mpatts — Thu, 16 Apr 2015 16:29:39 GMT

It worked! Thanks!