BookmarkSubscribeRSS Feed
xushunshun11960
Calcite | Level 5

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.

6 REPLIES 6
Tom
Super User Tom
Super User

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
Calcite | Level 5

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
Super User

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
Calcite | Level 5
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
Super User Tom
Super User

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
Calcite | Level 5
Many thanks for your kind reply

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 1198 views
  • 0 likes
  • 3 in conversation