Hello, I am just starting in Sas and i hope my question is not too dumm, but i would like to ask for some help, I am using Sas university edition. I have been thinking a lot but i do not find a my mistake. My final objective is to import several pipe delimited text files that are in a folder to sas. I found this topic: https://documentation.sas.com/?docsetId=mcrolref&docsetTarget=n0ctmldxf23ixtn1kqsoh5bsgmg8.htm&docsetVersion=9.4&locale=en I ran the code, however i did not get to import my files below the error and code Following note: 107 %drive(C:\SASUniversityEdition\myfolders\sasuser.v94\relationaltables201603,txt) NOTE: In a call to the DOPEN routine, the fileref /folders/myfolders/sasuser.v94/relationaltables201603/ exceeds 8 characters, and will be truncated. C:\SASUniversityEdition\myfolders\sasuser.v94\relationaltables201603 cannot be open. 108 109 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 121 %macro drive(dir,ext);
%local cnt filrf rc did memcnt name;
%let cnt=0;
%let filrf=/folders/myfolders/sasuser.v94/relationaltables201603/;
%let rc=%sysfunc(filename(filrf,&dir));
%let did=%sysfunc(dopen(&filrf));
%if &did ne 0 %then %do;
%let memcnt=%sysfunc(dnum(&did));
%do i=1 %to &memcnt;
%let name=%qscan(%qsysfunc(dread(&did,&i)),-1,.);
%if %qupcase(%qsysfunc(dread(&did,&i))) ne %qupcase(&name) %then %do;
%if %superq(ext) = %superq(&name) %then %do;
%let cnt=%eval(&cnt+1);
%put %qsysfunc(dread(&did,&i));
PROC IMPORT DATAFILE="&dir\%qsysfunc(dread(&did,&i))" out=dsn&cnt
DBMS=DLM
OUT=WORK.&OUTFILENAME;
DELIMITER="|";
GETNAMES=YES;
run;
%end;
%end;
%end;
%end;
%else %put &dir cannot be open.;
%let rc=%sysfunc(dclose(&did));
%mend drive;
%drive(C:\SASUniversityEdition\myfolders\sasuser.v94\relationaltables201603,txt) Therefore i found this topic: https://communities.sas.com/t5/SAS-Procedures/Problem-importing-my-CSV-into-SAS-University-Edition/td-p/139536 and I ran the test and found my files, therefore I am not sure why isnt sas finding my files. data _null_;
infile "/folders/myfolders/sasuser.v94/relationaltables201603/arm_groups.txt" obs=100;
input;
put _infile_;
run; Does anybody, have a clue of what can i try? Thaaanks!
... View more