topic Free SQL code? in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153976#M628 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to use SQL code in VA6.3, something more complex like select A.field1 from (select .. from mytable as A...)&nbsp; ? The "prepare data" tab allows me to use that SQL wizard. I may view the underlying proc sql, but I'm not allowed to change... very frustrating.</P><P></P><P>Do you know a workaround in VA&nbsp; (or am I supposed to use MS SQL Server ...again) ?</P><P></P><P>thanks</P><P>wz</P></BODY></HTML> Fri, 08 Aug 2014 10:38:45 GMT wz77 2014-08-08T10:38:45Z Free SQL code? https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153976#M628 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to use SQL code in VA6.3, something more complex like select A.field1 from (select .. from mytable as A...)&nbsp; ? The "prepare data" tab allows me to use that SQL wizard. I may view the underlying proc sql, but I'm not allowed to change... very frustrating.</P><P></P><P>Do you know a workaround in VA&nbsp; (or am I supposed to use MS SQL Server ...again) ?</P><P></P><P>thanks</P><P>wz</P></BODY></HTML> Fri, 08 Aug 2014 10:38:45 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153976#M628 wz77 2014-08-08T10:38:45Z Re: Free SQL code? https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153977#M629 <HTML><HEAD></HEAD><BODY><P>Don't you have a code window in VA?</P></BODY></HTML> Fri, 08 Aug 2014 11:10:35 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153977#M629 Kurt_Bremser 2014-08-08T11:10:35Z Re: Free SQL code? https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153978#M630 <HTML><HEAD></HEAD><BODY><P>Hi Kurt, I do have one, but it is read-only, even for Admins (see screenshot).<IMG alt="Unbenannt.jpg" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/7010_Unbenannt.jpg" width="450" /></P></BODY></HTML> Fri, 08 Aug 2014 11:20:03 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153978#M630 wz77 2014-08-08T11:20:03Z Re: Free SQL code? https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153979#M631 <HTML><HEAD></HEAD><BODY><P>That looks like the code preview of the SQL wizard. I meant a dedicated code window to enter any SAS code, like the program editor in Base SAS.</P></BODY></HTML> Fri, 08 Aug 2014 11:22:14 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153979#M631 Kurt_Bremser 2014-08-08T11:22:14Z Re: Free SQL code? https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153980#M632 <HTML><HEAD></HEAD><BODY><P>Did you try to unlock the window as described in <A href="http://support.sas.com/documentation/cdl/en/vaug/66720/HTML/default/viewer.htm#n1xjer3cuos07zn1d3m9t17uzz1i.htm" title="http://support.sas.com/documentation/cdl/en/vaug/66720/HTML/default/viewer.htm#n1xjer3cuos07zn1d3m9t17uzz1i.htm">SAS(R) Visual Analytics 6.3: User's Guide</A>?</P></BODY></HTML> Fri, 08 Aug 2014 11:39:12 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153980#M632 Kurt_Bremser 2014-08-08T11:39:12Z Re: Free SQL code? https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153981#M633 <HTML><HEAD></HEAD><BODY><P>LOL no ! Thanks for solving this issue Kurt !</P><P>Nobody in this company saw that tiny icon so far.... <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> I'am going to tell the others about it.</P></BODY></HTML> Mon, 11 Aug 2014 09:23:54 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Free-SQL-code/m-p/153981#M633 wz77 2014-08-11T09:23:54Z