BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Prateek1
Obsidian | Level 7

 

Hi ,

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

 

 


IMG_20160614_004752.jpg
1 ACCEPTED SOLUTION

Accepted Solutions
Prateek1
Obsidian | Level 7

hi,

proc format lib=BEN ;

WHERE TO PUT NOFMTERRORS

View solution in original post

8 REPLIES 8
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

Prateek1
Obsidian | Level 7

Hi,

I am also getting an error 

NO DEFAULT ACTION FOR THE FORMAT DATA TYPE.

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

Prateek1
Obsidian | Level 7

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.

 

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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

options nofmterr;

Prateek1
Obsidian | Level 7

hi,

i didnt get u ?

what should be the coding ?

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

See post 2.

Prateek1
Obsidian | Level 7

hi,

proc format lib=BEN ;

WHERE TO PUT NOFMTERRORS

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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