mysql导入sas文件夹_MYSQL导出HTML格式数据如何导入到SAS中
好的,我查詢到下面代碼可以讀取HTML,請問如何解讀這段代碼?
data temp(keep=table row col value);
infile myfile recfm=f lrecl=&filesize. column=c eof=abc;
length which $8;
no_more_tables = 0;
do while(1);
which = 'TABLE';
table+1;
input @ '
if no_more_tables then leave;
start_table = c;
input @ '
' @;end_table = c;
input @start_table @;
row=0;
do while(1);
row+1;
which = 'TR';
input @ '
' @;if c >= end_table then do;
input @end_table @;
leave;
end;
start_row = c;
input @ '
' @;end_row = c;
input @start_row @;
col=0;
which = 'TD';
do while(1);
col+1;
input @ '
' @;if c >= end_row then do;
input @end_row @;
leave;
end;
start_col = c;
input @ '
' @;l = c-6-start_col+1;
input @start_col valuec $varying20. l @;
value=input(valuec,best20.);
output;
end;
end;
end;
return;
abc:;
if which = 'TABLE'
then no_more_tables = 1;
else if which = 'TR'
then input @end_table @;
else if which = 'TD'
then input @end_row @;
return;
run;
總結(jié)
以上是生活随笔為你收集整理的mysql导入sas文件夹_MYSQL导出HTML格式数据如何导入到SAS中的全部內(nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 在一个无序的int数组上构建一个最小堆的
- 下一篇: python中的抽象含义_Python中