BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phil_NZ
Barite | Level 11

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)

My97_0-1615588662161.png

 

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

My97_0-1615593839976.png

 

 

 

 

 

 

 

 

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
1 ACCEPTED SOLUTION

Accepted Solutions
ChrisNZ
Tourmaline | Level 20

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

View solution in original post

2 REPLIES 2
Sajid01
Meteorite | Level 14

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=... 

ChrisNZ
Tourmaline | Level 20

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 927 views
  • 2 likes
  • 3 in conversation