Hi.….when I run the attached code for 200 records it seems to work fine but when I re-run it for 500 records it doesn't run. Any suggestions why this might be occurring. Thanks.
data wan (drop = _:) ;
set wan2 ;
_minym = input (put (start_yrmo, 6.), yymmn6.) ;
do _n_ = 1 by 1 until (_minym = input(put(end_yrmo,6.),yymmn6.)) ;
output ;
_minym = intnx ("mon", _minym, 1) ;
start_yrmo = input(put (_minym, yymmn6.),6.);
end ;
run ;
Log Outputs:
64
65 data wan (drop = _:) ;
66 set wan2(obs=200) ;
67 _minym = input (put (start_yrmo, 6.), yymmn6.) ;
68 do _n_ = 1 by 1 until (_minym = input(put(end_yrmo,6.),yymmn6.)) ;
69 output ;
70 _minym = intnx ("mon", _minym, 1) ;
71 start_yrmo = input(put (_minym, yymmn6.),6.);
72 end ;
73 run ;
NOTE: There were 200 observations read from the data set WORK.WAN2.
NOTE: The data set WORK.WAN has 901 observations and 10 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
64
65 data wan (drop = _:) ;
66 set wan2(obs=1000) ;
67 _minym = input (put (start_yrmo, 6.), yymmn6.) ;
68 do _n_ = 1 by 1 until (_minym = input(put(end_yrmo,6.),yymmn6.)) ;
69 output ;
70 _minym = intnx ("mon", _minym, 1) ;
71 start_yrmo = input(put (_minym, yymmn6.),6.);
72 end ;
73 run ;
NOTE: Invalid argument to function INPUT at line 71 column 19.
NOTE: The DATA step has been abnormally terminated.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
2290719 at 70:15
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 70:15 120012 at 71:19
NOTE: There were 459 observations read from the data set WORK.WAN2.
... View more