f



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

ERROR: Asterisks are an indication of a format width problem.
means that there is a value that cannot be displayed in its current format -
say you had a variable X, and it has a row with the number 123456 in it.  If
you set the format of X to 5., you would not be able to see X.  Sometimes
with numbers they change it to BEST12. for you to make sure it displays when
possible, but if not, it will give that error, and you'll see an * somewhere
which shows the value not displayed.

-Joe

On Fri, May 15, 2009 at 12:33 PM, <adrienne.ingrum@gmail.com> wrote:

> 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
snoopy369 (1724)
5/15/2009 5:41:57 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
574 Views

Similar Articles

[PageSpeed] 43

Reply: