Label Statement not working

petergomillion — Sun, 06 Oct 2019 16:55:41 GMT

Hello,

I am using the Proc statement below to import an excel sheet into SAS. Then I used the data set to change the labels. I can see the labels are changed in proc contents but the labels will not show in the output or with the print proc. Is there something I am missing or could I have done the label statement in the proc import statement. Thank you!

Proc import 
	datafile= "/folders/myfolders/color.xlsx"
	out= work.color
	dbms= XLSX replace;
Run;
Data work.color; 
set work.color;
Label Region = "Geographic Region"
		Eyes = "Eye Color"
		Hair = "Hair Color";
Proc print data= work.color;
Label;
Run;
Proc contents data =work.color;

proc options option=label;
run;
option label;

Re: Label Statement not working

Shmuel — Sun, 06 Oct 2019 17:35:03 GMT

The right syntax is:

Proc print data= work.color Label;
Run;

Re: Label Statement not working

petergomillion — Sun, 06 Oct 2019 17:37:16 GMT

Thank you kindly

topic Label Statement not working in SAS Studio

Label Statement not working

Re: Label Statement not working

Re: Label Statement not working