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
If you can reproduce the behaviour predictably, contact tech support. I've never seen that message.
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=...
If you can reproduce the behaviour predictably, contact tech support. I've never seen that message.
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!
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.