Copying From SAS Column Titles to Excel

[alc]

Hi

I am at the University.  This program has been running for more than 10 minutes.  It says autosave complete on the bottom left hand corner of the screen.  When I click on Output - (Untitled) I get a pulsing cursor and a blank screen.  How will I know when the program is finished?

Thanks

Al

[art297]

Are you running it from base SAS or EG?  Also, rather than looking at the output screen, take a look at the log.

[Tom]

If you copied the whole log it is waiting for you to submit a semi-colon to end the RUN statement so it can start the PROC.

[alc]

Thanks for replying.

Now it gives me the following error message:

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.

NOTE: SAS (r) Proprietary Software 9.2 (TS2M2)

      Licensed to UNIVERSITY OF RHODE ISLAND (T&R), Site 70008099.

NOTE: This session is executing on the W32_VSPRO  platform.

NOTE: SAS initialization used:

      real time           0.96 seconds

      cpu time            0.76 seconds

1    PROC EXPORT DATA=work.pps90

2

3                (firstobs=1600 obs=1900)

4

5              OUTFILE= "C:\WANT.XLS"

6

7              DBMS=EXCEL REPLACE;

8

9              SHEET="Rows1600_thru_1900";

10

11   RUN

12   PROC EXPORT DATA=work.pps90

13

14               (firstobs=1600 obs=1900)

15

16             OUTFILE= "C:\WANT.XLS"

17

18             DBMS=EXCEL REPLACE;

ERROR: Unrecognized form of the RUN statement.  Use either RUN; or RUN CANCEL;.

NOTE: The previous statement has been deleted.

19

20             SHEET="Rows1600_thru_1900";

21

22   RUN;

ERROR: Connect: The Microsoft Access database engine cannot open or write to the file ''. It is

       already opened exclusively by another user, or you need permission to view and write its

       data.

ERROR: Error in the LIBNAME statement.

Connection Failed.  See log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE EXPORT used (Total process time):

      real time           1:05:54.15

      cpu time            2.54 seconds

Do you have a suggestion?

Thanks

Al

[art297]

As Tom already mentioned, before you sent your post, you have to add a semicolon after the run statement.

[alc]

Hi

Of course!  Shows you how much I know!

The following error message occured after putting the semicolon:

NOTE: Copyright (c) 2002-2008 by SAS Institute Inc., Cary, NC, USA.

NOTE: SAS (r) Proprietary Software 9.2 (TS2M2)

      Licensed to UNIVERSITY OF RHODE ISLAND (T&R), Site 70008099.

NOTE: This session is executing on the W32_VSPRO  platform.

NOTE: SAS initialization used:

      real time           0.96 seconds

      cpu time            0.76 seconds

1    PROC EXPORT DATA=work.pps90

2

3                (firstobs=1600 obs=1900)

4

5              OUTFILE= "C:\WANT.XLS"

6

7              DBMS=EXCEL REPLACE;

8

9              SHEET="Rows1600_thru_1900";

10

11   RUN

12   PROC EXPORT DATA=work.pps90

13

14               (firstobs=1600 obs=1900)

15

16             OUTFILE= "C:\WANT.XLS"

17

18             DBMS=EXCEL REPLACE;

ERROR: Unrecognized form of the RUN statement.  Use either RUN; or RUN CANCEL;.

NOTE: The previous statement has been deleted.

19

20             SHEET="Rows1600_thru_1900";

21

22   RUN;

ERROR: Connect: The Microsoft Access database engine cannot open or write to the file ''. It is

       already opened exclusively by another user, or you need permission to view and write its

       data.

ERROR: Error in the LIBNAME statement.

Connection Failed.  See log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE EXPORT used (Total process time):

      real time           1:05:54.15

      cpu time            2.54 seconds

I have to pack it in for today.  Will try again tomorrow.

Thanks

Al

[art297]

Your log is showing that you ran the code twice, once without a semi-colon after the run statement, and once with a semi-colon after the run statement.  Do you have two sets of the code showing in your editor?

The system is never getting to the 2nd, correct version, as the initial error is throwing it off.  Ensure that you are only submitting one set of code and that the semicolon is present after the run statement.

[alc]

Hi

I think I made the changes in the program below as suggested and it failed to run.  The error logs are attached for your reference.

PROC EXPORT DATA=work.pps90

            (firstobs=1600 obs=1900)

            OUTFILE= "C:\WANT.XLS"

            DBMS=EXCEL REPLACE;

           SHEET="Rows1600_thru_1900";

   RUN;

I don;t want to be a pest but I have looked for someone locally to sit by the computer with me to get this task completed.  Most of the students at the University

seem to be skilled in other phases of SAS or unfamilar with the program. 

I am wondering if I am making a dumb newbie mistake.  For example, when I have run this program I have been in SAS 9.2.  There are 3 windows open, one on the left side and two above one another.  My file pps.90 is on a flash drive which is visible (the file pps90) in that left hand window that runs from the top of the screen to the bottom.  Should the file be someplace else?

Thank you.

Al

[art297]

There must be some kind of stray character in your code.  The following works perfectly for me:

PROC EXPORT DATA=sashelp.class

            (firstobs=3 obs=7)

          OUTFILE= "C:\art\WANT.XLS"

          DBMS=EXCEL REPLACE;

          SHEET="Rows3_thru_7";

RUN;

[alc]

Anything is possible.  I'll give it a try tomorrow.

Thanks

Al

[Ksharp]

Maybe you need an option "label" which to instead the name of variables.

PROC EXPORT DATA=want
            (firstobs=3 obs=7)
          OUTFILE= "C:\temp\WANT.XLS"
          DBMS=EXCEL REPLACE label; 
          SHEET="Rows3_thru_7";
RUN;

Ksharp

[alc]

Thank you for weighing in on my question.  I think I need to (1) follow though with Art's approach and then (2) add your suggestion just so I do not get too many changes going at one time.  I appreciate your help.  Please do not assume that I know anything about SAS.  My question about your comment is similiar to what I asked of Art:  don't I have to mention the file somewhere in the command?

Thanks

Al

[art297]

The SAS file you are trying to export is the one that follows data=

The file you are trying to create is the cone that follows: outfile=

[alc]

Hi

Just wanted to let you know that I was able to replicate the test that you sent which is a major accomplishment for me! Thanks

What I need to do now is assure that I am in the proper position to open pps90.  One of the changes you recommended that I try was PROC EXPORT DATA=work.pps90.  After my little success today, I tried to run the program using PROC EXPORT DATA=work.pps90.  I realized, I think,  that SAS might be looking for pps90 in the work file but it is not there; it is in my flash drive E.  So the question is do I have to bring pps90 into the work file or change the PROC EXPORT DATA statement so that SAS finds pps90 in the flash drive? I tried to copy and past pps90 into the SAS work file unsuccessfully.

Feels like I might be out of your hair soon!

Thanks for your help.

Al

[art297]

It sounds like your system is configured to send results to your flash drive.  Thus, since you have already discovered that, disregard my advice about looking in or accessing the work directory.