DATA Step, Macro, Functions and more

Error in log window

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

Error in log window

 

Hi ,

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

 

 


IMG_20160614_004752.jpg

Accepted Solutions
Solution
‎06-14-2016 08:09 AM
Contributor
Posts: 50

Re: Error in log window

hi,

proc format lib=BEN ;

WHERE TO PUT NOFMTERRORS

View solution in original post


All Replies
Super User
Super User
Posts: 7,971

Re: Error in log window

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.

Contributor
Posts: 50

Re: Error in log window

Hi,

I am also getting an error 

NO DEFAULT ACTION FOR THE FORMAT DATA TYPE.

Super User
Super User
Posts: 7,971

Re: Error in log window

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

Contributor
Posts: 50

Re: Error in log window

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.

 

 

Super User
Super User
Posts: 7,971

Re: Error in log window

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

options nofmterr;

Contributor
Posts: 50

Re: Error in log window

hi,

i didnt get u ?

what should be the coding ?

 

Super User
Super User
Posts: 7,971

Re: Error in log window

See post 2.

Solution
‎06-14-2016 08:09 AM
Contributor
Posts: 50

Re: Error in log window

hi,

proc format lib=BEN ;

WHERE TO PUT NOFMTERRORS

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 584 views
  • 0 likes
  • 2 in conversation