96.INPUT | PROC SQL | SUM | MIN | MAX OPTIONS

-

                INPUT | PROC SQL | SUM | MIN | MAX OPTIONS


DATA SALES;

 INPUT NAMES$ PRODUCT$ COST PROFIT;

 CARDS;

 HARISH SHIRT 200 30

 NAVEEN CYCLE 550 250

 VINAY HEN 50 30

 ARUN CAP 240 60

 RAJ BIKE 1500 500

 ;

RUN;

PROC PRINT;RUN;


OUTPUT:

                                       The SAS System

Obs NAMES PRODUCT COST PROFIT
1 HARISH SHIRT 200 30
2 NAVEEN CYCLE 550 250
3 VINAY HEN 50 30
4 ARUN CAP 240 60
5 RAJ BIKE 1500 500


PROC SQL;

 SELECT *,SUM(COST) AS TOTALCOST,SUM(PROFIT) AS TOTALPROFIT,MIN(PROFIT) AS MINPROFIT,

        MAX(PROFIT) AS MAXPROFIT

 FROM SALES;

QUIT;


OUTPUT:
                                                The SAS System

NAMES PRODUCT COST PROFIT TOTALCOST TOTALPROFIT MINPROFIT MAXPROFIT
HARISH SHIRT 200 30 2540 870 30 500
NAVEEN CYCLE 550 250 2540 870 30 500
VINAY HEN 50 30 2540 870 30 500
ARUN CAP 240 60 2540 870 30 500
RAJ BIKE 1500 500 2540 870 30 500

MAKE CHANGES TO THIS SYNTAX AND COMMENT YOUR CODE...


-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM  CHANNEL FOR MORE UPDATES

   CLICK HERE : https://t.me/SasAll4You

Comments

Post a Comment

Popular posts from this blog

397.If a satellite has excellent signal strength but very high latency, can it still deliver good quality communication? Why or why not?A Sas Study

-
Image
If a satellite has excellent signal strength but very high latency, can it still deliver good quality communication? Why or why not?A Sas Study -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- HERE IN THIS PROJECT WE USED THESE SAS STATEMENTS — DATA STEP | PROC SQL |  PROC PRINT | PROC SGPLOT | MACROS | PROC CORR | PROC MEANS | PROC FREQ | PROC UNIVARIATE | SET | APPEND | PROC TRANSPOSE | PROC DATASETS DELETE | DATA FUNCTIONS -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- INTRODUCTION Satellite communication is a backbone of modern connectivity—supporting  GPS, TV broadcasting, military operations, disaster management, banking, a...
Read more

401.How Efficient Are Global Data Centers? A Complete SAS Analytics Study

-
Image
How Efficient Are Global Data Centers? A Complete SAS Analytics Study -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- HERE IN THIS PROJECT WE USED THESE SAS STATEMENTS — DATA STEP | PROC SQL |  PROC PRINT | PROC SGPLOT | MACROS | PROC CORR | PROC MEANS | PROC FREQ | PROC UNIVARIATE | APPEND PROC TRANSPOSE | PROC DATASETS DELETE | DATA FUNCTIONS -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1. INTRODUCTION Modern data centers are the backbone of cloud computing, AI, banking, healthcare, and government systems. They consume massive power, require efficient cooling, and must ensure zero downtime . This project simulates global data c...
Read more

383.Which Pharma Distributors Are High-Risk? Can SAS Detect Delays, Temperature Violations, and Fraud?

-
Image
Which Pharma Distributors Are High-Risk? Can SAS Detect Delays, Temperature Violations, and Fraud? HERE IN THIS PROJECT WE USED THESE SAS STATEMENTS — DATA STEP | PROC SQL |  PROC PRINT | PROC SGPLOT | MACROS | PROC CORR | PROC MEANS | PROC FREQ | PROC UNIVARIATE | APPEND | PROC SORT | PROC DATASETS DELETE Introduction: In the pharmaceutical industry, distributing medicines safely and on time is just as important as manufacturing them. Drugs must travel through multiple distributors, regions, and storage conditions before reaching hospitals and patients. During this process, companies must track shipment delays, temperature control, and regulatory compliance to ensure that every medicine remains safe and effective. Contents: * Understanding Drug Distribution Channels * Creating the Drug Shipment Dataset in SAS * Using Date Functions (MDY, INTNX, INTCK) for Delivery Analysis * Cleaning and Formatting Data with SAS Functions * Distributor Utilization Classification Using Macros * Fra...
Read more