Hello,

It's been awhile since I've been in here. However, I am hoping someone can help me figure an issue I am having with my SAS PC v9.1.3 SP 4.

I have been importing data from a MySQL database, cleaning it up, formatting, etc. for a weekly update into a Master.SASDataset. However, when I want to review the data prior to the update by using a Proc Print statement, I receive one page of output and the program hangs. I cannot review the entire output.

Below is copy of the SAS log, including the code just prior to the Proc Print statement.
3413 Proc Sort data=SQLTimeSched;
3414 by ID ;
3415 Run;

NOTE: There were 214 observations read from the data set WORK.SQLTIMESCHED.
NOTE: The data set WORK.SQLTIMESCHED has 214 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds


3416 Proc Print data=SQLTimeSched n;
3417 var ID Testdate Tester Type Appoint HR LID;
3418
3419 run;

ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 73 observations read from the data set WORK.SQLTIMESCHED.
NOTE: PROCEDURE PRINT used (Total process time):
real time 6.59 seconds
cpu time 0.20 seconds


You can see I finally halt the Proc Print at the Error statement, but that was after three minutes of waiting for an output of 214 obs and 11 variables.

Any ideas? I am sure it is something simple. I just don't know what I am looking for.

Any help or suggestions would be appreciated.

Thanks,

Scot

Are you repeatedly getting this error?. what about printing other datasets?

It only seems to happen when trying to print more than 36 obs. If I place an obs=5 option in the Proc Print statement, it works fine. In the log above it looks like it got to obs 73, out of 214 before hanging.

Any ideas of what I should look at here?

The first page is fine, just no subsequent pages.