topic Re: how import all xpt files from pc files in SAS Programming

how import all xpt files from pc files

thanikondharish — Fri, 27 Jul 2018 04:57:47 GMT

Re: how import all xpt files from pc files

andreas_lds — Fri, 27 Jul 2018 05:22:35 GMT

Importing multiple files of the same type has been discussed so many times, you should be able to find solutions - maybe not for xpt-files, but that should be easy to adept.

XPT-files are created by proc cport, right? You will have to import them by using proc cimport.

Re: how import all xpt files from pc files

thanikondharish — Fri, 27 Jul 2018 05:32:42 GMT

s i know by using proc cport i get only one xpt file but how to get all xpt
files at a time

Re: how import all xpt files from pc files

andreas_lds — Fri, 27 Jul 2018 05:47:04 GMT

Same problem as in the other post i replied to: your problem-description is vague and it is hardly possible to understand what you have and what you want.

The subject of your message is "how import all xpt files from pc files" - that implies that you already have xpt-files and want to import them. For that task you use proc cimport.

Now you are talking about exporting files:

@thanikondharish wrote:
s i know by using proc cport i get only one xpt file but how to get all xpt
files at a time

So, please explain what you have and what you want as result.

Re: how import all xpt files from pc files

Kurt_Bremser — Fri, 27 Jul 2018 06:58:58 GMT

Post proper questions in proper language. Don't force us to guess what you're really after. If you don't want to invest the time to post a proper question, then why are you here at all?

Re: how import all xpt files from pc files

thanikondharish — Fri, 27 Jul 2018 07:00:42 GMT

sorry i can't get idea how to ask this question .This task will do myself
thanq

Re: how import all xpt files from pc files

SASKiwi — Fri, 27 Jul 2018 07:19:44 GMT

I think it would help if you posted some example code of what you have tried - we do understand that trying to explain technical problems in English can be hard when it is not your first language.

Re: how import all xpt files from pc files

thanikondharish — Fri, 27 Jul 2018 07:21:42 GMT

%macro xportallfiles;
options mprint symbolgen nofmterr ;
%let filrf=mydir;
%let rc=%sysfunc(filename(filrf,"E:\sas\TABLES PRACTICE\"));
%let did=%sysfunc(dopen(&filrf));
%let fname=;
%let memcount=%sysfunc(dnum(&did));
%if &memcount > 0 %then
%do i=1 %to &memcount;
%let fname=%sysfunc(dread(&did,&i));
%let iw=%index(&fname,.); /* find start of extension */
%let exts=%substr(&fname,&iw); /* find file extension */
libname xx xport "E:\sas\TABLES PRACTICE\&fname.";
proc copy in=xx out=work ;
run;
%end;
%let rc=%sysfunc(dclose(&did));
%mend xportallfiles;

%xportallfiles;
if i use this code i will get xpt files from where we will give location

Re: how import all xpt files from pc files

SASKiwi — Fri, 27 Jul 2018 08:01:24 GMT

So what is the problem with this program? Posting the program's SAS log may help.