topic Re: Error in log window in SAS Programming

Error in log window

Prateek1 — Tue, 14 Jun 2016 10:24:42 GMT

Hi ,

I am getting an error ??? what should i do ?

Re: Error in log window

RW9 — Tue, 14 Jun 2016 10:30:31 GMT

You are trying to open a format within a format catalog, you can't do that by double clicking as there is no default open for formats. The easiest way is to send the formats to a dataset:

proc format library=work cntlout=work.myformats;

run;

This should give you a dataset call my formats you can open as normal.

Re: Error in log window

Prateek1 — Tue, 14 Jun 2016 10:39:53 GMT

Hi,

I am also getting an error

NO DEFAULT ACTION FOR THE FORMAT DATA TYPE.

Re: Error in log window

RW9 — Tue, 14 Jun 2016 10:57:35 GMT

Same answer as above, you can't open formats directly.

Re: Error in log window

Prateek1 — Tue, 14 Jun 2016 11:26:24 GMT

HI,

R 48-59: The format GENDER was not found or could not be loaded.

173 format shopfor Who_shopping_for.;
-----------------
48
ERROR 48-59: The format WHO_SHOPPING_FOR was not found or could not be loaded.

174 format veg Vegetarian.;
-----------
48
ERROR 48-59: The format VEGETARIAN was not found or could not be loaded.

175 format usecoup Use_coupons.;
------------
48
ERROR 48-59: The format USE_COUPONS was not found or could not be loaded.

176 format carry Carryover.;
----------
48
ERROR 48-59: The format CARRYOVER was not found or could not be loaded.

THIS IS MY CODE :

data BEN.grocery_1;
set Ben.Grocery_coupons;
label storeid="Health food store";
label size= "Size of store";
label hlthfood= "Health food store";
label org= "Store organization";
label custid= "Customer ID";
label gender= "Gender";
label shopfor= "Who shopping for";
label veg= "Vegetarian";
label style= "Shopping style";
label usecoup= "Use coupons";
label week= "Week";
label seq= "Sequence";
label carry= "Carryover";
label coupval= "Value of coupon";
label amtspent= "Amount spent";
format hlthfood Health_food_store.;
format size Size_of_store.;
format org Store_organization.;
format gender Gender.;
format shopfor Who_shopping_for.;
format veg Vegetarian.;
format usecoup Use_coupons.;
format carry Carryover.;
format coupval Value_of_coupon.;
format week Weekformat.;
run;

The data set BEN.GROCERY_1 may be incomplete. When this step was stopped there were 0
observations and 16 variables.

Re: Error in log window

RW9 — Tue, 14 Jun 2016 11:57:43 GMT

You can ignore the format erros - change them to notes- if you use:

options nofmterr;

Re: Error in log window

Prateek1 — Tue, 14 Jun 2016 12:00:23 GMT

hi,

i didnt get u ?

what should be the coding ?

Re: Error in log window

RW9 — Tue, 14 Jun 2016 12:02:25 GMT

See post 2.

Re: Error in log window

Prateek1 — Tue, 14 Jun 2016 12:08:34 GMT

hi,

proc format lib=BEN ;

WHERE TO PUT NOFMTERRORS