20.CONTROLLING/HOLDING THE VARIABLES

              20.CONTROLLING/HOLDING THE VARIABLES WHEN A RECORD LOADS

--MULTIPLE INPUT STATEMENTS

--LINE POINTER ( / )METHOD

--SINGLE( @ ) TRAILING AND DOUBLE ( @@ ) TRAILING

1--MULTIPLE INPUT STATEMENTS

DATA SAS;

LENGTH FNAME LNAME $25

       CITY$ 30 STATE$3 NUMBER$ 9;

INFILE "C:\Users\Desktop\SINGLE.txt" DLM=',';

INPUT FNAME$ LNAME$;

INPUT CITY$ STATE$;

INPUT NUMBER$;

RUN;

PROC PRINT;

RUN;

2--LINE POINTER ( / )METHOD

DATA SAS1;

LENGTH FNAME LNAME $25

       CITY$ 30 STATE$3 NUMBER$ 9;

INFILE "C:\Users\Desktop\SINGLE.txt" DLM=',';

INPUT FNAME$ LNAME$ / CITY$ STATE$ / NUMBER;

RUN;

PROC PRINT;

RUN;

3--SINGLE( @ ) TRAILING ::: HOLD THE RECORD FOR THE NEXT "INPUT" STATNT

      AND LOAD THE RECORD

DATA SAS11;

LENGTH FNAME LNAME $25

       CITY$ 30 STATE$3 NUMBER$ 9;

INFILE "C:\Users\Desktop\SINGLE.txt" DLM=',';

INPUT  FNAME$ LNAME$

       CITY$ STATE$

       NUMBER@;

RUN;

PROC PRINT;

RUN;

4--DOUBLE ( @@ ) TRAILING::: HOLD THE RECORD UNTIL THE END OF THE RECORD/FILE

DATA SAS121;

LENGTH FNAME LNAME $25

       CITY$ 30 STATE$3 NUMBER$ 9;

INFILE "C:\Users\Desktop\SINGLE.txt" DLM=',';

INPUT  FNAME$ LNAME$

       CITY$ STATE$

       NUMBER$;

RUN;

PROC PRINT;

RUN;

DATA WW;

LENGTH ID $ 8;

INFILE "C:\Users\Desktop\DOUBLE.txt";

INPUT ID$ NUM @@;

RUN;

PROC PRINT;

RUN;

WHAT IS _NULL_?

--PROGRAM WILL RUN SUCCESSFULLY BUT "DATASET" WILL NOT BE CREATED

DATA _NULL_;

SET SASHELP.CLASS;

WHERE AGE GE 14;

RUN;

PROC PRINT;

RUN;

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

--JOIN US IN TELEGRAM CHANNEL FOR MORE UPDATES

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