bro nice explanation .. but i have a doubt that input buffer is created in both situations when we use input statement either reading external file or sas dataset..but you are saying that input buffer is created only when reading external files by using input..i think it is not correct.just check. data dm; infile 'E:\mk\ymk.txt'; input id age sal; run; That txt file contain data is.. 001 23 3000 002k 25 5000 and log is.. 184 185 data dm; 186 infile 'E:\mk\ymk.txt'; 187 input id age sal; 188 run; NOTE: The infile 'E:\mk\ymk.txt' is: Filename=E:\mk\ymk.txt, RECFM=V,LRECL=32767,File Size (bytes)=25, Last Modified=06 October 2019 13:54:24, Create Time=03 October 2019 21:43:33 NOTE: Invalid data for id in line 2 1-4. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8 2 002k 25 5000 12 id=. age=25 sal=5000 _ERROR_=1 _N_=2 NOTE: 2 records were read from the infile 'E:\mk\ymk.txt'. The minimum record length was 11. The maximum record length was 12. NOTE: The data set WORK.DM has 2 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds data dm1; input id age name sal; cards; 101 22 sham 2200 102 23 ravi 2300 ; run; log is... 189 190 data dm1; 191 input id age name sal; 192 cards; NOTE: Invalid data for name in line 193 8-11. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+---- 193 101 22 sham 2200 id=101 age=22 name=. sal=2200 _ERROR_=1 _N_=1 NOTE: Invalid data for name in line 194 8-11. 194 102 23 ravi 2300 id=102 age=23 name=. sal=2300 _ERROR_=1 _N_=2 NOTE: The data set WORK.DM1 has 2 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds 195 ; 196 run; IF AM WRONG CORRECT ME BRO THANK YOU IN ADVANCE
I thik input buffer is nothing but a temporary memory that holds the data to be executed. So while reading a raw data file input buffer comes into role because the data will be hold there until it gets executed and while reading sas data set input buffer is not required because it already in sas work library or in any library if you created a library so in this case work library react as input buffer because the data is in work library and while excutaion it reads the data from work library... correct me if i am wrong
Thanks
Thank you @Analytics School
need more videos from you soon complete base sas and advanced sas . Thank you for your great efforts making to learn sas easily.
Hi Amjad, I am working and it also takes 4 to 5 hours to prepare a video. I will try my level best to increase the frequency of videos.
I have cleared my technical round because of your videos.. perfect explanation within short duration...
Great 👍
Thank you, well explaining the topic
Glad it was helpful!
What was that loop called??
Very good thank you.
Much easier to understand.
bro nice explanation .. but i have a doubt that input buffer is created in both situations when we use input statement either reading external file or sas dataset..but you are saying that input buffer is created only when reading external files by using input..i think it is not correct.just check.
data dm;
infile 'E:\mk\ymk.txt';
input id age sal;
run;
That txt file contain data is..
001 23 3000
002k 25 5000
and log is..
184
185 data dm;
186 infile 'E:\mk\ymk.txt';
187 input id age sal;
188 run;
NOTE: The infile 'E:\mk\ymk.txt' is:
Filename=E:\mk\ymk.txt,
RECFM=V,LRECL=32767,File Size (bytes)=25,
Last Modified=06 October 2019 13:54:24,
Create Time=03 October 2019 21:43:33
NOTE: Invalid data for id in line 2 1-4.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
2 002k 25 5000 12
id=. age=25 sal=5000 _ERROR_=1 _N_=2
NOTE: 2 records were read from the infile 'E:\mk\ymk.txt'.
The minimum record length was 11.
The maximum record length was 12.
NOTE: The data set WORK.DM has 2 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.03 seconds
data dm1;
input id age name sal;
cards;
101 22 sham 2200
102 23 ravi 2300
;
run;
log is...
189
190 data dm1;
191 input id age name sal;
192 cards;
NOTE: Invalid data for name in line 193 8-11.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----
193 101 22 sham 2200
id=101 age=22 name=. sal=2200 _ERROR_=1 _N_=1
NOTE: Invalid data for name in line 194 8-11.
194 102 23 ravi 2300
id=102 age=23 name=. sal=2300 _ERROR_=1 _N_=2
NOTE: The data set WORK.DM1 has 2 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
195 ;
196 run;
IF AM WRONG CORRECT ME BRO
THANK YOU IN ADVANCE
I thik input buffer is nothing but a temporary memory that holds the data to be executed. So while reading a raw data file input buffer comes into role because the data will be hold there until it gets executed and while reading sas data set input buffer is not required because it already in sas work library or in any library if you created a library so in this case work library react as input buffer because the data is in work library and while excutaion it reads the data from work library... correct me if i am wrong
Nice video
Thanks Vani!
Go slow...u speak very fast
Sure... Thanks for the feedback
adjust your video speed, problem solved.