f



ERROR: Asterisks are an indication of a format width problem.

I have a program that imports a text file.  This import statement runs
without errors.  I then save it to a library.  In another program, I
set this saved data into the work library and it gives me the
following error when I open it up to look at the data:

NOTE: Table has been opened in browse mode.
ERROR: Asterisks are an indication of a format width problem.

I've gone through all of the informat and format statements and
everything appears to be correct.  Any ideas?  Here's my import code.

data WORK.ORDER_LINE;
%let _EFIERR_ = 0; /* set the ERROR detection macro variable */
infile 'order_line.txt' delimiter = ',' MISSOVER DSD lrecl=32767
firstobs=1 ;

INFORMAT COMPANY_NUM $2. ;
INFORMAT ORDER_NUM $7. ;
INFORMAT LINE_NUM best32. ;
INFORMAT SSN $9. ;
INFORMAT OFFICE_LOC $4. ;
INFORMAT ISC_ID $4. ;
INFORMAT SA_ID $4. ;
INFORMAT SALES_USER_ID $4. ;
INFORMAT SALES_USER_TYPE $3. ;
INFORMAT SKILL_CATEGORY $6. ;
INFORMAT SKILL_CODE $4. ;
INFORMAT START_DT yymmdd10.;
INFORMAT PAY_RT best32. ;
INFORMAT PAY_OT_RT best32. ;
INFORMAT PAY_DIFF_RT best32. ;
INFORMAT BILL_RT best32. ;
INFORMAT BILL_OT_RT best32. ;
INFORMAT BILL_DIFF_RT best32. ;
INFORMAT START_CONFIRMED $5. ;
INFORMAT LEFT_MSG_FLG $5. ;
INFORMAT QUAL_CONFIRMED $5. ;
INFORMAT QUAL_RECHECK_FLG $5. ;
INFORMAT NXT_QUAL_RECHECK_DT yymmdd10.;
INFORMAT DAYS_BW_QUAL_CHKS best32. ;
INFORMAT LINE_STATUS $1. ;
INFORMAT LAST_BILL_DT yymmdd10.;
INFORMAT ASSIGN_DT yymmdd10.;
INFORMAT ISC_RELEASE $4. ;
INFORMAT SA_RELEASE $4. ;
INFORMAT RELEASE_SALES_USER_ID $4. ;
INFORMAT RELEASE_SALES_USER_TYPE $3. ;
INFORMAT EXP_HRS_CALC best32. ;
INFORMAT EXP_HRS_ADJ best32. ;
INFORMAT DISCOUNT_BILL_RT_FLG $5. ;
INFORMAT NO_OT_FLG $5. ;
INFORMAT ADD_DT yymmdd10.;
INFORMAT ADD_USER $36. ;
INFORMAT CHANGE_DT yymmdd10.;
INFORMAT CHANGE_USER $36. ;


FORMAT COMPANY_NUM $2. ;
FORMAT ORDER_NUM $7. ;
FORMAT LINE_NUM best32. ;
FORMAT SSN $9. ;
FORMAT OFFICE_LOC $4. ;
FORMAT ISC_ID $4. ;
FORMAT SA_ID $4. ;
FORMAT SALES_USER_ID $4. ;
FORMAT SALES_USER_TYPE $3. ;
FORMAT SKILL_CATEGORY $6. ;
FORMAT SKILL_CODE $4. ;
FORMAT START_DT yymmdd10.;
FORMAT PAY_RT best32. ;
FORMAT PAY_OT_RT best32. ;
FORMAT PAY_DIFF_RT best32. ;
FORMAT BILL_RT best32. ;
FORMAT BILL_OT_RT best32. ;
FORMAT BILL_DIFF_RT best32. ;
FORMAT START_CONFIRMED $5. ;
FORMAT LEFT_MSG_FLG $5. ;
FORMAT QUAL_CONFIRMED $5. ;
FORMAT QUAL_RECHECK_FLG $5. ;
FORMAT NXT_QUAL_RECHECK_DT yymmdd10.;
FORMAT DAYS_BW_QUAL_CHKS best32. ;
FORMAT LINE_STATUS $1. ;
FORMAT LAST_BILL_DT yymmdd10.;
FORMAT ASSIGN_DT yymmdd10.;
FORMAT ISC_RELEASE $4. ;
FORMAT SA_RELEASE $4. ;
FORMAT RELEASE_SALES_USER_ID $4. ;
FORMAT RELEASE_SALES_USER_TYPE $3. ;
FORMAT EXP_HRS_CALC best32. ;
FORMAT EXP_HRS_ADJ best32. ;
FORMAT DISCOUNT_BILL_RT_FLG $5. ;
FORMAT NO_OT_FLG $5. ;
FORMAT ADD_DT yymmdd10.;
FORMAT ADD_USER $36. ;
FORMAT CHANGE_DT yymmdd10.;
FORMAT CHANGE_USER $36. ;

INPUT
COMPANY_NUM $
ORDER_NUM $
LINE_NUM
SSN $
OFFICE_LOC $
ISC_ID $
SA_ID $
SALES_USER_ID $
SALES_USER_TYPE $
SKILL_CATEGORY $
SKILL_CODE $
START_DT
PAY_RT
PAY_OT_RT
PAY_DIFF_RT
BILL_RT
BILL_OT_RT
BILL_DIFF_RT
START_CONFIRMED $
LEFT_MSG_FLG $
QUAL_CONFIRMED $
QUAL_RECHECK_FLG $
NXT_QUAL_RECHECK_DT
DAYS_BW_QUAL_CHKS
LINE_STATUS $
LAST_BILL_DT
ASSIGN_DT
ISC_RELEASE $
SA_RELEASE $
RELEASE_SALES_USER_ID $
RELEASE_SALES_USER_TYPE $
EXP_HRS_CALC
EXP_HRS_ADJ
DISCOUNT_BILL_RT_FLG $
NO_OT_FLG $
ADD_DT
ADD_USER $
CHANGE_DT
CHANGE_USER $;

if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection
macro variable */
RUN;

Thanks.
0
5/15/2009 5:33:52 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
318 Views

Similar Articles

[PageSpeed] 57

Reply: