The size of the results is greater than 3MB!

[xushunshun11960]

I keep getting this message and I'm not sure how to fix it? Can someone provide a step-by-step guidance as I'm new to SAS software.

My data has more than 292,000 observations, and do not know how to proceed.

[Tom]

How are you running SAS?  Sounds like you are using SAS/Studio and you produced too large of an output.

Did you try to PRINT all 292K observations? Why? Are you really planning to read a 5,000 page listing?

[xushunshun11960]

Yes I'm using the SAS studio. I have 2 data sets and I'm trying to merge them to proceed with my analysis. what I'm trying to do is to merge one observation from one dataset to the other one.

[ballardw]

What code created the output?

Copy the code from your editor. On this forum open either a text box, use the </> icon above the message window, or a code box using the "running man" icon.

HTML results with lots of tables or very long tables takes up a space. Period.

Be prepared to answer questions about exactly what you want to keep to create less output.

With 292,000 observations if you have 15 numeric variables then that right there is about 35Mbytes of data. Depending on what output you create 3Mb doesn't sound unlikely.

[xushunshun11960]

is this what you are looking for:
proc sql;
create table crspyear1 as
select a.*, b.fyear
from
IMPORT as a left join IMPORT1 as b
on a.permno = b.lpermno
and b.begfyr<a.date<=b.endfyr;
quit;

proc print data=crspyear1;
run;

[Tom]

Just remove the PROC PRINT step.

With SAS/Studio you can browse the generated dataset interactive and that will only retrieve one screen full of data at a time.

[xushunshun11960]

Many thanks for your kind reply