SAS版本是9.13,需要导入的数据是.tsv(450万条),而且变量也比较多,尝试多种导入的语句都失败,快要崩溃了,希望有高手帮忙提供下比较好的导入coding,谢谢!!如用
PROC IMPORT OUT= data.loan_mapp
            DATAFILE= "aa.tsv" 
            DBMS=TAB REPLACE;
     GETNAMES=YES;
     DATAROW=2; 
RUN;
成功导入后,发现变量的值会有空格,如“E 0 0 2 _ 1 0 0 3 0 2 9 8 3 0”,希望能高手帮忙出手解答,谢谢!
以下提供几条原数据。
STAT_DT CUST_NUM CUST_NAME OPEN_CUST_ORG_NUM BELONG_ORG_NUM PER_BELONG_ORG_NUM PER_COOPER_ORG_NUM PER_BELONG_PROTION PER_COOPER_PROTION BELONG_ZONE_CD CERT_TYPE_CD CERT_NUM CERT_ISSUE_ORG_NUM CERT_ISSUE_DT CERT_MATURE_DT CUST_MGER_NUM CUST_MGER_NAME CUST_STAT_CD CUST_TYPE_CD INDUSTRY_TYPE_CD CAREER_CD HIG_EDU_DEGREE_CD MARRIAGE_SITU_CD CRBC_EMPLY_IND OVERS_CUST_IND VIP_IND CUST_ACTIV_IND FUND_CUST_IND FUND_MAR_CUST_IND CRBC_CHREM_CUST_IND INSURE_CUST_IND TRDPTY_KEEP_CUST_IND ALL_IN_ONE_ACCT_IND OWN_CRDT_CARD_IND SALARY_PAYOFF_IND OPEN_CUST_DT CLOSE_DT LMT_TYP_CD CRDT_LMT AVAL_LMT LMT_INIT_DT LMT_MATURE_DT RISK_PREFER BIRTH_DT GENDER_CD INDV_YR_INCOME FAMILY_YR_INCOME MOBILE_NUM FIX_TEL ADDRESS EMAIL LOC_CORP CORP_TEL CORP_ADDR
20130331 E002_1003029830 TVB 000000000 756033     000000 1001 888888888888888888   2049/12/31   01 310 00000  00 00 N 0     0   1  0 2005/8/11        19861215 1   13800138000 13800138000 香港TVB大厦 888888@139.com  TVB 13800138000 TVB