topic Re: Error When Adding Analysis Variable-- Very New to SAS! in New SAS User

Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 14:54:13 GMT

Hi there,

I am working on a project for school, and I am by no means an expert. For every assignment, but this one, we have been given a dataset. So, this is the first time choosing my own.

As, I run Summary Statistics and try to add Analysis Variables it states "no columns are available." It does the same when I try to add a dependent variable for linear regression.

Here is the code for my data set??

/* Generated Code (IMPORT) */

/* Source File: IRP Data.xlsx */

/* Source Path: /home/u57962939/IS3310 */

/* Code generated on: 9/26/21, 9:08 AM */

%web_drop_table(IS3310.IRP);

FILENAME REFFILE '/home/u57962939/IS3310/IRP Data.xlsx';

PROC IMPORT DATAFILE=REFFILE

DBMS=XLSX

OUT=IS3310.IRP;

GETNAMES=YES;

RUN;

PROC CONTENTS DATA=IS3310.IRP; RUN;

%web_open_table(IS3310.IRP);

Here is the log:

OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

71 /* Generated Code (IMPORT) */

72 /* Source File: IRP Data.xlsx */

73 /* Source Path: /home/u57962939/IS3310 */

74 /* Code generated on: 9/26/21, 9:08 AM */

76 %web_drop_table(IS3310.IRP);

79 FILENAME REFFILE '/home/u57962939/IS3310/IRP Data.xlsx';

81 PROC IMPORT DATAFILE=REFFILE

82 DBMS=XLSX

83 OUT=IS3310.IRP;

84 GETNAMES=YES;

85 RUN;

NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with

options MSGLEVEL=I.

NOTE: The import data set has 975 observations and 27 variables.

NOTE: IS3310.IRP data set was successfully created.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.24 seconds

user cpu time 0.24 seconds

system cpu time 0.00 seconds

memory 2976.03k

OS Memory 28580.00k

Timestamp 09/26/2021 02:08:43 PM

Step Count 38 Switch Count 2

Page Faults 0

Page Reclaims 697

Page Swaps 0

Voluntary Context Switches 30

Involuntary Context Switches 0

Block Input Operations 208

Block Output Operations 520

87 PROC CONTENTS DATA=IS3310.IRP; RUN;

NOTE: PROCEDURE CONTENTS used (Total process time):

real time 0.08 seconds

user cpu time 0.09 seconds

system cpu time 0.00 seconds

memory 2586.87k

OS Memory 28584.00k

Timestamp 09/26/2021 02:08:43 PM

Step Count 39 Switch Count 0

Page Faults 0

Page Reclaims 722

Page Swaps 0

Voluntary Context Switches 10

Involuntary Context Switches 0

Block Input Operations 288

Block Output Operations 32

90 %web_open_table(IS3310.IRP);

92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

103

User: u57962939

Messages: 9

US Region

I would really appreciate any help!

Re: Error When Adding Analysis Variable-- Very New to SAS!

PaigeMiller — Sun, 26 Sep 2021 15:20:07 GMT

As, I run Summary Statistics and try to add Analysis Variables it states "no columns are available." It does the same when I try to add a dependent variable for linear regression.

You have NOT shown us anything like this in the LOG. Show us the LOG for this part of the code.

Re: Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 15:21:21 GMT

I copied my entire log for the data set. As I stated, I am very new to SAS and am completing this for a school project. Could you be more specific of what I need to show you and where I can find it?

Re: Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 15:22:45 GMT

Maybe this is it?

PROC SQL;
CREATE TABLE WORK.query AS
SELECT 'Do you celebrate?'n , 'Typical Meat'n , 'How is it prepared?'n , 'What kind of stuffing?'n , 'What kind of cranberry sauce?'n , 'Do you have gravy?'n , 'Corn Served'n , 'Green beans served'n , 'Mashed potatoes served'n , 'Rolls/biscuits'n , 'Yams/Sweet Pot'n , 'Apple pie'n , 'pecan pie'n , 'pumpkin pie'n , 'pray before dinner?'n , 'Home or travel?'n , 'Watch Macy''s parade?'n , 'Age cutoff'n , 'Meet up with hometown friends?'n , 'Attend friendsgiving?'n , 'Shop black Friday?'n , 'Work in retail?'n , 'Area you live?'n , Age , 'Gender?'n , 'Combined monthly income'n , 'US Region'n FROM IS3310.IRP;
RUN;
QUIT;

PROC DATASETS NOLIST NODETAILS;
CONTENTS DATA=WORK.query OUT=WORK.details;
RUN;

PROC PRINT DATA=WORK.details;
RUN;

Re: Error When Adding Analysis Variable-- Very New to SAS!

PaigeMiller — Sun, 26 Sep 2021 15:23:40 GMT

You said you ran summary statistics, but no LOG from that action is shown. You said you were trying a linear regression, but no LOG from that action is shown.

Re: Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 15:24:37 GMT

I stated I TRIED to run summary statistics and linear regression, but I was unable to add analysis variables and dependent variables.

Re: Error When Adding Analysis Variable-- Very New to SAS!

PaigeMiller — Sun, 26 Sep 2021 15:25:17 GMT

And how did you TRY to run these analyses?

Re: Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 15:26:09 GMT

I clicked on them to run them, chose my data set, and clicked to add the variables... but no variables are available.

Re: Error When Adding Analysis Variable-- Very New to SAS!

PaigeMiller — Sun, 26 Sep 2021 15:27:40 GMT

Can you show us a screen capture of the error message? Click on the "Insert Photos" icon to include screen captures in your reply.

Re: Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 15:29:10 GMT

Re: Error When Adding Analysis Variable-- Very New to SAS!

PaigeMiller — Sun, 26 Sep 2021 15:32:05 GMT

My guess is that your data set was read (perhaps incorrectly) and has no numeric variables, these are all character variables, and so Summarize Data and Linear Regression are not valid methods of analyzing character variables.

The output from PROC CONTENTS will show you whether that is the case or not.

Re: Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 15:33:52 GMT

Re: Error When Adding Analysis Variable-- Very New to SAS!

Kurt_Bremser — Sun, 26 Sep 2021 16:11:04 GMT

The rather funny column names let me think that all these variables contain textual data (of type character), which can't be used for the analysis you plan.

To verify this, post the output (not the code, not the log) of a PROC CONTENTS of the dataset.

Re: Error When Adding Analysis Variable-- Very New to SAS!

jrichardson134 — Sun, 26 Sep 2021 16:21:07 GMT

I will only be using two of the 27 columns.

This is what they look like.

Is it possible to change one to numeric?

Pecan Pie

US Region

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

Yes

West South Central

West North Central

Yes

West North Central

Yes

West North Central

Yes

West North Central

Yes

West North Central

100

West North Central

Re: Error When Adding Analysis Variable-- Very New to SAS!

Kurt_Bremser — Sun, 26 Sep 2021 17:45:08 GMT

You can replace the Yes/No column with a new column that has 1 (true) for Yes and 0 (false) for No.

pecan = ifn('Pecan Pie'n = "Yes",1,0);

Re: Error When Adding Analysis Variable-- Very New to SAS!

PaigeMiller — Mon, 27 Sep 2021 12:24:13 GMT

I will only be using two of the 27 columns.

This is what they look like.

Is it possible to change one to numeric?

Pecan Pie US Region

2 Yes West South Central

3 No West South Central

Let's stop here, and ask questions that have nothing to do with SAS, but are directly related to your desire to run summary statistics or a regression on this data.

Does it make even the slightest bit of sense to change either variable to numeric? Explain.

Again, this has nothing to do with SAS. How would you define the summary statistics of "US Region"? How would you do a regression with "US Region"? How would you define the mean of "Yes" or "No"??