topic Proc SQL in SAS Programming https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198647#M266598 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>I have some questions regarding proc SQL but first does proc SQL require that input data sets be permanent SAS data sets or can they be working data sets?</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Fri, 17 Apr 2015 15:19:10 GMT Maisha_Huq 2015-04-17T15:19:10Z Proc SQL https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198647#M266598 <HTML><HEAD></HEAD><BODY><P>Hello:</P><P></P><P>I have some questions regarding proc SQL but first does proc SQL require that input data sets be permanent SAS data sets or can they be working data sets?</P><P></P><P></P><P>Thank you!</P></BODY></HTML> Fri, 17 Apr 2015 15:19:10 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198647#M266598 Maisha_Huq 2015-04-17T15:19:10Z Re: Proc SQL https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198648#M266599 <HTML><HEAD></HEAD><BODY><P>they can be in your work folder.</P></BODY></HTML> Fri, 17 Apr 2015 15:33:47 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198648#M266599 Steelers_In_DC 2015-04-17T15:33:47Z Re: Proc SQL https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198649#M266600 <HTML><HEAD></HEAD><BODY><P>I'm not aware of any proc in SAS that requires a permanent data set.</P></BODY></HTML> Fri, 17 Apr 2015 15:46:12 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198649#M266600 Reeza 2015-04-17T15:46:12Z Re: Proc SQL https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198650#M266601 <HTML><HEAD></HEAD><BODY><P>Thank you both!</P><P></P><P>How good is proco SQL for formatting?&nbsp; Would you suggest outputting a dataset from proc SQL and then formatting using proc report?</P></BODY></HTML> Fri, 17 Apr 2015 16:19:47 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198650#M266601 Maisha_Huq 2015-04-17T16:19:47Z Re: Proc SQL https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198651#M266602 <HTML><HEAD></HEAD><BODY><P>It depends on what you have and what you are looking for.&nbsp; Proc report will have a lot more options but it really depends.</P></BODY></HTML> Fri, 17 Apr 2015 16:22:22 GMT https://communities.sas.com/t5/SAS-Programming/Proc-SQL/m-p/198651#M266602 Steelers_In_DC 2015-04-17T16:22:22Z