topic Re: Hourly Rate Not Showing Up in SAS Studio

Hourly Rate Not Showing Up

CristinaAl — Fri, 17 Mar 2017 22:15:24 GMT

Hi, I'm working on computing two sample test (ttest), I'm VERY new to SAAS.

The code I entered below, is not reading or finding the hourlypay column. What should I do?

Thank you for the support!

data HourlyPay;
infile '/folders/myfolders/ST513_pay_survey.txt';
input HourlyPay Gender$;
run;
proc print data=hourlyPay;
run;
proc ttest data=heights;
class Gender$;
var HourlyPay;
run;

Re: Hourly Rate Not Showing Up

Reeza — Fri, 17 Mar 2017 22:20:03 GMT

@CristinaAl wrote:

Hi, I'm working on computing two sample test (ttest), I'm VERY new to SAAS.

The code I entered below, is not reading or finding the hourlypay column. What should I do?

Thank you for the support!

data HourlyPay;
infile '/folders/myfolders/ST513_pay_survey.txt';
input HourlyPay Gender$;
run;
proc print data=hourlyPay;
run;
proc ttest data=heights;
class Gender$;
var HourlyPay;
run;

Your input statement needs to reflect the variables in the data set, in the order they appear.

Your dataset has 3 variables, two character one numeric.

Your input statement has two variables listed and not in the same order as your text file.

Fix the INPUT statement.

Re: Hourly Rate Not Showing Up

ballardw — Fri, 17 Mar 2017 22:21:41 GMT

Your data contains three fields in apparently gender grade and pay

So when you use

input HourlyPay Gender$; SAS has been told to read the first column as pay and the second as gender.

Try

input gender $ grade $ Hourlypay;

In the following code refere to gender only. The $ in the input says "read gender as a character varaible" it is not part of the actual variable name.

Re: Hourly Rate Not Showing Up

CristinaAl — Fri, 17 Mar 2017 22:35:53 GMT

Thank you! That makes sense!

Re: Hourly Rate Not Showing Up

CristinaAl — Fri, 17 Mar 2017 22:36:57 GMT

Balardw!!! THANK YOU!

This resolved my issue and it worked!

Have a great weekend!