Could you please explain how to sum of data in a column ? Like the sales example, you hsowed us to find out the max n min form Jan to Dec. What is I wnat to fina out the total sale for each month?
hi, your videos are great platform to learn SAS. just one thing, is there any way sort out this audio issue in some of your videos? it will be a great help. thank you. 🙂
Thankyou for watching this, yes this is the problem with some of the videos, unfortunately, to your disappointment, TH-cam is not providing any facility to make corrections may be we will try to upload the copy of this with better sound quality
Bro There are only 3 statements in Arrays IN, OF , DO LOOPS, or else any included ? Im completely depending on your videos bro. Pls comment if any other bro pls
Hi Man, Can you please help me in identifying whats wrong in the below code? data sas; set sashelp.applianc ;
array Alu [*] units_1-units_22; do i= 1 to 22; if (Alu(i) > 20) then sum=(of Alu (*)) ; output; end; run; 76 ERROR 388-185: Expecting an arithmetic operator. ERROR 76-322: Syntax error, statement will be ignored.
Hi @sudhanshu Like the error itself suggests "Expecting an arithmetic operator" all you need to do is use the sum function after equal sign, just like below: if (Alu(i) > 20) then sum=sum(of Alu (*)) ;
@@xcetam Try below: data testing2; set sashelp.applianc; array alu[*] units_1 - units_22; array alu_new {22}; do i = 1 to dim(alu); if alu(i)>20 then alu_new(i) = alu(i); end; sum_total = sum(of alu_new1-alu_new22); drop alu_new1-alu_new22 i; run;
Hi Raji Sri, Apologies for the inconvenience, we will try this not to happen in the upcoming videos. Alternatively, please use the headphones for better performance
Hi Poonam, Thanks for watching this. Yes it's an identified issue which havppened because of some technical glitch and we are taking care of the same in all of the upcoming videos. Unfortunatlly we can not make any changes in the existing one. Hope you like other videos
Hi Weapon... It happened because of the technical glitches which are being taken care of upcoming videos... hope you don't get similar inconvenience in all those videos
Very good reference.
This was well worth my time... saving this one for reference!!
Glad, it was helpful
I am freshly start sas your video help more than Institute sir 😍 thank 🙏
Glad it was helpful
15:41 array x(7) day1-day7;
Why $ sign is not used while creating the array as all elements are character value here ( A or P is character)
Hello ,this was so informative you have given me tricks ,I appreciate sir.
Glad you liked it
Way of presentation is very good.
Nice class
Glad you liked it
Wonderful insight. Thanks sir
very helpful! thank you!
I'm glad you liked it
Could you please explain how to sum of data in a column ? Like the sales example, you hsowed us to find out the max n min form Jan to Dec. What is I wnat to fina out the total sale for each month?
This is Best class I even been listening.
Can you start classes About ODS please?
And graphs also....
Thank you for your kind words bustop b. We will definitely make videos on ODS as well once we are done with what we already have in our bucket
@@learnerea Oh.. Thank you
thank you very much this was very helpful but the voice was very low
Please add classes on R programming in sas
this video has very low volume, is it possible to fix it? Also can you add a full detail video on proc report please?
Hi Thanks for the explaination.
Glad you liked it 🙏🏻
why we didn't use ($) in array syntax while looking for IN Operator example? the observation are of character type in a1-a10 variables
Can you please share video of proc report in detail if possible.
In the presence data set,you did not use the $ as day1-day2 is character value as you mentioned while explaining the syntax?
hi, your videos are great platform to learn SAS. just one thing, is there any way sort out this audio issue in some of your videos? it will be a great help. thank you. 🙂
Thankyou for watching this, yes this is the problem with some of the videos, unfortunately, to your disappointment, TH-cam is not providing any facility to make corrections may be we will try to upload the copy of this with better sound quality
worth those 30 min to learn arrays and do loop
Glad it was helpful
This was almost perfect, couldn't hear a thing though and that diminished my experience of this video.
Apologies for the sound issue
Bro
There are only 3 statements in Arrays
IN, OF , DO LOOPS,
or else any included ?
Im completely depending on your videos bro.
Pls comment if any other bro pls
Hi Man,
Can you please help me in identifying whats wrong in the below code?
data sas;
set sashelp.applianc ;
array Alu [*] units_1-units_22;
do i= 1 to 22;
if (Alu(i) > 20) then sum=(of Alu (*)) ;
output;
end;
run;
76
ERROR 388-185: Expecting an arithmetic operator.
ERROR 76-322: Syntax error, statement will be ignored.
Hi @sudhanshu
Like the error itself suggests "Expecting an arithmetic operator"
all you need to do is use the sum function after equal sign, just like below:
if (Alu(i) > 20) then sum=sum(of Alu (*)) ;
@@learnerea thanks man. But the problem is it's not filtering for values gt than 20 from units_1 to 24.
@@xcetam Try below:
data testing2;
set sashelp.applianc;
array alu[*] units_1 - units_22;
array alu_new {22};
do i = 1 to dim(alu);
if alu(i)>20 then alu_new(i) = alu(i);
end;
sum_total = sum(of alu_new1-alu_new22);
drop alu_new1-alu_new22 i;
run;
@@learnerea Thanks Man :)
FOr some reason it is not filtering values gt 20 and thats the issue. With this code also its the same issue:(
The class is very good. But the audio is too low. Can you please look into it
Hi Raji Sri,
Apologies for the inconvenience, we will try this not to happen in the upcoming videos. Alternatively, please use the headphones for better performance
sound is very low ..
Hi Poonam,
Thanks for watching this. Yes it's an identified issue which havppened because of some technical glitch and we are taking care of the same in all of the upcoming videos. Unfortunatlly we can not make any changes in the existing one.
Hope you like other videos
Audio Volume very low in video
appologies for that
hi , i just started watching your video to learn about array ,, can you please increase you voice pitch ,, its too low.
apologies, it happened because of some technical issue which will be taken care of in subsequent videos
@@learnerea Yes voice is very low not able to understand even headphones please re upload the same
Sound is less I can't hear
Sorry for that inconvenience.... has been taken care of in the upcoming videos
Very bad audio quality..
Sound not proper
Hi Weapon...
It happened because of the technical glitches which are being taken care of upcoming videos... hope you don't get similar inconvenience in all those videos
Bad audio
feedback taken