topic Re: Issue while running proc print in SAS Programming

Issue while running proc print

sas_td2016 — Sat, 25 Aug 2018 23:01:25 GMT

Hello Friends

I have issue running this query. It keep running. Is there anything wrong with this script? Your help is highly appreciated.

data highlow;
infile 'C:\Users\Documents\My SAS Files(32)\democode\temperature.txt';
input city $ state $
/ NormalHigh NormalLow
#3 RecordHigh RecordLow;
run;

proc print data=highlow;
Title 'High and Low Temperatures for July';
run;

this is the date:

Nome AK
55 44
88 29
Miami FL
90 75
97 65
Releigh NC
88 68
105 50

Re: Issue while running proc print

Shmuel — Sun, 26 Aug 2018 00:29:07 GMT

Please post your log when you have issues.

Are you sure it is in PROC PRINT and not at first step?

I suspect the special characters in the input path are causing the issue.

Try to rename the path into 'C:\Users\Documents\My SAS Files(32)\democode\' - (droping the '(32)').

Re: Issue while running proc print

Shmuel — Sun, 26 Aug 2018 01:10:26 GMT

otherwise, it may be that you have not submitted the last semicolon ';' - then sas in not running but waiting to close the RUN statement.

Re: Issue while running proc print

Reeza — Sun, 26 Aug 2018 02:43:45 GMT

Worked fine for me, so I suspect you have an issue elsewhere, or didn't submit the colon as suggested. I would end the process and restart SAS if necessary. A program like this should complete in less than a second. This of course, assumes, your text file isn't a few GB or something.

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 68         
 69         data highlow;
 70         infile cards;
 71         input city $ state $
 72         / NormalHigh NormalLow
 73         #3 RecordHigh RecordLow;
 74         
 75         cards;
 
 NOTE: The data set WORK.HIGHLOW has 3 observations and 6 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.01 seconds
       cpu time            0.01 seconds
       
 
 85         ;;;;
 86         run;
 87         proc print data=highlow;
 88         Title 'High and Low Temperatures for July';
 89         run;
 
 NOTE: There were 3 observations read from the data set WORK.HIGHLOW.
 NOTE: PROCEDURE PRINT used (Total process time):
       real time           0.03 seconds
       cpu time            0.03 seconds

Re: Issue while running proc print

sas_td2016 — Sun, 26 Aug 2018 12:08:07 GMT

Thanks everyone for the reply. This problem is solved. I restarted SAS and it works.

Thanks again Friends