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