https://communities.sas.com/t5/Statistical-Procedures/Advantages-of-Writing-SQL-Queries-Over-Excel-Based-Data/m-p/922107#M45822 <P>What has this got to do with SAS?</P> <P>&nbsp;</P> <P>An identical post was made on reddit 6 hours ago, so I am contemplating marking this as the usual reddit spam.</P> Thu, 28 Mar 2024 13:35:08 GMT Kurt_Bremser 2024-03-28T13:35:08Z https://communities.sas.com/t5/Statistical-Procedures/Advantages-of-Writing-SQL-Queries-Over-Excel-Based-Data/m-p/922097#M45821 <P>Hey everyone,<BR />My current company already has a way to access databases through Excel bypassing SQL altogether. However, I'm intrigued by the idea of directly writing SQL queries for data retrieval.</P><P>I have decent SQL skills, but I'm looking to polish them further. Additionally, I'm interested in exploring the advantages of SQL querying, particularly in relation to our current setup. Here are a few points I'm particularly curious about:</P><P>How does SQL querying fare in terms of performance and flexibility compared to Excel-based queries, especially given that my company's Excel setup still utilizes SQL in the background?</P><P>Can I automate SQL queries/reports that will fetch the latest data?</P><P>While Excel is deeply integrated with other Microsoft applications, such as PowerPoint, how does SQL querying compare in terms of ease of integration and collaboration?</P><P>I've heard that SQL querying can seamlessly integrate with R or Python for further analysis and visualization. Can I use SQL directly from inside RStudio/ Spyder?</P><P>Any insights, personal experiences, or resources you can share would be invaluable. Thanks so much for your help!</P> Thu, 28 Mar 2024 12:54:58 GMT https://communities.sas.com/t5/Statistical-Procedures/Advantages-of-Writing-SQL-Queries-Over-Excel-Based-Data/m-p/922097#M45821 g1omaa 2024-03-28T12:54:58Z https://communities.sas.com/t5/Statistical-Procedures/Advantages-of-Writing-SQL-Queries-Over-Excel-Based-Data/m-p/922107#M45822 <P>What has this got to do with SAS?</P> <P>&nbsp;</P> <P>An identical post was made on reddit 6 hours ago, so I am contemplating marking this as the usual reddit spam.</P> Thu, 28 Mar 2024 13:35:08 GMT https://communities.sas.com/t5/Statistical-Procedures/Advantages-of-Writing-SQL-Queries-Over-Excel-Based-Data/m-p/922107#M45822 Kurt_Bremser 2024-03-28T13:35:08Z https://communities.sas.com/t5/Statistical-Procedures/Advantages-of-Writing-SQL-Queries-Over-Excel-Based-Data/m-p/922116#M45823 <P>I would go:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="yabwon_0-1711633771372.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/95001i22AB8AB4F538C918/image-size/medium?v=v2&amp;px=400" role="button" title="yabwon_0-1711633771372.png" alt="yabwon_0-1711633771372.png" /></span></P> <P>Bart</P> Thu, 28 Mar 2024 13:49:40 GMT https://communities.sas.com/t5/Statistical-Procedures/Advantages-of-Writing-SQL-Queries-Over-Excel-Based-Data/m-p/922116#M45823 yabwon 2024-03-28T13:49:40Z