topic sql query in SAS Procedures

sql query

Tal — Tue, 14 Jun 2016 00:09:23 GMT

hi,

i am supposed to run a query such as

proc sql;

create table temp as select var1,var2

from have where var1>0

group by var2;quit;

and copy the results and paste into an excel sheet but when running my program file.sas which has this query i only get the log saying you created a table of 100 records and 2 variables but i dont get a file.lst file which would display the data so i can copy it and paste it.

it can not be a dataset. has to be data i copy from the listing. how do i achieve this? anyone pls?

Re: sql query

Doc_Duke — Tue, 14 Jun 2016 00:42:37 GMT

"create able temp" creates a SAS data set.

you can get a several ways:

Drop the "create table temp" and PROC SQL will just list the data.
Run proc print on "temp" to create the listing.

If you have SAS ACCESS licensed, you could directly export "temp" to Excel.

Re: sql query

LinusH — Tue, 14 Jun 2016 01:15:32 GMT

Or use proc export to avoid the manual copy/paste operation.

Re: sql query

Reeza — Tue, 14 Jun 2016 02:32:02 GMT

Copy and pasting is a bad idea, it's too easy to make mistakes.

If you can't export to excel due to some license restriction - ie no SAS/Access look into the following macro.

http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

Or export to a CSV, and then save as an Excel file, since you're doing a manual step anyways.

Re: sql query

Tal — Wed, 15 Jun 2016 12:47:24 GMT

Thank you!

Re: sql query

Tal — Wed, 15 Jun 2016 12:49:50 GMT

Thanks Reeza,

I did export it into an excel file but they did not want it that way. They have always been copying and pasting the listing. Dont know why.

the max ls(linesize) is 256 right?

I was trying to shrink the output a bit but i guess in SAS thats the maximum