Hi Brian,   Thanks to the pandemic all of my computer accessories are in the office, with my trusty work laptop and me stuck at home here in Victoria, Australia. So, unfortunately, the mouse solution might not be possible for me at least for the next week or so.   Having said that, the second solution you've proposed worked like a charm. Double-clicking on Origin worked. Your input on this is greatly appreciated.   Have a lovely day Brian.   Cheers,   Sandesh ... View more

Hi Brian,   Thank you very much for letting me know how to access SAS Studio Tasks from within SAS EG. I was able to do this by switching from the Enterprise Edition to Single User mode in Options > Tasks > SAS Studio Integration as suggested.   In the SAS Studio Box Plot task now accessed through SAS EG, I've selected the dataset as SASHELP.CARS and Analysis variable as MPG_CITY. However, the variable selection window for Category does not display the OK button to select Category as Origin. I have tried the following with no success:   1. Trying to move the window so as to render the OK button to come into view. When I attempt to do this using the four arrow cursor the selection window just disappears from view. 2. Changing the setting 'Change the size of text, apps, and other items' in the Scale and layout section of my Display settings.    Please see the attached screenshots in conjunction with the explanation provided above to better understand the issue.   Cheers,   Sandesh ... View more

Thanks for your help Reeza. I have emailed training@sas.com, hopefully they are able to help.   Cheers,   Sandesh ... View more

Thanks Cynthia, I have sent an email to training@sas.com and will let you know if they are able to help.   Cheers,   Sandesh ... View more

Great insight @ballardw. So _TEM is the prefix and then the suffix could be an A or G (or maybe another alphabet depending on the operation performed) followed by a number. ... View more

This is good to know @Tom. In an upcoming engagement, I will need to use T-SQL so the differences between PROC SQL and other SQL implementations will come in handy. ... View more

Thanks for your input @Tom. This clarifies the confusion regarding aliases. ... View more

Just tried omitting the AS for a table alias @PGStats. Please see a screenshot of the log.     proc sql; create table work.birth_months /*as*/ select Employee_ID, Birth_Date, month(Birth_Date) as Birth_Month, Employee_Gender from orion.employee_information; describe table work.birth_months; select * from work.birth_months; quit; ... View more

Thanks very much for the clarification @PGStats. ... View more

@PGStats, I know the AS keyword is optional in Transact-SQL. However, when PROC SQL code without the AS keyword is executed a syntax error occurs.   proc sql; create table work.birth_months as select Employee_ID, Birth_Date, month(Birth_Date) Birth_Month, Employee_Gender from orion.employee_information; describe table work.birth_months; select * from work.birth_months; quit; ... View more