Attention : This code requires administrator privileges.
The code initiates a DATA step pointing to `sashelp.Orsales`. Writing to `sashelp` generally requires administrative privileges. Furthermore, the syntax `data sashelp.Orsales;;` contains a superfluous semicolon. The `where` instruction is present but, without a prior `set`, `merge` or `update` instruction, it has no incoming data to filter, which will likely result in an error or the creation of an empty/incorrect table.
Data Analysis
Type : SASHELP
The target table and the referenced columns (Total_Retail_Price, Profit) belong to the standard SASHELP.ORSALES dataset.
1 Code Block
DATA STEP Data
Explanation : Attempts to redefine the `sashelp.Orsales` table. The `WHERE` filter specifies conditions on `Total_Retail_Price` and `Profit`. The absence of a data source (`SET`) makes the operation logically invalid for standard filtering.
Copied!
data sashelp.Orsales;;
where Total_Retail_Price ="Total" and Profit="prof";
run;
1
2
DATA sashelp.Orsales;
3
;
4
where Total_Retail_Price ="Total" and Profit="prof";
5
RUN;
6
This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.
SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. WeAreCAS is an independent community site and is not affiliated with SAS Institute Inc.
This site uses technical and analytical cookies to improve your experience.
Read more.