Posts

Showing posts from April, 2025

165.MASTERING E-COMMERCE ORDER FULFILLMENT ANALYTICS USING SAS | FROM DATA CREATION WITH PROC DATA TO INSIGHTFUL REPORTING WITH PROC REPORT | LEVERAGING PROC CONTENTS | PROC PRINT | PROC SQL | PROC EXPORT | PROC MEANS | PROC FREQ | PROC SGPLOT | PROC REPORT | ENHANCED WITH MACROS FOR AUTOMATION

-
MASTERING E-COMMERCE ORDER FULFILLMENT ANALYTICS USING SAS | FROM DATA CREATION WITH PROC DATA TO INSIGHTFUL REPORTING WITH PROC REPORT | LEVERAGING PROC CONTENTS | PROC PRINT | PROC SQL | PROC EXPORT | PROC MEANS | PROC FREQ | PROC SGPLOT | PROC REPORT | ENHANCED WITH MACROS FOR AUTOMATION  /*Creating a unique dataset centered around "E-commerce Order Fulfillment"*/ /*Dataset Overview: E-commerce Order Fulfillment*/ OrderID: Unique identifier for each order. CustomerID: Identifier for the customer placing the order. OrderDate: Date when the order was placed ShipDate: Date when the order was shipped. DeliveryDate: Date when the order was delivered. ProductID: Identifier for the product ordered. Quantity: Number of units ordered. UnitPrice: Price per unit of the product. ShippingCost: Cost incurred for shipping. OrderStatus: Current status of the order (e.g., Delivered, Shipped, Pending). Region: Geographic region of the delivery address. /*Creating the Dataset*/ data ecommerc...
Post a Comment
Read more

​164.BOOKSTORE SALES DATA ANALYSIS USING PROC SQL | PROC MEANS | PROC FREQ | PROC PRINT | PROC GCHART | PROC GPLOT | PROC EXPORT | MACROS

-
​ BOOKSTORE SALES DATA ANALYSIS USING PROC SQL | PROC MEANS | PROC FREQ | PROC PRINT | PROC GCHART | PROC GPLOT | PROC EXPORT | MACROS /*Creating a unique dataset and applying various SAS procedures, including SQL and  macros. We'll focus on a dataset related to bookstore sales.*/ /*Dataset Creation*/ data bookstore_sales;     infile datalines dlm=',' dsd;     input TransactionID : $10.           CustomerID : $8.           BookID : $10.           AuthorID : $8.           Genre : $15.           Price : 8.2           Quantity : 8.           TransactionDate : date9.;     format TransactionDate date9.; datalines; T001,C001,B001,A001,Fiction,299.99,1,01JAN2025 T002,C002,B002,A002,Non-Fiction,199.50,2,02JAN2025 T003,C001,B003,A003,Science,150.00,1,03JAN2025 T004,C003,B001,A001,Fiction,2...
Post a Comment
Read more

163.MASTERING THE GAMESALES DATASET IN SAS USING PROC IMPORT | PROC CONTENTS | PROC PRINT | PROC SORT | PROC MEANS | PROC FREQ | PROC UNIVARIATE | PROC CORR | PROC RANK | PROC STANDARD | PROC SQL | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC DATASETS | PROC EXPORT

-
MASTERING THE GAMESALES DATASET IN SAS USING PROC IMPORT | PROC CONTENTS | PROC PRINT | PROC SORT | PROC MEANS | PROC FREQ | PROC UNIVARIATE | PROC CORR | PROC RANK | PROC STANDARD | PROC SQL | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC DATASETS | PROC EXPORT /*Creating a unique dataset centered around video game sales data*/ /*Creating the GameSales Dataset*/ data GameSales;     length GameID $5 Title $30 Platform $10 Genre $15 Publisher $20;     input GameID $ Title &  Platform &  Genre &  Publisher & ReleaseYear NA_Sales EU_Sales JP_Sales Other_Sales;     datalines; G001 Adventure Quest  PC       Adventure  Epic Games     2018 1.2 0.8 0.5 0.3 G002 Battle Zone      PS4      Shooter    Activision     2019 2.5 1.7 0.6 0.4 G003 Cyber Rally      Xbox     Racing     Ubisoft  ...
Post a Comment
Read more