I'm cleaning a dataset using SAS University Edition on a Mac OS with over 300 GB of storage.
My dataset has over 30,000 observations and about 3,000 variables.
I am creating new work libraries every time I create a new variable. Then I got this error message.
The first step is unnecessary, as AGE_DCS_GRP_COM does not exist anyway.
And you can do all the other actions in one step.
By the way, 3000 variables? This screams "design failure" at me.
The first step is unnecessary, as AGE_DCS_GRP_COM does not exist anyway.
And you can do all the other actions in one step.
By the way, 3000 variables? This screams "design failure" at me.
Doing it all it one step fixes things. Thanks!
3000 variables is not 'design failure', but rather it is 'big data' lol
If this is a result of an Excel import, with lots of $254 variables, several runs recreating the datasets side-by-side can crack the limits of UE.
Thanks, I've figured it out. Instead of creating multiple work libraries, I'm just making all my new variables and data cleaning in the same work library. It seems that making multiple work libraries of 30,000 data points is too much. There is no error with the import or anything like that.
Reeza
I have the same problem. I am creating a LOT of datasets in my program and get the same error.
"... just add the new code in steps instead of new data sets each time ... "
How do you do this?
Even with your solution, I am beginning to wonder if SAS University Edition is powerful enough?
Regards
Michiel
University Edition is a learning tool (with specific applications in mind, like the free online SAS courses), not meant to do real-world analysis for free. Assigning a USER library under /folders/myfolders can help.
SAS UE is not powerful at all, it's like the full version of SAS with it's hands tied behind it's back.
My comment below is intended to say, instead of coding like this:
data temp1;
set sashelp.class;
if age < 14 then desc = 'Pre-Teen';
else if age<16 then desc = 'Teen';
else if age < 21 then desc = 'Young Adult';
run;
data temp;
set temp1;
if sex = 'F' then sex_category = 1;
else sex_category=2;
run;
Instead do this:
data temp1;
set sashelp.class;
if age < 14 then desc = 'Pre-Teen';
else if age<16 then desc = 'Teen';
else if age < 21 then desc = 'Young Adult';
if sex = 'F' then sex_category = 1;
else sex_category=2;
run;
However, that was referring to the OP's specific situation, yours may differ.
@mvniekerk wrote:
Reeza
I have the same problem. I am creating a LOT of datasets in my program and get the same error.
"... just add the new code in steps instead of new data sets each time ... "
How do you do this?
Even with your solution, I am beginning to wonder if SAS University Edition is powerful enough?
Regards
Michiel
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.