topic Re: How to use pipe dir to read contains chinese-character path in UNICODE SAS Environment in SAS Programming

How to use pipe dir to read contains chinese-character path in UNICODE SAS Environment

Ethan_Kael — Fri, 12 Apr 2024 06:05:39 GMT

I want to use pipe dir to get the filename path and import the datasets ；but if file path contains chinese-character ，will happend the stderror outout in log and i can't get the files path in unicode SAS，but it‘s ok in chinese SAS Environment,so how to modify the code？（Sure, I could use 2>&1, but we still can't get the correct file path）. this is my code: %let path=C:\Users\Administrator\Desktop\中文; FILENAME DIRLIST PIPE "DIR ""&PATH"" /B encoding='UTF8' 2>&1" ; DATA dirlist1; INFILE dirlist LENGTH=RECLEN ; INPUT FILENAME $varying1024. RECLEN; path="&path"; filename1=FILENAME; filename=CATS(path, '\', filename1); RUN;

Re: How to use pipe dir to read contains chinese-character path in UNICODE SAS Environment

yabwon — Fri, 12 Apr 2024 10:22:45 GMT

Use the BasePlus package and the %dirsAndFiles() macro

e.g.

%dirsAndFiles(C:\SAS_WORK\,ODS=work.result)

It works with UTF characters (I've tested it)

Bart

P.S. Here are some instructions how to get BasePlus package and where the documentation is.

/*
Details about SAS Packages Framework:
- https://github.com/yabwon/SAS_PACKAGES

Tutorial:
- https://github.com/yabwon/HoW-SASPackages

BasePlus documentation:
- https://github.com/SASPAC/macroarray/blob/main/baseplus.md
*/

/* Step 1. */
/* Install SAS Packages Framework and BasePlus package. */
/* Run this only once. */
filename SPFinit url "https://bit.ly/SPFinit";
%include SPFinit; 
filename SPFinit clear;

/* create directory for the framework and packages */
filename packages "</your/directory/for/packages/>";
/* install the framework and the BasePlus package */ 
%installPackage(SPFinit BasePlus)


/* Step 2. */
/* From now on if you want to use a package: */
/* Run this at the beginning of your new SAS Session (or add it to autoexec). */
/* Enable framework and load package  */
filename packages "</your/directory/for/packages/>";
%include packages(SPFinit.sas); 
%loadPackage(BasePlus)

Re: How to use pipe dir to read contains chinese-character path in UNICODE SAS Environment

Ethan_Kael — Wed, 17 Apr 2024 08:14:36 GMT

Sorry, in this link i can't get the macro of %dirsAndFiles ,so i don't know how to read contains chinese-path files to use pipe dir

Re: How to use pipe dir to read contains chinese-character path in UNICODE SAS Environment

yabwon — Wed, 17 Apr 2024 08:52:05 GMT

The link it to the macro documentation. Check the "P.S." to see how to get the BasePlus package which contains the %dirsAndFiles() macro.

Bart