topic Re: ANOVA Task and Work Library in SAS Studio

ANOVA Task and Work Library

james12 — Sun, 24 Jun 2018 01:32:19 GMT

Hello SAS Community,

I am using Fire Fox. Connecting to SAS Studio is not my problem. Frist step; Import a Excel file using a snippet. Second step: Convert Excel file to a WORK library file. Third step: PROC IMPORT and PROC PRINT the file in the WORK library. Forth step: Try (not successful) to do ANOVA using the One-Way ANOVA from Tasks. Tasks will not allow entry WORK library files. Looking for a way to run Task functions on files in the WORK library.

Thank for your ideas.

Best regards,

James

Re: Not Able to Connect with SAS Studio

ChrisBrooks — Sat, 23 Jun 2018 23:27:19 GMT

Hi James - I'd recommend posting this as a new topic, you're likely to get more people jumping in with answers as the connection issue that the OP reported is well known and many people may not read the thread once they see it has been responded to.

You should also if possible attach screenshots of your log, sample data and task settings as otherwise we won't be able to help you but for the record there's no reason why you shouldn't be able to run Custom Tasks against files in the work area.

Re: Not Able to Connect with SAS Studio

james12 — Sat, 23 Jun 2018 23:46:15 GMT

Not interested in custom tasks. Just want to use the One-Way ANOVA in the Task functions section on a file in the WORK library, when in SAS Studio. New to SAS blogs, and not sure how to navigate.

Thanks for your advice.

Best regards,

James

Re: ANOVA Task and Work Library

Reeza — Sun, 24 Jun 2018 01:34:00 GMT

I just tested this in SAS Studio (latest release) and it works for me. Can you please post several screenshots:

Image of work library with data sets in it
Image of ANOVA task and no WORK library and any error messages you get.

For example, here's my screen shot of the ANOVA task, with a dataset from the work library:

@james12 wrote:

Hello SAS Community,

I am using Fire Fox. Connecting to SAS Studio is not my problem. Frist step; Import a Excel file using a snippet. Second step: Convert Excel file to a WORK library file. Third step: PROC IMPORT and PROC PRINT the file in the WORK library. Forth step: Try (not successful) to do ANOVA using the One-Way ANOVA from Tasks. Tasks will not allow entry WORK library files. Looking for a way to run Task functions on files in the WORK library.

Thank for your ideas.

Best regards,

James

Re: ANOVA Task and Work Library

Reeza — Sun, 24 Jun 2018 01:36:40 GMT

@james12 wrote:

Hello SAS Community,

Frist step; Import a Excel file using a snippet.

Second step: Convert Excel file to a WORK library file.

Third step: PROC IMPORT and PROC PRINT the file in the WORK library.

Forth step: Try (not successful) to do ANOVA using the One-Way ANOVA from Tasks. Tasks will not allow entry WORK library files.

Step 1+2 seem the same as Step 3 unless you're referencing different files? If you did this, it's possible you accidentally destroyed your SAS data set and it doesn't exist anymore or something. The steps above all completed successfully and without errors?

Once a SAS data set is imported, via a Snippet or PROC IMPORT it's either in a WORK or permanent library (depending on the code) and you shouldn't need to import it again.