Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- Programming
- /
- Programming
- /
- SAS EG file that won't load in Base SAS
Options
- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
Pyrite | Level 9
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 03-25-2020 04:49 PM
(723 views)
HI all.
I've encountered a strange problem today. My company shares a shared drive as most do. I have a file that I worked on in SAS EG 8.1 that refuses to open in BASE SAS. When attempting to open it via the folder, it just has a "browse with SAS 9.4" opposed to the "open with SAS EG 8.1". Further, when I try to call the destination in Base SAS with the following command I am met with formatting errors and no dataset.
libname RDS 'S:\ Drink Survey\Data\Data Analysis';
run;
proc means data='S:\ Drink Survey\Data\Data Analysis\full_weights.sas7bdat';
var Gender;
run;I get these errors:
libname RDS 'S:\UF Drink Survey\Data\Data Analysis';
NOTE: Libref RDS refers to the same physical library as WC000001.
NOTE: Libref RDS was successfully assigned as follows:
Engine: V9
Physical Name: S:\UF Drink Survey\Data\Data Analysis
37 run;
38 proc print data='S:\UF Drink Survey\Data\Data Analysis\full_weights.sas7bdat';
39
40 run;
ERROR: Format ICF_ not found or couldn't be loaded for variable icf.
ERROR: Format GENDER_ not found or couldn't be loaded for variable gender.
ERROR: Format RACE_ not found or couldn't be loaded for variable race.
ERROR: Format HISPANIC_LATINO_ not found or couldn't be loaded for variable hispanic_latino.
ERROR: Format MARITAL_STATUS_ not found or couldn't be loaded for variable marital_status.
ERROR: Format LEVEL_EDUCATION_ not found or couldn't be loaded for variable level_education.
ERROR: Format YEARLY_INCOME_ not found or couldn't be loaded for variable yearly_income.
ERROR: Format HOUSEHOLD_INCOME_ not found or couldn't be loaded for variable household_income.
ERROR: Format PUBLIC_BENEFIT_1_ not found or couldn't be loaded for variable public_benefit_1.
ERROR: Format PUBLIC_BENEFIT_2_ not found or couldn't be loaded for variable public_benefit_2.
ERROR: Format PUBLIC_BENEFIT_3_ not found or couldn't be loaded for variable public_benefit_3.
ERROR: Format PUBLIC_BENEFIT_4_ not found or couldn't be loaded for variable public_benefit_4.
ERROR: Format PUBLIC_BENEFIT_5_ not found or couldn't be loaded for variable public_benefit_5.
ERROR: Format AGE_FIRST_DRINK_ not found or couldn't be loaded for variable age_first_drink.
ERROR: Format AGE_FIRST_INTOXICATED_ not found or couldn't be loaded for variable
age_first_intoxicated.
ERROR: Format DRINK_DAYS_PAST30_ not found or couldn't be loaded for variable drink_days_past30.
ERROR: Format TREATMENT_INTERVENTION___1_ not found or couldn't be loaded for variable
treatment_intervention___1.
ERROR: Format TREATMENT_INTERVENTION___2_ not found or couldn't be loaded for variable
treatment_intervention___2.
ERROR: Format TREATMENT_INTERVENTION___3_ not found or couldn't be loaded for variable
treatment_intervention___3.
ERROR: Format TREATMENT_INTERVENTION___4_ not found or couldn't be loaded for variable
treatment_intervention___4.
ERROR: Format TREATMENT_INTERVENTION___5_ not found or couldn't be loaded for variable
treatment_intervention___5.
ERROR: Format TREATMENT_INTERVENTION___6_ not found or couldn't be loaded for variable
treatment_intervention___6.
ERROR: Format CURRENT_TOBACCO_USE_ not found or couldn't be loaded for variable
current_tobacco_use.
ERROR: Format LIFETIME_ILLICIT_DRUG_ not found or couldn't be loaded for variable
lifetime_illicit_drug.
ERROR: Format LIFETIME_PRSCRPTN_DRUGS_ not found or couldn't be loaded for variable
lifetime_prscrptn_drugs.
ERROR: Format LIFETIME_ALC_DRUG_MIX_ not found or couldn't be loaded for variable
lifetime_alc_drug_mix.
ERROR: Format YAACQB_1_ not found or couldn't be loaded for variable yaacqb_1.
ERROR: Format YAACQB_2_ not found or couldn't be loaded for variable yaacqb_2.
ERROR: Format YAACQB_3_ not found or couldn't be loaded for variable yaacqb_3.
ERROR: Format YAACQB_4_ not found or couldn't be loaded for variable yaacqb_4.
ERROR: Format YAACQB_5_ not found or couldn't be loaded for variable yaacqb_5.
ERROR: Format YAACQB_6_ not found or couldn't be loaded for variable yaacqb_6.
ERROR: Format YAACQB_7_ not found or couldn't be loaded for variable yaacqb_7.
ERROR: Format YAACQB_8_ not found or couldn't be loaded for variable yaacqb_8.
ERROR: Format YAACQB_9_ not found or couldn't be loaded for variable yaacqb_9.
ERROR: Format YAACQB_10_ not found or couldn't be loaded for variable yaacqb_10.
ERROR: Format YAACQB_11_ not found or couldn't be loaded for variable yaacqb_11.
ERROR: Format YAACQB_12_ not found or couldn't be loaded for variable yaacqb_12.
ERROR: Format YAACQB_13_ not found or couldn't be loaded for variable yaacqb_13.
ERROR: Format YAACQB_14_ not found or couldn't be loaded for variable yaacqb_14.
ERROR: Format YAACQB_15_ not found or couldn't be loaded for variable yaacqb_15.
ERROR: Format YAACQB_16_ not found or couldn't be loaded for variable yaacqb_16.
ERROR: Format YAACQB_17_ not found or couldn't be loaded for variable yaacqb_17.
ERROR: Format YAACQB_18_ not found or couldn't be loaded for variable yaacqb_18.
ERROR: Format YAACQB_19_ not found or couldn't be loaded for variable yaacqb_19.
ERROR: Format YAACQB_20_ not found or couldn't be loaded for variable yaacqb_20.
ERROR: Format YAACQB_21_ not found or couldn't be loaded for variable yaacqb_21.
ERROR: Format YAACQB_22_ not found or couldn't be loaded for variable yaacqb_22.
ERROR: Format YAACQB_23_ not found or couldn't be loaded for variable yaacqb_23.
ERROR: Format YAACQB_24_ not found or couldn't be loaded for variable yaacqb_24.
ERROR: Format DD_1_ not found or couldn't be loaded for variable dd_1.
ERROR: Format DD_2_ not found or couldn't be loaded for variable dd_2.
ERROR: Format DD_3_ not found or couldn't be loaded for variable dd_3.
ERROR: Format DD_4_ not found or couldn't be loaded for variable dd_4.
ERROR: Format DD_5_ not found or couldn't be loaded for variable dd_5.
ERROR: Format DD_6_ not found or couldn't be loaded for variable dd_6.
ERROR: Format DD_7_ not found or couldn't be loaded for variable dd_7.
ERROR: Format DD_8_ not found or couldn't be loaded for variable dd_8.
ERROR: Format DD_9_ not found or couldn't be loaded for variable dd_9.
ERROR: Format DD_10_ not found or couldn't be loaded for variable dd_10.
ERROR: Format DD_11_ not found or couldn't be loaded for variable dd_11.
ERROR: Format DD_12_ not found or couldn't be loaded for variable dd_12.
ERROR: Format DD_13_ not found or couldn't be loaded for variable dd_13.
ERROR: Format DD_14_ not found or couldn't be loaded for variable dd_14.
ERROR: Format DD_15_ not found or couldn't be loaded for variable dd_15.
ERROR: Format DD_16_ not found or couldn't be loaded for variable dd_16.
ERROR: Format DD_17_ not found or couldn't be loaded for variable dd_17.
ERROR: Format AC_LVL_WOD_FREQ1_ not found or couldn't be loaded for variable ac_lvl_wod_freq1.
ERROR: Format AC_LVL_WOD_FREQ2_ not found or couldn't be loaded for variable ac_lvl_wod_freq2.
ERROR: Format AC_LVL_WOD_FREQ3_ not found or couldn't be loaded for variable ac_lvl_wod_freq3.
ERROR: Format AC_LVL_WOD_FREQ4_ not found or couldn't be loaded for variable ac_lvl_wod_freq4.
ERROR: Format AC_LVL_WOD_FREQ5_ not found or couldn't be loaded for variable ac_lvl_wod_freq5.
ERROR: Format AC_LVL_WOD_FREQ6_ not found or couldn't be loaded for variable ac_lvl_wod_freq6.
ERROR: Format AC_LVL_WOD_FREQ7_ not found or couldn't be loaded for variable ac_lvl_wod_freq7.
ERROR: Format AC_LVL_WOD_FREQ8_ not found or couldn't be loaded for variable ac_lvl_wod_freq8.
ERROR: Format AC_LVL_WOD_FREQ9_ not found or couldn't be loaded for variable ac_lvl_wod_freq9.
ERROR: Format AC_LVL_WOD_FREQ10_ not found or couldn't be loaded for variable ac_lvl_wod_freq10.
ERROR: Format AC_LVL_WOD_FREQ11_ not found or couldn't be loaded for variable ac_lvl_wod_freq11.
ERROR: Format AC_LVL_WOD_FREQ12_ not found or couldn't be loaded for variable ac_lvl_wod_freq12.
ERROR: Format AC_LVL_WOD_FREQ13_ not found or couldn't be loaded for variable ac_lvl_wod_freq13.
ERROR: Format AC_LVL_WOD_FREQ14_ not found or couldn't be loaded for variable ac_lvl_wod_freq14.
ERROR: Format AC_LVL_WOD_FREQ15_ not found or couldn't be loaded for variable ac_lvl_wod_freq15.
ERROR: Format AC_LVL_WOD_FREQ16_ not found or couldn't be loaded for variable ac_lvl_wod_freq16.
ERROR: Format AC_LVL_WOD_FREQ17_ not found or couldn't be loaded for variable ac_lvl_wod_freq17.
ERROR: Format AC_LVL_WOD_FREQ18_ not found or couldn't be loaded for variable ac_lvl_wod_freq18.
ERROR: Format AC_LVL_WOD_FREQ19_ not found or couldn't be loaded for variable ac_lvl_wod_freq19.
ERROR: Format AC_LVL_WOD_FREQ20_ not found or couldn't be loaded for variable ac_lvl_wod_freq20.
ERROR: Format AC_LVL_WOD_FREQ21_ not found or couldn't be loaded for variable ac_lvl_wod_freq21.
ERROR: Format AC_LVL_WOD_FREQ22_ not found or couldn't be loaded for variable ac_lvl_wod_freq22.
ERROR: Format AC_LVL_WOD_FREQ23_ not found or couldn't be loaded for variable ac_lvl_wod_freq23.
ERROR: Format AC_LVL_WOD_FREQ24_ not found or couldn't be loaded for variable ac_lvl_wod_freq24.
ERROR: Format AC_LVL_WOD_FREQ25_ not found or couldn't be loaded for variable ac_lvl_wod_freq25.
ERROR: Format AC_LVL_WOD_FREQ26_ not found or couldn't be loaded for variable ac_lvl_wod_freq26.
ERROR: Format AC_LVL_WOD_FREQ27_ not found or couldn't be loaded for variable ac_lvl_wod_freq27.
ERROR: Format AC_LVL_WOD_FREQ28_ not found or couldn't be loaded for variable ac_lvl_wod_freq28.
ERROR: Format AC_LVL_WOD_FREQ29_ not found or couldn't be loaded for variable ac_lvl_wod_freq29.
ERROR: Format AC_LVL_WOD_FREQ30_ not found or couldn't be loaded for variable ac_lvl_wod_freq30.
ERROR: Format AC_LVL_WOD_FREQ31_ not found or couldn't be loaded for variable ac_lvl_wod_freq31.
ERROR: Format AC_LVL_WOD_FREQ32_ not found or couldn't be loaded for variable ac_lvl_wod_freq32.
ERROR: Format AC_LVL_WOD_FREQ33_ not found or couldn't be loaded for variable ac_lvl_wod_freq33.
ERROR: Format AC_LVL_WOD_FREQ34_ not found or couldn't be loaded for variable ac_lvl_wod_freq34.
ERROR: Format AC_LVL_WOD_FREQ35_ not found or couldn't be loaded for variable ac_lvl_wod_freq35.
ERROR: Format AC_LVL_WOD_FREQ36_ not found or couldn't be loaded for variable ac_lvl_wod_freq36.
ERROR: Format ACT_LVL_WD_FREQ1_ not found or couldn't be loaded for variable act_lvl_wd_freq1.
ERROR: Format ACT_LVL_WD_FREQ2_ not found or couldn't be loaded for variable act_lvl_wd_freq2.
ERROR: Format ACT_LVL_WD_FREQ3_ not found or couldn't be loaded for variable act_lvl_wd_freq3.
ERROR: Format ACT_LVL_WD_FREQ4_ not found or couldn't be loaded for variable act_lvl_wd_freq4.
ERROR: Format ACT_LVL_WD_FREQ5_ not found or couldn't be loaded for variable act_lvl_wd_freq5.
ERROR: Format ACT_LVL_WD_FREQ6_ not found or couldn't be loaded for variable act_lvl_wd_freq6.
ERROR: Format ACT_LVL_WD_FREQ7_ not found or couldn't be loaded for variable act_lvl_wd_freq7.
ERROR: Format ACT_LVL_WD_FREQ8_ not found or couldn't be loaded for variable act_lvl_wd_freq8.
ERROR: Format ACT_LVL_WD_FREQ9_ not found or couldn't be loaded for variable act_lvl_wd_freq9.
ERROR: Format ACT_LVL_WD_FREQ10_ not found or couldn't be loaded for variable act_lvl_wd_freq10.
ERROR: Format ACT_LVL_WD_FREQ11_ not found or couldn't be loaded for variable act_lvl_wd_freq11.
ERROR: Format ACT_LVL_WD_FREQ12_ not found or couldn't be loaded for variable act_lvl_wd_freq12.
ERROR: Format ACT_LVL_WD_FREQ13_ not found or couldn't be loaded for variable act_lvl_wd_freq13.
ERROR: Format ACT_LVL_WD_FREQ14_ not found or couldn't be loaded for variable act_lvl_wd_freq14.
ERROR: Format ACT_LVL_WD_FREQ15_ not found or couldn't be loaded for variable act_lvl_wd_freq15.
ERROR: Format ACT_LVL_WD_FREQ16_ not found or couldn't be loaded for variable act_lvl_wd_freq16.
ERROR: Format ACT_LVL_WD_FREQ17_ not found or couldn't be loaded for variable act_lvl_wd_freq17.
ERROR: Format ACT_LVL_WD_FREQ18_ not found or couldn't be loaded for variable act_lvl_wd_freq18.
ERROR: Format ACT_LVL_WD_FREQ19_ not found or couldn't be loaded for variable act_lvl_wd_freq19.
ERROR: Format ACT_LVL_WD_FREQ20_ not found or couldn't be loaded for variable act_lvl_wd_freq20.
ERROR: Format ACT_LVL_WD_FREQ21_ not found or couldn't be loaded for variable act_lvl_wd_freq21.
ERROR: Format ACT_LVL_WD_FREQ22_ not found or couldn't be loaded for variable act_lvl_wd_freq22.
ERROR: Format ACT_LVL_WD_FREQ23_ not found or couldn't be loaded for variable act_lvl_wd_freq23.
ERROR: Format ACT_LVL_WD_FREQ24_ not found or couldn't be loaded for variable act_lvl_wd_freq24.
ERROR: Format ACT_LVL_WD_FREQ25_ not found or couldn't be loaded for variable act_lvl_wd_freq25.
ERROR: Format ACT_LVL_WD_FREQ26_ not found or couldn't be loaded for variable act_lvl_wd_freq26.
ERROR: Format ACT_LVL_WD_FREQ27_ not found or couldn't be loaded for variable act_lvl_wd_freq27.
ERROR: Format ACT_LVL_WD_FREQ28_ not found or couldn't be loaded for variable act_lvl_wd_freq28.
ERROR: Format ACT_LVL_WD_FREQ29_ not found or couldn't be loaded for variable act_lvl_wd_freq29.
ERROR: Format ACT_LVL_WD_FREQ30_ not found or couldn't be loaded for variable act_lvl_wd_freq30.
ERROR: Format ACT_LVL_WD_FREQ31_ not found or couldn't be loaded for variable act_lvl_wd_freq31.
ERROR: Format ACT_LVL_WD_FREQ32_ not found or couldn't be loaded for variable act_lvl_wd_freq32.
ERROR: Format ACT_LVL_WD_FREQ33_ not found or couldn't be loaded for variable act_lvl_wd_freq33.
ERROR: Format ACT_LVL_WD_FREQ34_ not found or couldn't be loaded for variable act_lvl_wd_freq34.
ERROR: Format ACT_LVL_WD_FREQ35_ not found or couldn't be loaded for variable act_lvl_wd_freq35.
ERROR: Format ACT_LVL_WD_FREQ36_ not found or couldn't be loaded for variable act_lvl_wd_freq36.
ERROR: Format PBSS20_1_ not found or couldn't be loaded for variable pbss20_1.
ERROR: Format PBSS20_2_ not found or couldn't be loaded for variable pbss20_2.
ERROR: Format PBSS20_3_ not found or couldn't be loaded for variable pbss20_3.
ERROR: Format PBSS20_4_ not found or couldn't be loaded for variable pbss20_4.
ERROR: Format PBSS20_5_ not found or couldn't be loaded for variable pbss20_5.
ERROR: Format PBSS20_6_ not found or couldn't be loaded for variable pbss20_6.
ERROR: Format PBSS20_7_ not found or couldn't be loaded for variable pbss20_7.
ERROR: Format PBSS20_8_ not found or couldn't be loaded for variable pbss20_8.
ERROR: Format PBSS20_9_ not found or couldn't be loaded for variable pbss20_9.
ERROR: Format PBSS20_10_ not found or couldn't be loaded for variable pbss20_10.
ERROR: Format PBSS20_11_ not found or couldn't be loaded for variable pbss20_11.
ERROR: Format PBSS20_12_ not found or couldn't be loaded for variable pbss20_12.
ERROR: Format PBSS20_13_ not found or couldn't be loaded for variable pbss20_13.
ERROR: Format PBSS20_14_ not found or couldn't be loaded for variable pbss20_14.
ERROR: Format PBSS20_15_ not found or couldn't be loaded for variable pbss20_15.
ERROR: Format PBSS20_16_ not found or couldn't be loaded for variable pbss20_16.
ERROR: Format PBSS20_17_ not found or couldn't be loaded for variable pbss20_17.
ERROR: Format PBSS20_18_ not found or couldn't be loaded for variable pbss20_18.
ERROR: Format PBSS20_19_ not found or couldn't be loaded for variable pbss20_19.
ERROR: Format PBSS20_20_ not found or couldn't be loaded for variable pbss20_20.
ERROR: Format BEHAVIOR_CHANGE_LADDER_2_ not found or couldn't be loaded for variable
behavior_change_ladder_2.
ERROR: Format SNQ_1_RELATION_ not found or couldn't be loaded for variable snq_1_relation.
ERROR: Format SNQ_PERSON1_Q1_ not found or couldn't be loaded for variable snq_person1_q1.
ERROR: Format SNQ_PERSON1_Q2_ not found or couldn't be loaded for variable snq_person1_q2.
ERROR: Format SNQ_PERSON1_Q3_ not found or couldn't be loaded for variable snq_person1_q3.
ERROR: Format SNQ_PERSON1_Q4_ not found or couldn't be loaded for variable snq_person1_q4.
ERROR: Format SNQ_PERSON1_Q5_ not found or couldn't be loaded for variable snq_person1_q5.
ERROR: Format SNQ_PERSON1_Q6_ not found or couldn't be loaded for variable snq_person1_q6.
ERROR: Format SNQ_PERSON1_Q7_ not found or couldn't be loaded for variable snq_person1_q7.
ERROR: Format SNQ_PERSON1_Q8_ not found or couldn't be loaded for variable snq_person1_q8.
ERROR: Format SNQ_PERSON1_Q9_ not found or couldn't be loaded for variable snq_person1_q9.
ERROR: Format SNQ_PERSON1_Q10_ not found or couldn't be loaded for variable snq_person1_q10.
ERROR: Format SNQ_PERSON2_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person2_relationship.
ERROR: Format SNQ_PERSON2_Q1_ not found or couldn't be loaded for variable snq_person2_q1.
ERROR: Format SNQ_PERSON2_Q2_ not found or couldn't be loaded for variable snq_person2_q2.
ERROR: Format SNQ_PERSON2_Q3_ not found or couldn't be loaded for variable snq_person2_q3.
ERROR: Format SNQ_PERSON2_Q4_ not found or couldn't be loaded for variable snq_person2_q4.
ERROR: Format SNQ_PERSON2_Q5_ not found or couldn't be loaded for variable snq_person2_q5.
ERROR: Format SNQ_PERSON2_Q6_ not found or couldn't be loaded for variable snq_person2_q6.
ERROR: Format SNQ_PERSON2_Q7_ not found or couldn't be loaded for variable snq_person2_q7.
ERROR: Format SNQ_PERSON2_Q8_ not found or couldn't be loaded for variable snq_person2_q8.
ERROR: Format SNQ_PERSON2_Q9_ not found or couldn't be loaded for variable snq_person2_q9.
ERROR: Format SNQ_PERSON2_Q10_ not found or couldn't be loaded for variable snq_person2_q10.
ERROR: Format SNQ_PERSON3_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person3_relationship.
ERROR: Format SNQ_PERSON3_Q1_ not found or couldn't be loaded for variable snq_person3_q1.
ERROR: Format SNQ_PERSON3_Q2_ not found or couldn't be loaded for variable snq_person3_q2.
ERROR: Format SNQ_PERSON3_Q3_ not found or couldn't be loaded for variable snq_person3_q3.
ERROR: Format SNQ_PERSON3_Q4_ not found or couldn't be loaded for variable snq_person3_q4.
ERROR: Format SNQ_PERSON3_Q5_ not found or couldn't be loaded for variable snq_person3_q5.
ERROR: Format SNQ_PERSON3_Q6_ not found or couldn't be loaded for variable snq_person3_q6.
ERROR: Format SNQ_PERSON3_Q7_ not found or couldn't be loaded for variable snq_person3_q7.
ERROR: Format SNQ_PERSON3_Q8_ not found or couldn't be loaded for variable snq_person3_q8.
ERROR: Format SNQ_PERSON3_Q9_ not found or couldn't be loaded for variable snq_person3_q9.
ERROR: Format SNQ_PERSON3_Q10_ not found or couldn't be loaded for variable snq_person3_q10.
ERROR: Format SNQ_PERSON4_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person4_relationship.
ERROR: Format SNQ_PERSON4_Q1_ not found or couldn't be loaded for variable snq_person4_q1.
ERROR: Format SNQ_PERSON4_Q2_ not found or couldn't be loaded for variable snq_person4_q2.
ERROR: Format SNQ_PERSON4_Q3_ not found or couldn't be loaded for variable snq_person4_q3.
ERROR: Format SNQ_PERSON4_Q4_ not found or couldn't be loaded for variable snq_person4_q4.
ERROR: Format SNQ_PERSON4_Q5_ not found or couldn't be loaded for variable snq_person4_q5.
ERROR: Format SNQ_PERSON4_Q6_ not found or couldn't be loaded for variable snq_person4_q6.
ERROR: Format SNQ_PERSON4_Q7_ not found or couldn't be loaded for variable snq_person4_q7.
ERROR: Format SNQ_PERSON4_Q8_ not found or couldn't be loaded for variable snq_person4_q8.
ERROR: Format SNQ_PERSON4_Q9_ not found or couldn't be loaded for variable snq_person4_q9.
ERROR: Format SNQ_PERSON4_Q10_ not found or couldn't be loaded for variable snq_person4_q10.
ERROR: Format ADD_NW_MEMBER5_ not found or couldn't be loaded for variable add_nw_member5.
ERROR: Format SNQ_PERSON5_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person5_relationship.
ERROR: Format SNQ_PERSON5_Q1_ not found or couldn't be loaded for variable snq_person5_q1.
ERROR: Format SNQ_PERSON5_Q2_ not found or couldn't be loaded for variable snq_person5_q2.
ERROR: Format SNQ_PERSON5_Q3_ not found or couldn't be loaded for variable snq_person5_q3.
ERROR: Format SNQ_PERSON5_Q4_ not found or couldn't be loaded for variable snq_person5_q4.
ERROR: Format SNQ_PERSON5_Q5_ not found or couldn't be loaded for variable snq_person5_q5.
ERROR: Format SNQ_PERSON5_Q6_ not found or couldn't be loaded for variable snq_person5_q6.
ERROR: Format SNQ_PERSON5_Q7_ not found or couldn't be loaded for variable snq_person5_q7.
ERROR: Format SNQ_PERSON5_Q8_ not found or couldn't be loaded for variable snq_person5_q8.
ERROR: Format SNQ_PERSON5_Q9_ not found or couldn't be loaded for variable snq_person5_q9.
ERROR: Format SNQ_PERSON5_Q10_ not found or couldn't be loaded for variable snq_person5_q10.
ERROR: Format ADD_NW_MEMBER6_ not found or couldn't be loaded for variable add_nw_member6.
ERROR: Format SNQ_PERSON6_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person6_relationship.
ERROR: Format SNQ_PERSON6_Q1_ not found or couldn't be loaded for variable snq_person6_q1.
ERROR: Format SNQ_PERSON6_Q2_ not found or couldn't be loaded for variable snq_person6_q2.
ERROR: Format SNQ_PERSON6_Q3_ not found or couldn't be loaded for variable snq_person6_q3.
ERROR: Format SNQ_PERSON6_Q4_ not found or couldn't be loaded for variable snq_person6_q4.
ERROR: Format SNQ_PERSON6_Q5_ not found or couldn't be loaded for variable snq_person6_q5.
ERROR: Format SNQ_PERSON6_Q6_ not found or couldn't be loaded for variable snq_person6_q6.
ERROR: Format SNQ_PERSON6_Q7_ not found or couldn't be loaded for variable snq_person6_q7.
ERROR: Format SNQ_PERSON6_Q8_ not found or couldn't be loaded for variable snq_person6_q8.
ERROR: Format SNQ_PERSON6_Q9_ not found or couldn't be loaded for variable snq_person6_q9.
ERROR: Format SNQ_PERSON6_Q10_ not found or couldn't be loaded for variable snq_person6_q10.
ERROR: Format ADD_NW_MEMBER7_ not found or couldn't be loaded for variable add_nw_member7.
ERROR: Format SNQ_PERSON7_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person7_relationship.
ERROR: Format SNQ_PERSON7_Q1_ not found or couldn't be loaded for variable snq_person7_q1.
ERROR: Format SNQ_PERSON7_Q2_ not found or couldn't be loaded for variable snq_person7_q2.
ERROR: Format SNQ_PERSON7_Q3_ not found or couldn't be loaded for variable snq_person7_q3.
ERROR: Format SNQ_PERSON7_Q4_ not found or couldn't be loaded for variable snq_person7_q4.
ERROR: Format SNQ_PERSON7_Q5_ not found or couldn't be loaded for variable snq_person7_q5.
ERROR: Format SNQ_PERSON7_Q6_ not found or couldn't be loaded for variable snq_person7_q6.
ERROR: Format SNQ_PERSON7_Q7_ not found or couldn't be loaded for variable snq_person7_q7.
ERROR: Format SNQ_PERSON7_Q8_ not found or couldn't be loaded for variable snq_person7_q8.
ERROR: Format SNQ_PERSON7_Q9_ not found or couldn't be loaded for variable snq_person7_q9.
ERROR: Format SNQ_PERSON7_Q10_ not found or couldn't be loaded for variable snq_person7_q10.
ERROR: Format ADD_NW_MEMBER_8_ not found or couldn't be loaded for variable add_nw_member_8.
ERROR: Format SNQ_PERSON8_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person8_relationship.
ERROR: Format SNQ_PERSON8_Q1_ not found or couldn't be loaded for variable snq_person8_q1.
ERROR: Format SNQ_PERSON8_Q2_ not found or couldn't be loaded for variable snq_person8_q2.
ERROR: Format SNQ_PERSON8_Q3_ not found or couldn't be loaded for variable snq_person8_q3.
ERROR: Format SNQ_PERSON8_Q4_ not found or couldn't be loaded for variable snq_person8_q4.
ERROR: Format SNQ_PERSON8_Q5_ not found or couldn't be loaded for variable snq_person8_q5.
ERROR: Format SNQ_PERSON8_Q6_ not found or couldn't be loaded for variable snq_person8_q6.
ERROR: Format SNQ_PERSON8_Q7_ not found or couldn't be loaded for variable snq_person8_q7.
ERROR: Format SNQ_PERSON8_Q8_ not found or couldn't be loaded for variable snq_person8_q8.
ERROR: Format SNQ_PERSON8_Q09_ not found or couldn't be loaded for variable snq_person8_q09.
ERROR: Format SNQ_PERSON8_Q10_ not found or couldn't be loaded for variable snq_person8_q10.
ERROR: Format ADD_NW_MEMBER9_ not found or couldn't be loaded for variable add_nw_member9.
ERROR: Format SNQ_PERSON9_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person9_relationship.
ERROR: Format SNQ_PERSON9_Q1_ not found or couldn't be loaded for variable snq_person9_q1.
ERROR: Format SNQ_PERSON9_Q2_ not found or couldn't be loaded for variable snq_person9_q2.
ERROR: Format SNQ_PERSON9_Q3_ not found or couldn't be loaded for variable snq_person9_q3.
ERROR: Format SNQ_PERSON9_Q4_ not found or couldn't be loaded for variable snq_person9_q4.
ERROR: Format SNQ_PERSON9_Q5_ not found or couldn't be loaded for variable snq_person9_q5.
ERROR: Format SNQ_PERSON9_Q6_ not found or couldn't be loaded for variable snq_person9_q6.
ERROR: Format SNQ_PERSON9_Q7_ not found or couldn't be loaded for variable snq_person9_q7.
ERROR: Format SNQ_PERSON9_Q8_ not found or couldn't be loaded for variable snq_person9_q8.
ERROR: Format SNQ_PERSON9_Q9_ not found or couldn't be loaded for variable snq_person9_q9.
ERROR: Format SNQ_PERSON9_Q10_ not found or couldn't be loaded for variable snq_person9_q10.
ERROR: Format ADD_NW_MEMBER_10_ not found or couldn't be loaded for variable add_nw_member_10.
ERROR: Format SNQ_PERSON10_RELATIONSHIP_ not found or couldn't be loaded for variable
snq_person10_relationship.
ERROR: Format SNQ_PERSON10_Q1_ not found or couldn't be loaded for variable snq_person10_q1.
ERROR: Format SNQ_PERSON10_Q2_ not found or couldn't be loaded for variable snq_person10_q2.
ERROR: Format SNQ_PERSON10_Q3_ not found or couldn't be loaded for variable snq_person10_q3.
ERROR: Format SNQ_PERSON10_Q4_ not found or couldn't be loaded for variable snq_person10_q4.
ERROR: Format SNQ_PERSON10_Q5_ not found or couldn't be loaded for variable snq_person10_q5.
ERROR: Format SNQ_PERSON10_Q6_ not found or couldn't be loaded for variable snq_person10_q6.
ERROR: Format SNQ_PERSON10_Q7_ not found or couldn't be loaded for variable snq_person10_q7.
ERROR: Format SNQ_PERSON10_Q8_ not found or couldn't be loaded for variable snq_person10_q8.
ERROR: Format SNQ_PERSON10_Q9_ not found or couldn't be loaded for variable snq_person10_q9.
ERROR: Format SNQ_PERSON10_Q10_ not found or couldn't be loaded for variable snq_person10_q10.
ERROR: Format LOST_RELATIONSHIP_ not found or couldn't be loaded for variable lost_relationship.
ERROR: Format SPOUSE_NOT_AVAILABLE_ not found or couldn't be loaded for variable
spouse_not_available.
ERROR: Format CHILD_NOT_AVAILABLE_ not found or couldn't be loaded for variable
child_not_available.
ERROR: Format RELATIVE_NOT_AVAILABLE_ not found or couldn't be loaded for variable
relative_not_available.
ERROR: Format FRIENDS_NOT_AVAILABLE_ not found or couldn't be loaded for variable
friends_not_available.
ERROR: Format OTHER_NOT_AVAILABLE_ not found or couldn't be loaded for variable
other_not_available.
ERROR: Format LOST_SUPPORT_ not found or couldn't be loaded for variable lost_support.
ERROR: Format OPTIONS_REDUCE_DRINK1_ not found or couldn't be loaded for variable
options_reduce_drink1.
ERROR: Format OPTIONS_REDUCE_DRINK2_ not found or couldn't be loaded for variable
options_reduce_drink2.
ERROR: Format OPTIONS_REDUCE_DRINK3_ not found or couldn't be loaded for variable
options_reduce_drink3.
ERROR: Format OPTIONS_REDUCE_DRINK4_ not found or couldn't be loaded for variable
options_reduce_drink4.
ERROR: Format OPTIONS_REDUCE_DRINK5_ not found or couldn't be loaded for variable
options_reduce_drink5.
ERROR: Format OPTIONS_REDUCE_DRINK6_ not found or couldn't be loaded for variable
options_reduce_drink6.
ERROR: Format OPTIONS_REDUCE_DRINK7_ not found or couldn't be loaded for variable
options_reduce_drink7.
ERROR: Format OPTIONS_REDUCE_DRINK8_ not found or couldn't be loaded for variable
options_reduce_drink8.
ERROR: Format OPTIONS_REDUCE_DRINK9_ not found or couldn't be loaded for variable
options_reduce_drink9.
ERROR: Format OPTIONS_REDUCE_DRINK10_ not found or couldn't be loaded for variable
options_reduce_drink10.
ERROR: Format SCREEN_AGE_ not found or couldn't be loaded for variable Screen_age.
ERROR: Format STATE_RESIDENCE_ not found or couldn't be loaded for variable state_residence.
ERROR: Format EMPLOYMENT_STATUS_ not found or couldn't be loaded for variable employment_status.
ERROR: Format STUDENT_STATUS_ not found or couldn't be loaded for variable student_status.
ERROR: Format PAST_MONTH_DRINKING_ not found or couldn't be loaded for variable
past_month_drinking.
ERROR: Format PAST30_BINGE_ not found or couldn't be loaded for variable past30_binge.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.46 seconds
cpu time 0.37 seconds
I am guessing it can't read the formats based on the errors, but I have never had this problem before. Is there a way for my colleague to open the file in Base Sas without me altering my original made in EG?
Any help would be appreciated.
Thank you
Joe
1 ACCEPTED SOLUTION
Accepted Solutions
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Since format catalogs are not always compatible if the SAS systems are on other operating systems you may need to:
1) provide the code that creates all of those formats
2) provide a data set that your colleague can use to create the formats
3) have the colleague use the OPTION NOFMTERR; which is likely the setting causing the errors. This option tells SAS to treat referencing an unknown format is an error and your data set has had the formats permanently associated with the variables in that data set
4) remove the format associations in the data set before providing it to the colleague.
Simplest may be to provide the proc format code used to create the format and have the executed before attempting to use the data set.
4 REPLIES 4
SAS Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
In order for your colleague to open the table in Base SAS your colleague will need access to the format library location. Then in Base SAS they can say:
libname udf "<userDefinedFormat library location>" access=readonly;
%put %sysfunc(getoption(fmtsearch));
options append=fmtsearch=udf;
%put %sysfunc(getoption(fmtsearch));After which they should be able to open your table.
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
You don't have the formats defined that are used in the data set. You need to get the formats from your old system or you can turn off the formats entirely but then you just get the underlying values. If you add the following option, if SAS can't find the format it will not error out and will show you the underlying values instead.
options nofmterr;
@joebacon wrote:
HI all.
I've encountered a strange problem today. My company shares a shared drive as most do. I have a file that I worked on in SAS EG 8.1 that refuses to open in BASE SAS. When attempting to open it via the folder, it just has a "browse with SAS 9.4" opposed to the "open with SAS EG 8.1". Further, when I try to call the destination in Base SAS with the following command I am met with formatting errors and no dataset.
libname RDS 'S:\ Drink Survey\Data\Data Analysis'; run; proc means data='S:\ Drink Survey\Data\Data Analysis\full_weights.sas7bdat'; var Gender; run;I get these errors:
libname RDS 'S:\UF Drink Survey\Data\Data Analysis'; NOTE: Libref RDS refers to the same physical library as WC000001. NOTE: Libref RDS was successfully assigned as follows: Engine: V9 Physical Name: S:\UF Drink Survey\Data\Data Analysis 37 run; 38 proc print data='S:\UF Drink Survey\Data\Data Analysis\full_weights.sas7bdat'; 39 40 run; ERROR: Format ICF_ not found or couldn't be loaded for variable icf. ERROR: Format GENDER_ not found or couldn't be loaded for variable gender. ERROR: Format RACE_ not found or couldn't be loaded for variable race. ERROR: Format HISPANIC_LATINO_ not found or couldn't be loaded for variable hispanic_latino. ERROR: Format MARITAL_STATUS_ not found or couldn't be loaded for variable marital_status. ERROR: Format LEVEL_EDUCATION_ not found or couldn't be loaded for variable level_education. ERROR: Format YEARLY_INCOME_ not found or couldn't be loaded for variable yearly_income. ERROR: Format HOUSEHOLD_INCOME_ not found or couldn't be loaded for variable household_income. ERROR: Format PUBLIC_BENEFIT_1_ not found or couldn't be loaded for variable public_benefit_1. ERROR: Format PUBLIC_BENEFIT_2_ not found or couldn't be loaded for variable public_benefit_2. ERROR: Format PUBLIC_BENEFIT_3_ not found or couldn't be loaded for variable public_benefit_3. ERROR: Format PUBLIC_BENEFIT_4_ not found or couldn't be loaded for variable public_benefit_4. ERROR: Format PUBLIC_BENEFIT_5_ not found or couldn't be loaded for variable public_benefit_5. ERROR: Format AGE_FIRST_DRINK_ not found or couldn't be loaded for variable age_first_drink. ERROR: Format AGE_FIRST_INTOXICATED_ not found or couldn't be loaded for variable age_first_intoxicated. ERROR: Format DRINK_DAYS_PAST30_ not found or couldn't be loaded for variable drink_days_past30. ERROR: Format TREATMENT_INTERVENTION___1_ not found or couldn't be loaded for variable treatment_intervention___1. ERROR: Format TREATMENT_INTERVENTION___2_ not found or couldn't be loaded for variable treatment_intervention___2. ERROR: Format TREATMENT_INTERVENTION___3_ not found or couldn't be loaded for variable treatment_intervention___3. ERROR: Format TREATMENT_INTERVENTION___4_ not found or couldn't be loaded for variable treatment_intervention___4. ERROR: Format TREATMENT_INTERVENTION___5_ not found or couldn't be loaded for variable treatment_intervention___5. ERROR: Format TREATMENT_INTERVENTION___6_ not found or couldn't be loaded for variable treatment_intervention___6. ERROR: Format CURRENT_TOBACCO_USE_ not found or couldn't be loaded for variable current_tobacco_use. ERROR: Format LIFETIME_ILLICIT_DRUG_ not found or couldn't be loaded for variable lifetime_illicit_drug. ERROR: Format LIFETIME_PRSCRPTN_DRUGS_ not found or couldn't be loaded for variable lifetime_prscrptn_drugs. ERROR: Format LIFETIME_ALC_DRUG_MIX_ not found or couldn't be loaded for variable lifetime_alc_drug_mix. ERROR: Format YAACQB_1_ not found or couldn't be loaded for variable yaacqb_1. ERROR: Format YAACQB_2_ not found or couldn't be loaded for variable yaacqb_2. ERROR: Format YAACQB_3_ not found or couldn't be loaded for variable yaacqb_3. ERROR: Format YAACQB_4_ not found or couldn't be loaded for variable yaacqb_4. ERROR: Format YAACQB_5_ not found or couldn't be loaded for variable yaacqb_5. ERROR: Format YAACQB_6_ not found or couldn't be loaded for variable yaacqb_6. ERROR: Format YAACQB_7_ not found or couldn't be loaded for variable yaacqb_7. ERROR: Format YAACQB_8_ not found or couldn't be loaded for variable yaacqb_8. ERROR: Format YAACQB_9_ not found or couldn't be loaded for variable yaacqb_9. ERROR: Format YAACQB_10_ not found or couldn't be loaded for variable yaacqb_10. ERROR: Format YAACQB_11_ not found or couldn't be loaded for variable yaacqb_11. ERROR: Format YAACQB_12_ not found or couldn't be loaded for variable yaacqb_12. ERROR: Format YAACQB_13_ not found or couldn't be loaded for variable yaacqb_13. ERROR: Format YAACQB_14_ not found or couldn't be loaded for variable yaacqb_14. ERROR: Format YAACQB_15_ not found or couldn't be loaded for variable yaacqb_15. ERROR: Format YAACQB_16_ not found or couldn't be loaded for variable yaacqb_16. ERROR: Format YAACQB_17_ not found or couldn't be loaded for variable yaacqb_17. ERROR: Format YAACQB_18_ not found or couldn't be loaded for variable yaacqb_18. ERROR: Format YAACQB_19_ not found or couldn't be loaded for variable yaacqb_19. ERROR: Format YAACQB_20_ not found or couldn't be loaded for variable yaacqb_20. ERROR: Format YAACQB_21_ not found or couldn't be loaded for variable yaacqb_21. ERROR: Format YAACQB_22_ not found or couldn't be loaded for variable yaacqb_22. ERROR: Format YAACQB_23_ not found or couldn't be loaded for variable yaacqb_23. ERROR: Format YAACQB_24_ not found or couldn't be loaded for variable yaacqb_24. ERROR: Format DD_1_ not found or couldn't be loaded for variable dd_1. ERROR: Format DD_2_ not found or couldn't be loaded for variable dd_2. ERROR: Format DD_3_ not found or couldn't be loaded for variable dd_3. ERROR: Format DD_4_ not found or couldn't be loaded for variable dd_4. ERROR: Format DD_5_ not found or couldn't be loaded for variable dd_5. ERROR: Format DD_6_ not found or couldn't be loaded for variable dd_6. ERROR: Format DD_7_ not found or couldn't be loaded for variable dd_7. ERROR: Format DD_8_ not found or couldn't be loaded for variable dd_8. ERROR: Format DD_9_ not found or couldn't be loaded for variable dd_9. ERROR: Format DD_10_ not found or couldn't be loaded for variable dd_10. ERROR: Format DD_11_ not found or couldn't be loaded for variable dd_11. ERROR: Format DD_12_ not found or couldn't be loaded for variable dd_12. ERROR: Format DD_13_ not found or couldn't be loaded for variable dd_13. ERROR: Format DD_14_ not found or couldn't be loaded for variable dd_14. ERROR: Format DD_15_ not found or couldn't be loaded for variable dd_15. ERROR: Format DD_16_ not found or couldn't be loaded for variable dd_16. ERROR: Format DD_17_ not found or couldn't be loaded for variable dd_17. ERROR: Format AC_LVL_WOD_FREQ1_ not found or couldn't be loaded for variable ac_lvl_wod_freq1. ERROR: Format AC_LVL_WOD_FREQ2_ not found or couldn't be loaded for variable ac_lvl_wod_freq2. ERROR: Format AC_LVL_WOD_FREQ3_ not found or couldn't be loaded for variable ac_lvl_wod_freq3. ERROR: Format AC_LVL_WOD_FREQ4_ not found or couldn't be loaded for variable ac_lvl_wod_freq4. ERROR: Format AC_LVL_WOD_FREQ5_ not found or couldn't be loaded for variable ac_lvl_wod_freq5. ERROR: Format AC_LVL_WOD_FREQ6_ not found or couldn't be loaded for variable ac_lvl_wod_freq6. ERROR: Format AC_LVL_WOD_FREQ7_ not found or couldn't be loaded for variable ac_lvl_wod_freq7. ERROR: Format AC_LVL_WOD_FREQ8_ not found or couldn't be loaded for variable ac_lvl_wod_freq8. ERROR: Format AC_LVL_WOD_FREQ9_ not found or couldn't be loaded for variable ac_lvl_wod_freq9. ERROR: Format AC_LVL_WOD_FREQ10_ not found or couldn't be loaded for variable ac_lvl_wod_freq10. ERROR: Format AC_LVL_WOD_FREQ11_ not found or couldn't be loaded for variable ac_lvl_wod_freq11. ERROR: Format AC_LVL_WOD_FREQ12_ not found or couldn't be loaded for variable ac_lvl_wod_freq12. ERROR: Format AC_LVL_WOD_FREQ13_ not found or couldn't be loaded for variable ac_lvl_wod_freq13. ERROR: Format AC_LVL_WOD_FREQ14_ not found or couldn't be loaded for variable ac_lvl_wod_freq14. ERROR: Format AC_LVL_WOD_FREQ15_ not found or couldn't be loaded for variable ac_lvl_wod_freq15. ERROR: Format AC_LVL_WOD_FREQ16_ not found or couldn't be loaded for variable ac_lvl_wod_freq16. ERROR: Format AC_LVL_WOD_FREQ17_ not found or couldn't be loaded for variable ac_lvl_wod_freq17. ERROR: Format AC_LVL_WOD_FREQ18_ not found or couldn't be loaded for variable ac_lvl_wod_freq18. ERROR: Format AC_LVL_WOD_FREQ19_ not found or couldn't be loaded for variable ac_lvl_wod_freq19. ERROR: Format AC_LVL_WOD_FREQ20_ not found or couldn't be loaded for variable ac_lvl_wod_freq20. ERROR: Format AC_LVL_WOD_FREQ21_ not found or couldn't be loaded for variable ac_lvl_wod_freq21. ERROR: Format AC_LVL_WOD_FREQ22_ not found or couldn't be loaded for variable ac_lvl_wod_freq22. ERROR: Format AC_LVL_WOD_FREQ23_ not found or couldn't be loaded for variable ac_lvl_wod_freq23. ERROR: Format AC_LVL_WOD_FREQ24_ not found or couldn't be loaded for variable ac_lvl_wod_freq24. ERROR: Format AC_LVL_WOD_FREQ25_ not found or couldn't be loaded for variable ac_lvl_wod_freq25. ERROR: Format AC_LVL_WOD_FREQ26_ not found or couldn't be loaded for variable ac_lvl_wod_freq26. ERROR: Format AC_LVL_WOD_FREQ27_ not found or couldn't be loaded for variable ac_lvl_wod_freq27. ERROR: Format AC_LVL_WOD_FREQ28_ not found or couldn't be loaded for variable ac_lvl_wod_freq28. ERROR: Format AC_LVL_WOD_FREQ29_ not found or couldn't be loaded for variable ac_lvl_wod_freq29. ERROR: Format AC_LVL_WOD_FREQ30_ not found or couldn't be loaded for variable ac_lvl_wod_freq30. ERROR: Format AC_LVL_WOD_FREQ31_ not found or couldn't be loaded for variable ac_lvl_wod_freq31. ERROR: Format AC_LVL_WOD_FREQ32_ not found or couldn't be loaded for variable ac_lvl_wod_freq32. ERROR: Format AC_LVL_WOD_FREQ33_ not found or couldn't be loaded for variable ac_lvl_wod_freq33. ERROR: Format AC_LVL_WOD_FREQ34_ not found or couldn't be loaded for variable ac_lvl_wod_freq34. ERROR: Format AC_LVL_WOD_FREQ35_ not found or couldn't be loaded for variable ac_lvl_wod_freq35. ERROR: Format AC_LVL_WOD_FREQ36_ not found or couldn't be loaded for variable ac_lvl_wod_freq36. ERROR: Format ACT_LVL_WD_FREQ1_ not found or couldn't be loaded for variable act_lvl_wd_freq1. ERROR: Format ACT_LVL_WD_FREQ2_ not found or couldn't be loaded for variable act_lvl_wd_freq2. ERROR: Format ACT_LVL_WD_FREQ3_ not found or couldn't be loaded for variable act_lvl_wd_freq3. ERROR: Format ACT_LVL_WD_FREQ4_ not found or couldn't be loaded for variable act_lvl_wd_freq4. ERROR: Format ACT_LVL_WD_FREQ5_ not found or couldn't be loaded for variable act_lvl_wd_freq5. ERROR: Format ACT_LVL_WD_FREQ6_ not found or couldn't be loaded for variable act_lvl_wd_freq6. ERROR: Format ACT_LVL_WD_FREQ7_ not found or couldn't be loaded for variable act_lvl_wd_freq7. ERROR: Format ACT_LVL_WD_FREQ8_ not found or couldn't be loaded for variable act_lvl_wd_freq8. ERROR: Format ACT_LVL_WD_FREQ9_ not found or couldn't be loaded for variable act_lvl_wd_freq9. ERROR: Format ACT_LVL_WD_FREQ10_ not found or couldn't be loaded for variable act_lvl_wd_freq10. ERROR: Format ACT_LVL_WD_FREQ11_ not found or couldn't be loaded for variable act_lvl_wd_freq11. ERROR: Format ACT_LVL_WD_FREQ12_ not found or couldn't be loaded for variable act_lvl_wd_freq12. ERROR: Format ACT_LVL_WD_FREQ13_ not found or couldn't be loaded for variable act_lvl_wd_freq13. ERROR: Format ACT_LVL_WD_FREQ14_ not found or couldn't be loaded for variable act_lvl_wd_freq14. ERROR: Format ACT_LVL_WD_FREQ15_ not found or couldn't be loaded for variable act_lvl_wd_freq15. ERROR: Format ACT_LVL_WD_FREQ16_ not found or couldn't be loaded for variable act_lvl_wd_freq16. ERROR: Format ACT_LVL_WD_FREQ17_ not found or couldn't be loaded for variable act_lvl_wd_freq17. ERROR: Format ACT_LVL_WD_FREQ18_ not found or couldn't be loaded for variable act_lvl_wd_freq18. ERROR: Format ACT_LVL_WD_FREQ19_ not found or couldn't be loaded for variable act_lvl_wd_freq19. ERROR: Format ACT_LVL_WD_FREQ20_ not found or couldn't be loaded for variable act_lvl_wd_freq20. ERROR: Format ACT_LVL_WD_FREQ21_ not found or couldn't be loaded for variable act_lvl_wd_freq21. ERROR: Format ACT_LVL_WD_FREQ22_ not found or couldn't be loaded for variable act_lvl_wd_freq22. ERROR: Format ACT_LVL_WD_FREQ23_ not found or couldn't be loaded for variable act_lvl_wd_freq23. ERROR: Format ACT_LVL_WD_FREQ24_ not found or couldn't be loaded for variable act_lvl_wd_freq24. ERROR: Format ACT_LVL_WD_FREQ25_ not found or couldn't be loaded for variable act_lvl_wd_freq25. ERROR: Format ACT_LVL_WD_FREQ26_ not found or couldn't be loaded for variable act_lvl_wd_freq26. ERROR: Format ACT_LVL_WD_FREQ27_ not found or couldn't be loaded for variable act_lvl_wd_freq27. ERROR: Format ACT_LVL_WD_FREQ28_ not found or couldn't be loaded for variable act_lvl_wd_freq28. ERROR: Format ACT_LVL_WD_FREQ29_ not found or couldn't be loaded for variable act_lvl_wd_freq29. ERROR: Format ACT_LVL_WD_FREQ30_ not found or couldn't be loaded for variable act_lvl_wd_freq30. ERROR: Format ACT_LVL_WD_FREQ31_ not found or couldn't be loaded for variable act_lvl_wd_freq31. ERROR: Format ACT_LVL_WD_FREQ32_ not found or couldn't be loaded for variable act_lvl_wd_freq32. ERROR: Format ACT_LVL_WD_FREQ33_ not found or couldn't be loaded for variable act_lvl_wd_freq33. ERROR: Format ACT_LVL_WD_FREQ34_ not found or couldn't be loaded for variable act_lvl_wd_freq34. ERROR: Format ACT_LVL_WD_FREQ35_ not found or couldn't be loaded for variable act_lvl_wd_freq35. ERROR: Format ACT_LVL_WD_FREQ36_ not found or couldn't be loaded for variable act_lvl_wd_freq36. ERROR: Format PBSS20_1_ not found or couldn't be loaded for variable pbss20_1. ERROR: Format PBSS20_2_ not found or couldn't be loaded for variable pbss20_2. ERROR: Format PBSS20_3_ not found or couldn't be loaded for variable pbss20_3. ERROR: Format PBSS20_4_ not found or couldn't be loaded for variable pbss20_4. ERROR: Format PBSS20_5_ not found or couldn't be loaded for variable pbss20_5. ERROR: Format PBSS20_6_ not found or couldn't be loaded for variable pbss20_6. ERROR: Format PBSS20_7_ not found or couldn't be loaded for variable pbss20_7. ERROR: Format PBSS20_8_ not found or couldn't be loaded for variable pbss20_8. ERROR: Format PBSS20_9_ not found or couldn't be loaded for variable pbss20_9. ERROR: Format PBSS20_10_ not found or couldn't be loaded for variable pbss20_10. ERROR: Format PBSS20_11_ not found or couldn't be loaded for variable pbss20_11. ERROR: Format PBSS20_12_ not found or couldn't be loaded for variable pbss20_12. ERROR: Format PBSS20_13_ not found or couldn't be loaded for variable pbss20_13. ERROR: Format PBSS20_14_ not found or couldn't be loaded for variable pbss20_14. ERROR: Format PBSS20_15_ not found or couldn't be loaded for variable pbss20_15. ERROR: Format PBSS20_16_ not found or couldn't be loaded for variable pbss20_16. ERROR: Format PBSS20_17_ not found or couldn't be loaded for variable pbss20_17. ERROR: Format PBSS20_18_ not found or couldn't be loaded for variable pbss20_18. ERROR: Format PBSS20_19_ not found or couldn't be loaded for variable pbss20_19. ERROR: Format PBSS20_20_ not found or couldn't be loaded for variable pbss20_20. ERROR: Format BEHAVIOR_CHANGE_LADDER_2_ not found or couldn't be loaded for variable behavior_change_ladder_2. ERROR: Format SNQ_1_RELATION_ not found or couldn't be loaded for variable snq_1_relation. ERROR: Format SNQ_PERSON1_Q1_ not found or couldn't be loaded for variable snq_person1_q1. ERROR: Format SNQ_PERSON1_Q2_ not found or couldn't be loaded for variable snq_person1_q2. ERROR: Format SNQ_PERSON1_Q3_ not found or couldn't be loaded for variable snq_person1_q3. ERROR: Format SNQ_PERSON1_Q4_ not found or couldn't be loaded for variable snq_person1_q4. ERROR: Format SNQ_PERSON1_Q5_ not found or couldn't be loaded for variable snq_person1_q5. ERROR: Format SNQ_PERSON1_Q6_ not found or couldn't be loaded for variable snq_person1_q6. ERROR: Format SNQ_PERSON1_Q7_ not found or couldn't be loaded for variable snq_person1_q7. ERROR: Format SNQ_PERSON1_Q8_ not found or couldn't be loaded for variable snq_person1_q8. ERROR: Format SNQ_PERSON1_Q9_ not found or couldn't be loaded for variable snq_person1_q9. ERROR: Format SNQ_PERSON1_Q10_ not found or couldn't be loaded for variable snq_person1_q10. ERROR: Format SNQ_PERSON2_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person2_relationship. ERROR: Format SNQ_PERSON2_Q1_ not found or couldn't be loaded for variable snq_person2_q1. ERROR: Format SNQ_PERSON2_Q2_ not found or couldn't be loaded for variable snq_person2_q2. ERROR: Format SNQ_PERSON2_Q3_ not found or couldn't be loaded for variable snq_person2_q3. ERROR: Format SNQ_PERSON2_Q4_ not found or couldn't be loaded for variable snq_person2_q4. ERROR: Format SNQ_PERSON2_Q5_ not found or couldn't be loaded for variable snq_person2_q5. ERROR: Format SNQ_PERSON2_Q6_ not found or couldn't be loaded for variable snq_person2_q6. ERROR: Format SNQ_PERSON2_Q7_ not found or couldn't be loaded for variable snq_person2_q7. ERROR: Format SNQ_PERSON2_Q8_ not found or couldn't be loaded for variable snq_person2_q8. ERROR: Format SNQ_PERSON2_Q9_ not found or couldn't be loaded for variable snq_person2_q9. ERROR: Format SNQ_PERSON2_Q10_ not found or couldn't be loaded for variable snq_person2_q10. ERROR: Format SNQ_PERSON3_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person3_relationship. ERROR: Format SNQ_PERSON3_Q1_ not found or couldn't be loaded for variable snq_person3_q1. ERROR: Format SNQ_PERSON3_Q2_ not found or couldn't be loaded for variable snq_person3_q2. ERROR: Format SNQ_PERSON3_Q3_ not found or couldn't be loaded for variable snq_person3_q3. ERROR: Format SNQ_PERSON3_Q4_ not found or couldn't be loaded for variable snq_person3_q4. ERROR: Format SNQ_PERSON3_Q5_ not found or couldn't be loaded for variable snq_person3_q5. ERROR: Format SNQ_PERSON3_Q6_ not found or couldn't be loaded for variable snq_person3_q6. ERROR: Format SNQ_PERSON3_Q7_ not found or couldn't be loaded for variable snq_person3_q7. ERROR: Format SNQ_PERSON3_Q8_ not found or couldn't be loaded for variable snq_person3_q8. ERROR: Format SNQ_PERSON3_Q9_ not found or couldn't be loaded for variable snq_person3_q9. ERROR: Format SNQ_PERSON3_Q10_ not found or couldn't be loaded for variable snq_person3_q10. ERROR: Format SNQ_PERSON4_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person4_relationship. ERROR: Format SNQ_PERSON4_Q1_ not found or couldn't be loaded for variable snq_person4_q1. ERROR: Format SNQ_PERSON4_Q2_ not found or couldn't be loaded for variable snq_person4_q2. ERROR: Format SNQ_PERSON4_Q3_ not found or couldn't be loaded for variable snq_person4_q3. ERROR: Format SNQ_PERSON4_Q4_ not found or couldn't be loaded for variable snq_person4_q4. ERROR: Format SNQ_PERSON4_Q5_ not found or couldn't be loaded for variable snq_person4_q5. ERROR: Format SNQ_PERSON4_Q6_ not found or couldn't be loaded for variable snq_person4_q6. ERROR: Format SNQ_PERSON4_Q7_ not found or couldn't be loaded for variable snq_person4_q7. ERROR: Format SNQ_PERSON4_Q8_ not found or couldn't be loaded for variable snq_person4_q8. ERROR: Format SNQ_PERSON4_Q9_ not found or couldn't be loaded for variable snq_person4_q9. ERROR: Format SNQ_PERSON4_Q10_ not found or couldn't be loaded for variable snq_person4_q10. ERROR: Format ADD_NW_MEMBER5_ not found or couldn't be loaded for variable add_nw_member5. ERROR: Format SNQ_PERSON5_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person5_relationship. ERROR: Format SNQ_PERSON5_Q1_ not found or couldn't be loaded for variable snq_person5_q1. ERROR: Format SNQ_PERSON5_Q2_ not found or couldn't be loaded for variable snq_person5_q2. ERROR: Format SNQ_PERSON5_Q3_ not found or couldn't be loaded for variable snq_person5_q3. ERROR: Format SNQ_PERSON5_Q4_ not found or couldn't be loaded for variable snq_person5_q4. ERROR: Format SNQ_PERSON5_Q5_ not found or couldn't be loaded for variable snq_person5_q5. ERROR: Format SNQ_PERSON5_Q6_ not found or couldn't be loaded for variable snq_person5_q6. ERROR: Format SNQ_PERSON5_Q7_ not found or couldn't be loaded for variable snq_person5_q7. ERROR: Format SNQ_PERSON5_Q8_ not found or couldn't be loaded for variable snq_person5_q8. ERROR: Format SNQ_PERSON5_Q9_ not found or couldn't be loaded for variable snq_person5_q9. ERROR: Format SNQ_PERSON5_Q10_ not found or couldn't be loaded for variable snq_person5_q10. ERROR: Format ADD_NW_MEMBER6_ not found or couldn't be loaded for variable add_nw_member6. ERROR: Format SNQ_PERSON6_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person6_relationship. ERROR: Format SNQ_PERSON6_Q1_ not found or couldn't be loaded for variable snq_person6_q1. ERROR: Format SNQ_PERSON6_Q2_ not found or couldn't be loaded for variable snq_person6_q2. ERROR: Format SNQ_PERSON6_Q3_ not found or couldn't be loaded for variable snq_person6_q3. ERROR: Format SNQ_PERSON6_Q4_ not found or couldn't be loaded for variable snq_person6_q4. ERROR: Format SNQ_PERSON6_Q5_ not found or couldn't be loaded for variable snq_person6_q5. ERROR: Format SNQ_PERSON6_Q6_ not found or couldn't be loaded for variable snq_person6_q6. ERROR: Format SNQ_PERSON6_Q7_ not found or couldn't be loaded for variable snq_person6_q7. ERROR: Format SNQ_PERSON6_Q8_ not found or couldn't be loaded for variable snq_person6_q8. ERROR: Format SNQ_PERSON6_Q9_ not found or couldn't be loaded for variable snq_person6_q9. ERROR: Format SNQ_PERSON6_Q10_ not found or couldn't be loaded for variable snq_person6_q10. ERROR: Format ADD_NW_MEMBER7_ not found or couldn't be loaded for variable add_nw_member7. ERROR: Format SNQ_PERSON7_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person7_relationship. ERROR: Format SNQ_PERSON7_Q1_ not found or couldn't be loaded for variable snq_person7_q1. ERROR: Format SNQ_PERSON7_Q2_ not found or couldn't be loaded for variable snq_person7_q2. ERROR: Format SNQ_PERSON7_Q3_ not found or couldn't be loaded for variable snq_person7_q3. ERROR: Format SNQ_PERSON7_Q4_ not found or couldn't be loaded for variable snq_person7_q4. ERROR: Format SNQ_PERSON7_Q5_ not found or couldn't be loaded for variable snq_person7_q5. ERROR: Format SNQ_PERSON7_Q6_ not found or couldn't be loaded for variable snq_person7_q6. ERROR: Format SNQ_PERSON7_Q7_ not found or couldn't be loaded for variable snq_person7_q7. ERROR: Format SNQ_PERSON7_Q8_ not found or couldn't be loaded for variable snq_person7_q8. ERROR: Format SNQ_PERSON7_Q9_ not found or couldn't be loaded for variable snq_person7_q9. ERROR: Format SNQ_PERSON7_Q10_ not found or couldn't be loaded for variable snq_person7_q10. ERROR: Format ADD_NW_MEMBER_8_ not found or couldn't be loaded for variable add_nw_member_8. ERROR: Format SNQ_PERSON8_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person8_relationship. ERROR: Format SNQ_PERSON8_Q1_ not found or couldn't be loaded for variable snq_person8_q1. ERROR: Format SNQ_PERSON8_Q2_ not found or couldn't be loaded for variable snq_person8_q2. ERROR: Format SNQ_PERSON8_Q3_ not found or couldn't be loaded for variable snq_person8_q3. ERROR: Format SNQ_PERSON8_Q4_ not found or couldn't be loaded for variable snq_person8_q4. ERROR: Format SNQ_PERSON8_Q5_ not found or couldn't be loaded for variable snq_person8_q5. ERROR: Format SNQ_PERSON8_Q6_ not found or couldn't be loaded for variable snq_person8_q6. ERROR: Format SNQ_PERSON8_Q7_ not found or couldn't be loaded for variable snq_person8_q7. ERROR: Format SNQ_PERSON8_Q8_ not found or couldn't be loaded for variable snq_person8_q8. ERROR: Format SNQ_PERSON8_Q09_ not found or couldn't be loaded for variable snq_person8_q09. ERROR: Format SNQ_PERSON8_Q10_ not found or couldn't be loaded for variable snq_person8_q10. ERROR: Format ADD_NW_MEMBER9_ not found or couldn't be loaded for variable add_nw_member9. ERROR: Format SNQ_PERSON9_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person9_relationship. ERROR: Format SNQ_PERSON9_Q1_ not found or couldn't be loaded for variable snq_person9_q1. ERROR: Format SNQ_PERSON9_Q2_ not found or couldn't be loaded for variable snq_person9_q2. ERROR: Format SNQ_PERSON9_Q3_ not found or couldn't be loaded for variable snq_person9_q3. ERROR: Format SNQ_PERSON9_Q4_ not found or couldn't be loaded for variable snq_person9_q4. ERROR: Format SNQ_PERSON9_Q5_ not found or couldn't be loaded for variable snq_person9_q5. ERROR: Format SNQ_PERSON9_Q6_ not found or couldn't be loaded for variable snq_person9_q6. ERROR: Format SNQ_PERSON9_Q7_ not found or couldn't be loaded for variable snq_person9_q7. ERROR: Format SNQ_PERSON9_Q8_ not found or couldn't be loaded for variable snq_person9_q8. ERROR: Format SNQ_PERSON9_Q9_ not found or couldn't be loaded for variable snq_person9_q9. ERROR: Format SNQ_PERSON9_Q10_ not found or couldn't be loaded for variable snq_person9_q10. ERROR: Format ADD_NW_MEMBER_10_ not found or couldn't be loaded for variable add_nw_member_10. ERROR: Format SNQ_PERSON10_RELATIONSHIP_ not found or couldn't be loaded for variable snq_person10_relationship. ERROR: Format SNQ_PERSON10_Q1_ not found or couldn't be loaded for variable snq_person10_q1. ERROR: Format SNQ_PERSON10_Q2_ not found or couldn't be loaded for variable snq_person10_q2. ERROR: Format SNQ_PERSON10_Q3_ not found or couldn't be loaded for variable snq_person10_q3. ERROR: Format SNQ_PERSON10_Q4_ not found or couldn't be loaded for variable snq_person10_q4. ERROR: Format SNQ_PERSON10_Q5_ not found or couldn't be loaded for variable snq_person10_q5. ERROR: Format SNQ_PERSON10_Q6_ not found or couldn't be loaded for variable snq_person10_q6. ERROR: Format SNQ_PERSON10_Q7_ not found or couldn't be loaded for variable snq_person10_q7. ERROR: Format SNQ_PERSON10_Q8_ not found or couldn't be loaded for variable snq_person10_q8. ERROR: Format SNQ_PERSON10_Q9_ not found or couldn't be loaded for variable snq_person10_q9. ERROR: Format SNQ_PERSON10_Q10_ not found or couldn't be loaded for variable snq_person10_q10. ERROR: Format LOST_RELATIONSHIP_ not found or couldn't be loaded for variable lost_relationship. ERROR: Format SPOUSE_NOT_AVAILABLE_ not found or couldn't be loaded for variable spouse_not_available. ERROR: Format CHILD_NOT_AVAILABLE_ not found or couldn't be loaded for variable child_not_available. ERROR: Format RELATIVE_NOT_AVAILABLE_ not found or couldn't be loaded for variable relative_not_available. ERROR: Format FRIENDS_NOT_AVAILABLE_ not found or couldn't be loaded for variable friends_not_available. ERROR: Format OTHER_NOT_AVAILABLE_ not found or couldn't be loaded for variable other_not_available. ERROR: Format LOST_SUPPORT_ not found or couldn't be loaded for variable lost_support. ERROR: Format OPTIONS_REDUCE_DRINK1_ not found or couldn't be loaded for variable options_reduce_drink1. ERROR: Format OPTIONS_REDUCE_DRINK2_ not found or couldn't be loaded for variable options_reduce_drink2. ERROR: Format OPTIONS_REDUCE_DRINK3_ not found or couldn't be loaded for variable options_reduce_drink3. ERROR: Format OPTIONS_REDUCE_DRINK4_ not found or couldn't be loaded for variable options_reduce_drink4. ERROR: Format OPTIONS_REDUCE_DRINK5_ not found or couldn't be loaded for variable options_reduce_drink5. ERROR: Format OPTIONS_REDUCE_DRINK6_ not found or couldn't be loaded for variable options_reduce_drink6. ERROR: Format OPTIONS_REDUCE_DRINK7_ not found or couldn't be loaded for variable options_reduce_drink7. ERROR: Format OPTIONS_REDUCE_DRINK8_ not found or couldn't be loaded for variable options_reduce_drink8. ERROR: Format OPTIONS_REDUCE_DRINK9_ not found or couldn't be loaded for variable options_reduce_drink9. ERROR: Format OPTIONS_REDUCE_DRINK10_ not found or couldn't be loaded for variable options_reduce_drink10. ERROR: Format SCREEN_AGE_ not found or couldn't be loaded for variable Screen_age. ERROR: Format STATE_RESIDENCE_ not found or couldn't be loaded for variable state_residence. ERROR: Format EMPLOYMENT_STATUS_ not found or couldn't be loaded for variable employment_status. ERROR: Format STUDENT_STATUS_ not found or couldn't be loaded for variable student_status. ERROR: Format PAST_MONTH_DRINKING_ not found or couldn't be loaded for variable past_month_drinking. ERROR: Format PAST30_BINGE_ not found or couldn't be loaded for variable past30_binge. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.46 seconds cpu time 0.37 secondsI am guessing it can't read the formats based on the errors, but I have never had this problem before. Is there a way for my colleague to open the file in Base Sas without me altering my original made in EG?
Any help would be appreciated.
Thank you
Joe
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Since format catalogs are not always compatible if the SAS systems are on other operating systems you may need to:
1) provide the code that creates all of those formats
2) provide a data set that your colleague can use to create the formats
3) have the colleague use the OPTION NOFMTERR; which is likely the setting causing the errors. This option tells SAS to treat referencing an unknown format is an error and your data set has had the formats permanently associated with the variables in that data set
4) remove the format associations in the data set before providing it to the colleague.
Simplest may be to provide the proc format code used to create the format and have the executed before attempting to use the data set.
Jade | Level 19
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Please note that EG has the option mentioned by @Reeza turned on by default, so you won't see errors for missing formats, if you don't use
options fmterr;in your code.
Two more things to note:
- you don't need run after libname.
- if you define a libref, use it. Having a full path after data= is bad design, as it reduces readability and makes maintaining the code more difficult.
SAS Innovate 2025: Call for Content
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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 webinar
Classroom Training Available!
Select SAS Training centers are offering in-person courses. View upcoming courses for:
Discussion stats
-
4 replies
-
03-25-2020 04:49 PM
-
724 views
-
5 likes
-
5 in conversation
-
