topic Re: How to convert XPT files to sas datasets ? in SAS Programming

How to convert XPT files to sas datasets ?

r3570 — Wed, 17 Nov 2021 06:22:50 GMT

Dear All,

I have a folder which has some 30 odd XPT files and i want to convert them to sas datasets.

Request you to please help in converting them. I work on UNIX SAS.

Thank you.

Re: How to convert XPT files to sas datasets ?

DJongman — Wed, 17 Nov 2021 06:37:28 GMT

https://communities.sas.com/t5/SAS-Programming/Convert-XPT-to-SAS-Datasets/td-p/97872
Should give you a direction.

Re: How to convert XPT files to sas datasets ?

Ksharp — Wed, 17 Nov 2021 11:39:45 GMT

/*XPT文件的路径*/
%let path_in= D:\XiaKeShan\my_code\数据管理\转XPT文件\XPT  ;


/*XPT文件转成SAS数据集的路径*/
%let path_out=  D:\XiaKeShan\my_code\数据管理\转XPT文件\SAS  ;






libname out v9 "&path_out";
data _null_;
rc=filename('x',"&path_in.");
did=dopen('x');
do i=1 to dnum(did);
 memname=dread(did,i); 
 call execute(cat("libname tranfile xport '&path_in\",memname,"';proc copy in=tranfile out=out ; run;"));
end;
run;