SAS Tutorial | SAS SQL Methods and More

[@andreyilatovskiy7666]

At 54:38, the condition is " to_char(order_date, 'D') = '7' ", but in the log at 55:22 the condition is " to_char(order_date, 'D') = '1' ". Is this an error in the video? Also, I wonder if this condition should be used at all, given that the 'D' format element is locale-dependent in Oracle (controlled by the NLS_TERRITORY parameter), and value '7' might mean either Saturday or Sunday.

[@SASUsers]

Checking on this for you!

[@SASUsers]

Hi Andrey. Thank you for your question. You are correct. The program 2.sas.com/6052GShLY uses the value of ‘7’, and the screen shot code is checking for ‘1’ which is incorrect. Our guess is a demonstration of a different value of ‘1’ was being illustrated and that screen was saved as opposed to the correct one.

[@charushankar6180]

clear & well articulated. thanks John!

[@karencabaci1964]

Thank you for the knowledge sharing. The training is informative!

[@SASUsers]

So glad you found it helpful!

[@jarosawopala9340]

Very interesting tutorial. In the tutorial you use macros (%Benchmark; %Passinfo; %Benchmarkparse; %Benchmarkreport), which I don't see on my SAS 9.4 M6 system. Where can I download the definitions of these macros?

[@SASUsers]

Jaroslaw, thank you for your inquiry! We are researching this for you!

[@SASUsers]

Jaroslaw, This video tutorial was created from the SQL Methods and More class that we offer. You'll find the class on the public schedule here: 2.sas.com/6051KbA7t . The macro programs used in this tutorial were written specifically for this class and were stored in the AUTOCALL library on our classroom machine. The programs used in this tutorial are not available outside of our classroom labs.

[@cmellicious]

Where can I access the code and files referenced in this video, specifically the D:\Master Data folder?

[@SASUsers]

Checking for you!

[@cindyma5366]

Where can I get the %benchmark code and files referenced in this video, specifically the D:\Master Data folder Thank you,

[@SASUsers]

Thanks for your question, Cindy! We don't provide the data from our tutorials, but we encourage you to use your own data, or you can find more than 200 data sets in the SASHELP library. To access the SASHELP library in SAS, select View > Explorer. In the Explorer window, select Libraries > Sashelp. Note: In SAS Studio, you can access the SASHELP library in the Libraries section of the navigation pane. To see a brief description of any SAS data set in the SASHELP library, as well as output displaying the first five observations in each data set, see SASHELP Data Sets 2.sas.com/6054GsScs. For more information on how to access data in SAS, please see How do I access data in SAS? 2.sas.com/6055GsSct from the SAS University Edition: Help Center 2.sas.com/6056GsScQ. We hope this helps, and we wish you much #SASsuccess!

[@4psantosh]

@@SASUsers Hi, Where can i find the %benchmark code?

[@junaidfaruqui5741]

please take another look at your question 2.02 at 18 minutes ... the answer marked is wrong (should be CPU Time) and even the solution explanation says that the marked answer (I/O) is incorrect

[@SASUsers]

Seeking clarification on this and will get back with you shortly!

[@SASUsers]

Thanks for finding this issue. We checked and it's an errata item that the developers are aware of.

[@Matheus.ssouza]

thank you :P u save me heheh