Q:

Does SAS create temp files while import in another location rather than the one specified

I am trying to import huge 100GB data, i end up getting errors such as space not available, i am wondering if this is happening because it gets stored into some temp space on my PC?
My library reference is to a server.

A:

It depends on your server configuration.
You see in this manner, first check performance with:
proc options group=performance;
run;
then
In the config file you should find for example:
[SAS CONFIG]/Lev1/SASApp/sasv9_usermods.cfg
[SAS HOME]/SASFoundation/9.3/sasv9_local.cfg
You should fine a option like :
-bufsize 64K

source: http://documentation.sas.com/?docsetId=bisag&docsetTarget=p1n3ivrea2b8fgn1at5j88gyteqj.htm&docsetVersion=9.4&locale=en 
https://www.zencos.com/blog/sas-administration-change-the-options-to-get-more-performance/
I guess increasing the buffer can help a bit and I suggest you to split the file in several files with linux it's super easy :
split --bytes=1000M /path/to/file.csv /path/to/csv/filesplit_

And then you can create generic import in a macro function and import like this :
%import(filesplit_1);
%import(filesplit_2);
%import(filesplit_3);
%import(filesplit_4);
..

And after each import, you can insert the data into a DBMS system like oracle.
During your insert with proc sql path through, don't forget to use the BULKLOAD option.

