some of the common interview questions - calculate the age (use intck) find Nth transaction from a data set (use first.var) find second maximum transaction amount for each of the customers' (use proc sql sub query) diff. between intck and intnx diff. between nodup & nodupkey diff. between put & input arrays diff. between while loop and until loop you can check out the sas playlist to practice all of the above - ruclips.net/p/PL4GjoPPG4VqPRFh5PwCXwT0q1d6dERj4E
I like to thank you sir. It is very very helpful for me. I am learning using your video for last two weeks. Could you pls show the row%, column%, total% as well as expected value for each cell and chi square value for a two-day RxC table sir.
I believe PROC REPORT itself is part of advance SAS :) if you are interested in having video for all the topics, I recommend, check out this playlist which we keep on updating - ruclips.net/p/PL4GjoPPG4VqPRFh5PwCXwT0q1d6dERj4E other than this if you are interested in learning any of the specific topic.. feel free to comment that, we will try to make a video on that
Not sure if I understood your question... but if it is aobut finding grand total for all the columns under consideration, that's already happening at 22:38
Thank you so much I should like if you can teach us from the sample report template how to write code with using data steps and proc reports Thanks again for teaching in detail each step .
You can't take these reports in Tableau, however you can connect your SAS tables with Tableau and create the similar reports over there... In some when we start a series on Tableau, will cover this...
Hi, first of all thank u for this content. At 19.57, you used the filter statement where along with upcase character function, after running the code where function is executed but not upcase function ,why?
Not sure if I understood you question correctly, however, the line which is created is - where upcase(origin) in ("ASIA","EUROPE"); this is not to convert the values in origin column in upper case and show in the output... but to filter in the upper case.. which means no matter how the values are written in the given column (small, CAPITAL or Sentence) it will convert them all in buffer memory and match with the supllied values and perform the filter... hope this helps
@@learnerea thank you. And i see there are no videos to write proc templates for graphs, that would be really great if you could do that. Thank you in advance.
Yes please provide the diff for each category and detailed videos for all define statement
Loved your video! Thank you so much! Love from Berlin!
Glad you enjoyed it!
Thanks for the video, That's a very good explanation of the topic
Short, sweet and very informative content you provide.... 👍🏼
Glad you liked it!
Great work ..Nicely Explained...
Glad you liked it
Please do in detail define statement it was really helpful
Good explanation sir.
Pls do more advance in proc report sir.. Thanks🙏
Please do in detail define statement...it was really helpful.....I learn some Xtra tips from ur videos
Very nice explanation👍🏻Please find the detailed diff .. please share some interview tips n questions ASAP
some of the common interview questions -
calculate the age (use intck)
find Nth transaction from a data set (use first.var)
find second maximum transaction amount for each of the customers' (use proc sql sub query)
diff. between intck and intnx
diff. between nodup & nodupkey
diff. between put & input
arrays
diff. between while loop and until loop
you can check out the sas playlist to practice all of the above -
ruclips.net/p/PL4GjoPPG4VqPRFh5PwCXwT0q1d6dERj4E
Kindly make video on define and diff in detail
I like to thank you sir. It is very very helpful for me. I am learning using your video for last two weeks. Could you pls show the row%, column%, total% as well as expected value for each cell and chi square value for a two-day RxC table sir.
yes i want to learn creation of empty spaces at bottom of result so pls make video on it if possible....
This video is good. Pls post advanced as well...!
I believe PROC REPORT itself is part of advance SAS :)
if you are interested in having video for all the topics, I recommend, check out this playlist which we keep on updating - ruclips.net/p/PL4GjoPPG4VqPRFh5PwCXwT0q1d6dERj4E
other than this if you are interested in learning any of the specific topic.. feel free to comment that, we will try to make a video on that
KEEP ROCKING BRO
PLZ DO VIDEOS ON RT WORK EXPERIENCE IN SAS FIELD BRO..
Sir do complete video. Of define compute
soon
more details about how to do the computer for each column in the set
Not sure if I understood your question... but if it is aobut finding grand total for all the columns under consideration, that's already happening at 22:38
Thank you so much I should like if you can teach us from the sample report template how to write code with using data steps and proc reports
Thanks again for teaching in detail each step .
As soon as possible
sir, cant we get other statistics like median and std dev in proc report.....?
of course you can(have mentioned in the video as well), try that and let me know if you get any issue
Could you please explain
How To calculate Percentage of all row? And show percentage in summary as like grand total in proc report.
will try to cover in any of our videos
can you please make videos on how to take these sas reports into tableau for visualisation of these reports?It would be very helpful to us.
You can't take these reports in Tableau, however you can connect your SAS tables with Tableau and create the similar reports over there...
In some when we start a series on Tableau, will cover this...
Thank you! Where I can find the comments for doing the difference for each types as you mention at the end of the video? Thank you very much
Please give for more advance and difference for each
i given a like and subscribed the channel for u. thanks😂
Thank you
Please detail the define
Plz do a video on same report with all options and statement
alright, will do another part of it covering more options
Please do video on define statement ..sir
Sure will do so soon
Amazing
Thank you! Cheers!
Hi, first of all thank u for this content. At 19.57, you used the filter statement where along with upcase character function, after running the code where function is executed but not upcase function ,why?
Not sure if I understood you question correctly, however, the line which is created is -
where upcase(origin) in ("ASIA","EUROPE");
this is not to convert the values in origin column in upper case and show in the output... but to filter in the upper case.. which means no matter how the values are written in the given column (small, CAPITAL or Sentence) it will convert them all in buffer memory and match with the supllied values and perform the filter...
hope this helps
pls make more details video
Please tell diff for each type
please do detail define statement
Please make in details video
How would I calculate the total of all columns (like the rbreak after/summarize statement) but put those numbers at the end of each page break
Please have a look if this helps -
ruclips.net/video/Sq8j2oXsRME/видео.html
Please create video on proc report options
Any specific option, which you would like to understand
@@learnerea basic and advanced
Super sir
thank you very much.. glad it was helpful
How do we delete the grid lines in proc report while outputting them to RTF’s?
For that you can try ODS Styles... here is one document, which you can use as reference -
www.lexjansen.com/sesug/2017/RIV-31.pdf
@@learnerea thank you. And i see there are no videos to write proc templates for graphs, that would be really great if you could do that. Thank you in advance.
Thank you sir
pls upload some more detailed videos sir
Sure I will
DO MORE VIDEOS IN RT WORK
YES PLZ TELL THE DIFF
DO MORE VIDEOS
please detail define
DEFINE EACH STATS
shortcut for paranthesis
Not sure if I understood your problem, do you want paranthesis closes automatically
Detail yhe define
plz find
thanks for watching the video...
If you have any question, please describe
please detail define