I don't see the csv file in the attachment, can that be added? ... View more

I got it !!!   I was focused on the Server/SASApp/files folder.  I can get to anything on the Windows server or any drives connected to the Windows Server, but I can only see the Linux file structure under my /home directory.  Is there a way to show other directory paths on the Linux Server; which; is the compute tier? ... View more

I'm thinking you are very close. proc sql;   select nobs/250000 into :amax               from DICTIONARY.TABLES    where (memtype='DATA')     and memname='CARS'     and libname='SASHELP'; quit; OR dsid=%sysfunc(open(SASHELP.CARS)); num=%sysfunc(attrn(&dsid,nlobs)); rc=%sysfunc(close(&dsid)); Then just iterate thru with a do loop %put &amax   # %macro do_loop;   %do i = 1 %to &amax+1;     data tmp;       set work.mybigdsn;       if 1=%eval(&1) and _n_ le 250K;       else (&I-1)*250K le _n_ le (&i*250k);     run;     proc export data=tmp outfile="C:\output\mytextfile&i..txt"     run;          proc datasets        delete tmp;     quit;    %end; %mend do_loop; do_loop;           ... View more

Ashley,  it would be helpful to know how you are reading in the text file.  Can you do a simple length statement on both 1A and 1B then compare the lengths? data short(keep=1A)         long(keep=1B);    set beginning;    a=length(1A);    b=length(1B);   if (a < b) or (a<200) then output short;   if (b > a) or (b>200) then output long; run; ... View more

Close - the code is two macros, one to count the words in any macro variable separated by commas and a space.  The result is just the number of words in the list, in the example it should be two.  Your SAS log will show this. The second macro is %read_txtFiles.  It will do just that.  It will run twice for de and ri, or to the count of &wrd_cnt.  parse the _states macro and read in each state file.  The proc import can be changed to any metod to import the txt file. All you really need to change is the %let _states list with the list of states to read, originally 47.  change the %let _dsn to simple state names, can be the same as _states. I have the options statement to show how the macro is resolving %macro _wordcntC(list); %global wrd_cnt; %let wrd_cnt=%sysfunc(countw(%nrquote(&list),%str(,))); %put "# of words in list are  &wrd_cnt"; %mend _wordcntC; ******  keep what is above  ****************; ******  my example of the state list  *****************; %let _states="Illinois, NewYork, New Mexico, California"; ******  single sas dataset output from macro  *********; %let _dsnlst=Illinois, New York, New Mexico, California; *****  call the macro _wordcntC to get the number of states in the %let _states list *****; *****  for your example this should be 2, make sure you have spaces between the states like below ***; %let _states="ri, de"; %let _dsnlst=ri, de; %_wordcntC(&_states); options mprint mlogic symbolgen; %macro read_txtFiles(states); %local state; ***                                                           ***; ***  read each state in from the _states list macro variable  ***; ***  assign it to a new macro variable word                   ***; ***  the proc import will import the file from the desktop    ***; ***  the result sas dsn will be appended to _allstates        ***; %do j = 1 %to &wrd_cnt;   %let word=%qscan(%nrquote(&states),&j,%str(,));   %let _dsn=%qscan(%nrquote(&_dsnlst),&j,%str(,));   PROC IMPORT OUT=&_dsn    DATAFILE="C:\Documents and Settings\xyz\Desktop\&word..txt";    SCANTEXT=YES;    USEDATE=YES;    SCANTIME=YES;   RUN; proc append base=_allstates  data=&syslast force; run; proc datasets lib=WORK;     delete &dsn; quit;     filename _all_ clear;     run;     %end; %mend read_txtFiles; %read_txtFiles(&_states); ... View more

Sandy,  you look fantastic !!!   I'm think about a simple process where you can list all the states in a macro variable then parse the macro variable with another macro called %word_cnt.    Word count just counts the number of words in a macro variable is list format.  I have 2 %let statements one for the state names/file names and one for the result dataset(not necessary since you will use only the master set, _allstates).  The read_txtFiles will read all the txt files listed, I used proc import for the read and force on the append incase of attribute mismatches.  I have a process similar reading in multiple spreadsheets from a workbook and multiple files where I do a "%sysexec dir /O:D "&_dir1\*.log" > "&_dir3\wc_file.txt" ;" to read in the directory where the files are located. %macro _wordcntC(list); %global wrd_cnt; %let wrd_cnt=%sysfunc(countw(%nrquote(&list),%str(,))); %put "# of words in list are  &wrd_cnt"; %mend _wordcntC; ******  keep what is above  ****************; %let _states="Illinois, NewYork, New Mexico, California"; %let _dsnlst=Illinois, New York, New Mexico, California; %_wordcntC(&_states); %macro read_txtFiles(states); %local state; %do j = 1 %to &wrd_cnt;   %let word=%qscan(%nrquote(&states),&j,%str(,));   %let _dsn=%qscan(%nrquote(&_dsnlst),&j,%str(,));   PROC IMPORT OUT=&dsn    DATAFILE=&_dsn..txt;    SCANTEXT=YES;    USEDATE=YES;    SCANTIME=YES;   RUN; proc append base=_allstates  data=&syslast force; run; proc datasets lib=WORK;     delete &dsn; quit;     filename _all_ clear;     run;     %end; %mend read_txtFiles; %read_txtFiles(&_states); ... View more

The practice exams help A L O T. Good Luck !!! ... View more

David, Thanks, I did the same.  I keep ending on the Oracle Home page.  2 weeks and 10 calls with Oracle, I still can't get into their site.  "My kingdom for a 64bit Oracle ODBC drivers."  It's a small kingdom with lots of unsettled villagers, but it's Home. Bob W. ... View more

David, I the reverse problem, my 64bit SAS can't take to my 32bit Oracle.  My ODBC driver is SQORA32.DLL, I believe this is 32bit.  I really want the 64bit Oracle.  Where did you find the Oracle 64bit? ... View more