Help using Base SAS procedures

huge data sets

Posts: 65

huge data sets


We have  a very limited SASData space in our company. So we generally download tables that we create for our analysis. However after a while updating  analysis we have to upload our data to SAS enviroment again. However because these tables ara huge in size, is there a way to only upload coloumns which i need  for my analysis.

Super User
Posts: 10,278

Re: huge data sets

Posted in reply to omerzeybek

To get things straight:

You have server space with SAS data.

You download tables and run analyses locally.

When finished, you need to upload the results back into server space.

- do you create new tables in server space, or do you need to update some columns in existing server tables?

- do you have a server SAS installation and local SAS installations, or is the server just filespace? Or do you use some other (non-SAS) software for local analysis?

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 13,583

Re: huge data sets

Posted in reply to omerzeybek

Depending on HOW you are moving the SAS datasets around you can usually use a dataset option of Keep or Drop to specify the variables in the resulting data set.

VERY simple example:

Data mylib.class;

     set Sashelp.class (keep=sex age weight);


only keeps the three listed variables in the output data set.

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation