The old-fashioned way of concatenating strings uses the operator “||”. This is still available, and still perfectly respectable. When using it, it is important to be aware of the lengths of the variables involved.     The log shows:   ... View more

Thank you so much for your post..and Great Ans..   I am taking the SAS Platfrom Admin course this week to get prepared. ... View more

We create a RTF file in our desired path. We apply a style available in the styles library. We can see the output file in the mentioned path and we can download it to save in an environment different from the SAS environment. Please note that we have two proc SQL statements and both their output is captured into a single file.  this is the best solution for SAS base exam preparation ODS RTF FILE=’/folders/myfolders/sasuser.v94/TutorialsPoint/CARS.rtf’ STYLE=EGDefault; proc SQL; select make, model, invoice from sashelp.cars where make in (‘Audi’,’BMW’) and type = ‘Sports’ ; quit; proc SQL; select make,mean(horsepower)as meanhp from sashelp.cars where make in (‘Audi’,’BMW’) group by make; quit;   ODS rtf CLOSE;   When the above code is executed we get the following result:   ... View more

A stacked bar chart is a bar chart in which a variable from the dataset is calculated with respect to another variable.   The below script will create a stacked bar-chart where the length of the cars are calculated for each car type. We use the group option to specify the second variable.   Base SAS Certification Questions   Example:    proc SGPLOT data=work.cars1; vbar length /group = type ; title ‘Lengths of Cars by Types’; run; quit;   When we execute the above code, we get the following output:     ... View more