119.DATA STEP | INPUT | PROC FREQ | TABLES | PROC EXPORT STATEMENTS

 DATA STEP | INPUT | PROC FREQ | TABLES | PROC EXPORT STATEMENTS

DATA Employees;

    INPUT Name $ Age Salary Address :$15. Company $ Experience;

    DATALINES;

    Alice 30 55000 NewYork Google 5

    Bob 28 48000 California Amazon 3

    Carol 35 62000 Texas Microsoft 7

    John 37 65000 Florida IBM 10

    Emma 27 46000 Chicago Tesla 2

    David 40 75000 Washington Meta 15

    Sophia 29 53000 Seattle Apple 4

    Michael 33 60000 Boston Intel 6

    Olivia 31 58000 Denver Oracle 5

    Daniel 45 82000 Miami Cisco 20

    ;

RUN;

PROC PRINT DATA=Employees; 

RUN;

OUTPUT:

Obs	Name	Age	Salary	Address	Company	Experience
1	Alice	30	55000	NewYork	Google	5
2	Bob	28	48000	California	Amazon	3
3	Carol	35	62000	Texas	Microsof	7
4	John	37	65000	Florida	IBM	10
5	Emma	27	46000	Chicago	Tesla	2
6	David	40	75000	Washington	Meta	15
7	Sophia	29	53000	Seattle	Apple	4
8	Michael	33	60000	Boston	Intel	6
9	Olivia	31	58000	Denver	Oracle	5
10	Daniel	45	82000	Miami	Cisco	20

PROC FREQ DATA=Employees;

    TABLES Company;

RUN;

OUTPUT:

                                            The FREQ Procedure

Company	Frequency	Percent	Cumulative Frequency	Cumulative Percent
Amazon	1	10.00	1	10.00
Apple	1	10.00	2	20.00
Cisco	1	10.00	3	30.00
Google	1	10.00	4	40.00
IBM	1	10.00	5	50.00
Intel	1	10.00	6	60.00
Meta	1	10.00	7	70.00
Microsof	1	10.00	8	80.00
Oracle	1	10.00	9	90.00
Tesla	1	10.00	10	100.00

PROC FREQ DATA=Employees;

    TABLES Address;

RUN;

OUTPUT:

                                                      The FREQ Procedure

Address	Frequency	Percent	Cumulative Frequency	Cumulative Percent
Boston	1	10.00	1	10.00
California	1	10.00	2	20.00
Chicago	1	10.00	3	30.00
Denver	1	10.00	4	40.00
Florida	1	10.00	5	50.00
Miami	1	10.00	6	60.00
NewYork	1	10.00	7	70.00
Seattle	1	10.00	8	80.00
Texas	1	10.00	9	90.00
Washington	1	10.00	10	100.00

PROC EXPORT DATA=Employees

    OUTFILE="C:\Users\YourName\Desktop\Employees.csv"

    DBMS=CSV

    REPLACE;

RUN;

LOG:

NOTE:"C:\Users\YourName\Desktop\Employees.csv" file was successfully created.

NOTE: PROCEDURE EXPORT used (Total process time):

      real time           2.87 seconds

      cpu time            0.15 seconds

ADD SOME MORE STATEMENTS LIKE FORMAT , LABEL , TITLE ETC 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