Proc SQL

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 131
Accepted Solution

Proc SQL

Hello:

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?

Thank you!


Accepted Solutions
Solution
‎04-17-2015 11:33 AM
Valued Guide
Posts: 854

Re: Proc SQL

they can be in your work folder.

View solution in original post


All Replies
Solution
‎04-17-2015 11:33 AM
Valued Guide
Posts: 854

Re: Proc SQL

they can be in your work folder.

Grand Advisor
Posts: 17,308

Re: Proc SQL

I'm not aware of any proc in SAS that requires a permanent data set.

Frequent Contributor
Posts: 131

Re: Proc SQL

Thank you both!

How good is proco SQL for formatting?  Would you suggest outputting a dataset from proc SQL and then formatting using proc report?

Valued Guide
Posts: 854

Re: Proc SQL

It depends on what you have and what you are looking for.  Proc report will have a lot more options but it really depends.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 206 views
  • 3 likes
  • 3 in conversation