Is there a way that I can read/copy/import xpt file which has encoding='UTF-8'? Thanks for your help. ... View more

I want to delete the same line from many SAS PROGRAMS. is there a easy way to do it? Sandy ... View more

I have many inlib1, inlib2 libraries. I would like to concatenate all the directory to one macro variable NAME. %put &name; looks fine, but log has the following error message. Anyone has an idea how to fix this? Thanks. %macro fmt(inlib1=, inlib2=);   %let name=%str("&inlib2","&inlib1",&name); %mend; %fmt(inlib1=%str(c:\temp1\p_v1), inlib2=%str(c:\temp1\p_v2)); Error Msg: Some characters in the above value which were subject to macro quoting have been unquoted for printing. Sandy ... View more

I would like to use estimate value to create a macro variable aa when the wk in data2 matches the wk2 in data1. The where condition in PROC SQL does not work properly. Any way to solve this? Thanks. data data1;   input wk2 estimate; datalines;   1 12   2 14   3 15   ; run; %macro trash(var1=, var2=);        %global &var2;      proc sql;         select distinct estimate into: &var2         from summ         where wk2=&var1;      quit; %mend trash; data data2;   wk=2;   %trash(var1=wk,var2=aa);   %put &aa; run; proc print data=ori;run; ... View more