Labelling Using Another Dataset

Junyong — Mon, 08 Mar 2021 01:04:08 GMT

Datasets i and j have the labels and the data as follows.

filename i temp;

proc http url="http://faculty.tuck.dartmouth.edu/images/uploads/faculty/
rafael-laporta/Law_Fin.xls" out=i;
run;

proc import file=i dbms=xls replace out=i;
	sheet="definitions";
	getnames=no;
run;

proc import file=i dbms=xls replace out=j;
	sheet="data";
run;

The labels contain commas, percent signs, and unclosed parentheses as follows. How can I label the data correctly? The following macro incorrectly scans the macro strings due to empty spaces.

%macro i;

proc sql noprint;
	select a,d into :i separated by "\",:j separated by "\" from i;
quit;

data j;
	set j;
	%do k=4 %to %sysfunc(countw(&i,\));
		label %scan(&i,&k,\)="%scan(%nrbquote(&j),&k,\)";
	%end;
run;

%mend;

%i

Thanks for help.

Re: Labelling Using Another Dataset

ChrisNZ — Mon, 08 Mar 2021 02:51:04 GMT

1. Try using %superq(j)

2. use proc datasets add add labels, do not copy the whole table.

Re: Labelling Using Another Dataset

ChrisNZ — Mon, 08 Mar 2021 03:02:27 GMT

Also, it'd be a lot simpler to use call execute for this kind of endeavour.

topic Re: Labelling Using Another Dataset in SAS Programming

Labelling Using Another Dataset

Re: Labelling Using Another Dataset

Re: Labelling Using Another Dataset