14.PUT,FILE,TABULATE STATEMENTS

                             14.PUT,FILE,TABULATE STATEMENTS

--->WHAT IS THE DIFF B/W INPUT AND PUT  ?

INPUT : IT WRITES THE VARIABLES INFO IN SAS VARIABLES

PUT : IT WRITES VARIABLES FOR EXTERNAL ENVIRONMENT

            

--->WHAT IS THE DIFF B/W INFILE AND FILE ?

INFILE : IT IS USED FOR EXTERNAL DATASETS TO SAS ENVIRONMENT

FILE: IT IS USED PATH WHERE YOU WANT TO STORE THE RAW DATA

TO "READING" THE TEXT FILE INTO SAS::PROC IMPORT IN DATASTEP

DATA SAS;

INFILE "C:\Users\sumed\OneDrive\Desktop\CLASS.TXT";

INPUT NAME$ AGE GEND$ HT WT;

RUN;

PROC PRINT;

RUN;

TO "WRITE" SAS DATA TO EXTERNAL ENVIRONMENT:: PROC EXPORT IN DATASETP

--PUT:GIVE A VARIABLE INFO OF SAS DATASET

--FILE:WHERE WE CAN WRITE THE FILE/EXTERNAL FILE PATH

DATA SAS11;

SET SASHELP.CLASS;

FILE 'C:\Users\sumed\OneDrive\Desktop\CLASS12.txt';

PUT NAME AGE SEX HEIGHT WEIGHT;

RUN;

PROC PRINT;

RUN;

TO GET DIRECT OUTPUT OF TEXT FILE IN SAS ENVIRONMENT IN SEPARATE WINDOW?

--USE 'PROC FSLIST' 

PROC FSLIST FILEREF="C:\Users\OneDrive\Desktop\CLASS.TXT";

RUN;

PROC FSLIST FILEREF='C:\Users\OneDrive\Desktop\CLASS12.txt';

RUN;

PROC FSLIST FILEREF='C:\Users\Desktop\SALE.txt';

RUN;

********DIFF B/W PROC FREQ AND PROC TABULATE***********

-->FREQ:::IT WILL GIVE FREQ TABLES AND N-WAY TABLES

-->TABULATE:::IT WILL USED TO DISPLAY THE 'DESCRIPTIVE STATS' IN 'TABULAR FORMAT'

PROC FREQ DATA=SASHELP.CLASS;

TABLE SEX AGE;

RUN;

PROC TABULATE::::IT WILL USED TO DISPLAY THE 'DESCRIPTIVE STATS' 

                     IN 'TABULAR FORMAT'

PROC TABULATE DATA=SASHELP.CLASS;

CLASS SEX;

VAR AGE;

TABLE AGE SEX;

RUN;

PROC TABULATE DATA=SASHELP.CLASS;

CLASS SEX;

VAR AGE;

TABLE AGE;

RUN;

PROC TABULATE DATA=PROG1.SALES;

CLASS GENDER;

VAR SALARY;

TABLE SALARY GENDER;

RUN;

PROC TABULATE DATA=PROG1.SALES;

CLASS GENDER JOB_TITLE;

VAR SALARY;

TABLE SALARY*(N MEAN STD MIN MAX),GENDER,JOB_TITLE;

RUN;

--->TO GET DESCRIPTIVE STATS 

PROC TABULATE DATA=PROG1.SALES;

CLASS GENDER JOB_TITLE;

VAR SALARY;

TABLE SALARY*(N MEAN STD),GENDER,JOB_TITLE;

RUN;

--->TO GET THE TWO-WAY FREQ OUTPUT

PROC TABULATE DATA=PROG1.SALES;

CLASS GENDER JOB_TITLE;

VAR SALARY;

TABLE SALARY*(COLPCTN MAX ROWPCTN),GENDER,JOB_TITLE/BOX='MEAN OF SALARY';

RUN;

--->CHANGING THE LABELS OF EXISTING VARIABLES

PROC TABULATE DATA=PROG1.SALES;

CLASS GENDER;

VAR SALARY;

TABLE SALARY='EMP SALARY' GENDER='SEX' SALARY*MEAN='MEAN OF SALARY';

RUN;

PROC TABULATE DATA=SASHELP.CLASS;

CLASS SEX WEIGHT ;

VAR HEIGHT AGE;

TABLE HEIGHT*(N MEAN),SEX;

RUN;

           PLEASE FOLLOW THE BLOG AND ENCOURAGE US TO DO MORE...

                                      THANK  YOU FOR VISITING...