s********p
发帖数: 637 | 1 She is pulling data from large tables, in most case, she will create new
dataset containing pulled variable for further analysis.
I am not clear if temporary will be created when no new dataset needed. I
don't use system option(fullstimer), but just tried the following,
proc sql;
select p1.id from
data1 p1
inner join
data2 p2 on
p1.id=p2.id
;
quit;
and check if temporary files generated and found "#tf0005.sas7butl" created and size changed.
ll /saswork/SAS_workDD3300003446
total 7000
-rw-rw-r-- ... 阅读全帖 |
|
j********t
发帖数: 201 | 2 There are two ways to do so:
1) as the other reply said, you save your data in a permanent library using
libname statement.
2) You can also find the temporary folder where work is located with the
following statement:
%put %sysfunc(getoption(work));
then you can use system command to move the files into a permanent location.
1) is commonly used.
2) is rarely used. It seems to take an "unnecessary" lengthy road. However
, when you want to use system commands that are outside of SAS session, 2)
... 阅读全帖 |
|
F*******1
发帖数: 75 | 3 请教一个SAS 数据读入的问题. 我有个样本文件. 见附件.
我只需要第6行到第11行的数据. 在data statement 中, 我可以用firstobs=6 来定位
起事行. 那用什么来定位末位行呢? 我试了lastobs=11 不work. 谢谢!
如果我先读入所有数据,再提取需要的数据.我的sas script 如下. 但结果不对, 第7行
到第11行的数据丢了. 是什么原因呢? 谢谢!
data RT1;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile "\\mkscsas01\saswork\20090108_asm_rtmcp_final.csv" delimiter =
',' MISSOVER DSD lrecl=55010 firstobs=6 ;
format Pnode $12. MCPType $12.;
INPUT Pnode $ Zone $ MCPType $ HE1 - HE24;
run; |
|
s********p
发帖数: 637 | 4 Are you using PC SAS?
I do not remember clearly when I saw dapangmao's post.
I did a test using "proc sql" to left join two large dataset in UNIX.
Besides the new file I want to create, I also find a new temporary file
during the process in /saswork which is the directory to store temporary
files by SAS. That file increased its size gradually and I think it is the
Cartesian product file.
Even we assume proc sql use memory for cartesian product, for very large dataset operations in PC, Windows w... 阅读全帖 |
|
