topic Re: Trying to create Summary Statistics from PERM.<FILENAME>. in Statistical Procedures

Trying to create Summary Statistics from PERM..

BigDisty — Fri, 05 Jul 2019 04:12:56 GMT

SAS University Edition

I was able to create PERM.<FILENAME> (thank you!) and am now trying to create Summary Statistics. Once I get this step down, I will be able to tackle creating graphs. When I right-cick Analysis variables "+" icon to choose columns, there are none to chose from!

My file has two columns: one is column for date, the other is column for rational numbers.

Re: Trying to create Summary Statistics from PERM..

andreas_lds — Fri, 05 Jul 2019 04:54:05 GMT

Non of the variables seems to be numeric. Please show the data you have. "Show" means: post a data step with the data in datalines-statement.

Re: Trying to create Summary Statistics from PERM..

BigDisty — Fri, 05 Jul 2019 05:38:14 GMT

Using SAS is like a new language, so I don't know if my response is going to make any sense to you; you seem like an advanced user. There is no dataline statement, no statement of any kind. I've only gotten to the step of pointing clicking

This is what I'm doing:

Tasks and Utilities --> Tasks --> Statistics --> (double click) Summary Statistics

DATA drop down

PERM.<filename>

ROLES

*Analysis variables:

(right-click on "+" to add columns

Without columns I can't create my summary statistic.

Re: Trying to create Summary Statistics from PERM..

andreas_lds — Fri, 05 Jul 2019 05:55:34 GMT

@BigDisty wrote:

Using SAS is like a new language, so I don't know if my response is going to make any sense to you; you seem like an advanced user. There is no dataline statement, no statement of any kind. I've only gotten to the step of pointing clicking

This is what I'm doing:

Tasks and Utilities --> Tasks --> Statistics --> (double click) Summary Statistics

DATA drop down

PERM.<filename>

ROLES

*Analysis variables:

(right-click on "+" to add columns

Without columns I can't create my summary statistic.

Without seeing the structure of the data you have it is impossible to find a solution.

Re: Trying to create Summary Statistics from PERM..

Reeza — Fri, 05 Jul 2019 15:14:24 GMT

1. Restart SAS Studio

2. If the issue persists please show some screen shots of what you're doing - and make sure your input data is being read correctly and has both numeric and character variables.

@BigDisty wrote:

Using SAS is like a new language, so I don't know if my response is going to make any sense to you; you seem like an advanced user. There is no dataline statement, no statement of any kind. I've only gotten to the step of pointing clicking

This is what I'm doing:

Tasks and Utilities --> Tasks --> Statistics --> (double click) Summary Statistics

DATA drop down

PERM.<filename>

ROLES

*Analysis variables:

(right-click on "+" to add columns

Without columns I can't create my summary statistic.

Re: Trying to create Summary Statistics from PERM..

ballardw — Mon, 08 Jul 2019 20:43:18 GMT

It might help to describe how you created that data set.

If possible poste code generated as shown in the log from a point-and-click approach.

If you used a wizard or anything "automated" it is not unlikely that due to the actual content of your data that no numeric (i.e. analysis) variables were created. Some things that can occur in data sources that can cause this are special characters or anything not numeric such as codes like "NA" "N/A" "NULL" or "MISSING" in a column that should be mostly numeric.

Depending on the actual content of the file there are ways around that but will likely require additional work and possibly actually writing code.

If your "rational" numbers were written in the form of fractions such as 1/2 then that is a non-standard value to read as numeric.

Since you say that your "date" also does not appear in the list then that may also have some non-standard appearance as many common date formats would be read by SAS into a numeric variable with a date type format applied. You will almost certainly want the SAS date value to graph properly as most character valued "date" appearances do not sort properly.