View libname.memname was terminated due to errors

Phil_NZ — Sat, 13 Mar 2021 00:04:06 GMT

Hi all SAS Users,

Today I faced a strange problem. The log does not announce the error but the Output data announces error.

I posted here a part of my code and the log of this one, if it is still ambiguous, please let me know how to clarify it better. Thanks in advance.

So, the dataset of interest here is vw_amihud

The only code relevant to this dataset in my whole code

data vw_amihud/ view=vw_amihud;
	set inter;
		by gviidkey;
		lagsum_ann_mar_cap=ifn(first.gviidkey,.,lag(sum_ann_mar_cap));
		lagann_mar_cap=ifn(first.gviidkey,.,lag(ann_mar_cap));
		vw_amh=amihud*lagann_mar_cap/lagsum_ann_mar_cap;
run;

proc means data=_w.vw_amihud noprint nway;
	class LOC year;
	var vw_amh;
	output out=agg_amihud_vw sum=agg_amh_vw;
run;

The associated log is

190        data vw_amihud/ view=vw_amihud;
191        	set inter;
192        		by gviidkey;
193        		lagsum_ann_mar_cap=ifn(first.gviidkey,.,lag(sum_ann_mar_cap));
194        		lagann_mar_cap=ifn(first.gviidkey,.,lag(ann_mar_cap));
195        		vw_amh=amihud*lagann_mar_cap/lagsum_ann_mar_cap;
196        run;

NOTE: DATA STEP view saved on file WORK.VW_AMIHUD.
NOTE: A stored DATA STEP view cannot run under a different operating system.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

197        
198        proc means data=_w.vw_amihud noprint nway;
199        	class LOC year;
200        	var vw_amh;
201        	output out=agg_amihud_vw sum=agg_amh_vw;
202        run;

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).
      22251 at 1921:16   
NOTE: View _W.VW_AMIHUD.VIEW used (Total process time):
      real time           0.05 seconds
      cpu time            0.06 seconds
      
NOTE: There were 52169 observations read from the data set WORK.INTER.
NOTE: There were 52169 observations read from the data set _W.VW_AMIHUD.

And there is no errors or warning, or strange note here from my standpoint

However, after running the whole code, it announces this error. I checked for all outputs and only this output is unable to be opened (announcing errors)

Can you please help me to sort it out?

Warm regards.

UPDATE: When I delete the view=v_amihud

data vw_amihud; /* deleted view=vw_amihud*/
	set inter;

The code run smoothly, but now, vw.amihud is under view output even I no longer set it by view option

Re: View libname.memname was terminated due to errors

Sajid01 — Sun, 14 Mar 2021 17:14:23 GMT

Hello
SAS data step views are compiled executables and cannot work in a different operating system.

This is the reason for this statement. "NOTE: A stored DATA STEP view cannot run under a different operating system".

If it is desired to run the view on a different operating system, it is better to copy the source code and recreate the view.
Have a look here
https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=engsas7bdat&docsetTarget=n1h8ok8rj6uzqkn18tpnp1lb4lp9.htm&locale=en

Re: View libname.memname was terminated due to errors

ChrisNZ — Mon, 15 Mar 2021 08:23:23 GMT

If you can reproduce the behaviour predictably, contact tech support. I've never seen that message.

topic Re: View libname.memname was terminated due to errors in SAS Programming

View libname.memname was terminated due to errors

Re: View libname.memname was terminated due to errors

Re: View libname.memname was terminated due to errors