topic Re: external data with special symbols “&” in SAS Programming

111

HannaZhang — Tue, 16 Mar 2021 07:07:11 GMT

1111

Re: external data with special symbols “&”

Ivan555 — Tue, 25 Jun 2019 07:56:58 GMT

Hello! If you write this way seems code will work.

%let path ="source.Programming_DEV\Data\Rawdata\AE&CM_编码报告.xlsx";  
proc import out=AE_code
   datafile=&path.
   dbms=excel replace;
   range="AE coding$A5:AQ35";
   getnames=yes;
run;

If not, u can modify your filename is SAS using TRANWRD function.

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=p0pgemqcslm9uen1tvr5gcrusgrw.htm&docsetVersion=9.4&locale=en

Re: external data with special symbols “&”

Kurt_Bremser — Tue, 25 Jun 2019 08:01:09 GMT

If you want to prevent the resolution of macto triggers, use single quotes:

datafile='&source.Programming_DEV\Data\Rawdata\AE_CM_编码报告.xlsx'