labels not showing

[whyknock]

Hi Everyone,

I'm doing the online SAS Programming 1 class and I'm having trouble getting my labels to show in SAS Enterprise Guide.  We're using the sashelp.cars table and this is in activity p105a04. 

We're supposed to use a data statement to assign permanent labels to some columns, then run the means and print procedures with the output using the labels rather than the original column names.

This is the code that I have, which matches exactly with what the solution has:

data cars_update;
    set sashelp.cars;
    keep Make Model MSRP Invoice AvgMPG;
    AvgMPG=mean(MPG_Highway, MPG_City);
    label MSRP="Manufacturer Suggested Retail Price"
    AvgMPG="Average Miles per Gallon"
    Invoice="Invoice Price";
run;

proc means data=cars_update min mean max;
    var MSRP Invoice;
run;

proc print data=cars_update label;
    var Make Model MSRP Invoice AvgMPG;
run;

The labels for the columns should be replaced with my new labels (eg. MRSP should be "Manufacturer Suggested Retail Price"), but it's only showing the original column names. 

Here's what the output tables look like:

I looked at proc contents like she did in the lesson, but the labels weren't in there.  

I also tried using the proc print statement with temporary labels, but the labels didn't show up for that either:

proc print data=cars_update label;
    var Make Model MSRP Invoice AvgMPG;
    label MSRP="Manufacturer Suggested Retail Price"
             AvgMPG="Average Miles per Gallon"
             Invoice="Invoice Price";
run;

Any help would be greatly appreciated!  

Thanks in advance!

[ballardw · Accepted solution]

---

@whyknock wrote:

Hi Everyone,

I'm doing the online SAS Programming 1 class and I'm having trouble getting my labels to show in SAS Enterprise Guide.  We're using the sashelp.cars table and this is in activity p105a04. 

We're supposed to use a data statement to assign permanent labels to some columns, then run the means and print procedures with the output using the labels rather than the original column names.

This is the code that I have, which matches exactly with what the solution has:

data cars_update;
    set sashelp.cars;
    keep Make Model MSRP Invoice AvgMPG;
    AvgMPG=mean(MPG_Highway, MPG_City);
    label MSRP="Manufacturer Suggested Retail Price"
    AvgMPG="Average Miles per Gallon"
    Invoice="Invoice Price";
run;

proc means data=cars_update min mean max;
    var MSRP Invoice;
run;

proc print data=cars_update label;
    var Make Model MSRP Invoice AvgMPG;
run;

The labels for the columns should be replaced with my new labels (eg. MRSP should be "Manufacturer Suggested Retail Price"), but it's only showing the original column names. 

Here's what the output tables look like:

I looked at proc contents like she did in the lesson, but the labels weren't in there.  

I also tried using the proc print statement with temporary labels, but the labels didn't show up for that either:

proc print data=cars_update label;
    var Make Model MSRP Invoice AvgMPG;
    label MSRP="Manufacturer Suggested Retail Price"
             AvgMPG="Average Miles per Gallon"
             Invoice="Invoice Price";
run;

Any help would be greatly appreciated!  

Thanks in advance!

---

Try running this code and then check the log:

proc options option=label;
run;

If you see something like this:

 NOLABEL           Disables procedures from using labels with variables.

then someone set a system option not to display labels. Which should be fixable with

option label;

If you don't see the NOLABEL then I would re-run your data step creating cars_update and verify that it was successfully created by checking the LOG. The symptom you describe sounds more like you created the set and then modified the code to add the labels and either did not rerun the code or that there was an error and the data set was not replaced for some reason such as open in view table mode or a syntax error.

[whyknock]

Thank you!  It worked perfectly.