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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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