Problem Note 63342: BY-group processing for a DATA step that runs in SAS® Cloud Analytic Services (CAS) against a view can generate an incorrect number of observations
 |  |  |  |  |
Using BY-group processing in a DATA step running in CAS to conditionally generate observations from a view can result in an incorrect number of observations in the output data set.
Using the FIRST. or LAST. variables to conditionally output observations from a view that is running in CAS can create an incorrect number of observations. The number of observations can change with each execution of the code.
In the following example, CASUSER.CARSVIEW is a view that is located in the CASUSER caslib. The view was created from the SASHELP.CARS data set. Running the following DATA step in CAS then results in more observations than the expected 38 observations:
set casuser.carsview;
by make;
if first.make;
run;
The workaround is to create a data set from the view before using BY-group processing to subset the data.
set casuser.carsview;
run;
set casuser.carsdata;
by make;
if first.make;
run;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.4 | 3.5 | ||