BookmarkSubscribeRSS Feed
HannaZhang
Obsidian | Level 7
1111
2 REPLIES 2
Ivan555
Quartz | Level 8

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...

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 807 views
  • 1 like
  • 3 in conversation