%let per = %sysfunc(lowcase(&period)); %put &per; feb2017 With this I can now read/email sas datasets. filename_@per.sas7bdat files in UNIX/LINUX !!! Yey!!! ... View more

Hello Jeff, I am trying to connect to Vertica thru SAS, but getting below error, do you know what can be the reason for this?   ERROR: Could not load /XXXXX/sas94/SASFoundation/9.4/sasexe/sasvrt (100 images loaded) ERROR: libverticaodbc.so: cannot open shared object file: No such file or directory 24         libname VZPRD vertica user="XXXXXXX" password=XXXXXXXXXXXXXXXX server="XXXXXXXXX" database="XXXXXX" 24       !  port=5XXX; ERROR: The SAS/ACCESS Interface to VERTICA cannot be loaded. The SASVRT   code appendage could not be loaded. ERROR: Error in the LIBNAME statement. ... View more

Well, technically you are not reading an Excel file; you are reading a comma-separated values (CSV) file that you might have created from Excel.  If you did a "Save as" from Excel, this is just a plain old text file that is a copy of the rows and columns that were in your spreadsheet.  Just remember that it is just a copy; if you change the data in the spreadsheet it will not be changed in the CSV file. Of course, it can be confusing because Excel will open the CSV file and display it as a worksheet.  That's just Excel trying ot be helpful.  If all you have is a file with this "csv" file type, it's just a plain text file.  It would only be a real Excel workbook if you did a "Save as" and chose to save it as an Excel workbook.  As before, this would just make a separate copy into a completely different file (with a file type of "xls" or "xlsx" depending on the version of Excel you saved it as.. And SAS doesn't really have a preference.  If you have SAS Access to PC File Formats licensed and installed on your PC, SAS can read the Excel spreadsheet directly. The particular problem you ran into is very common.  The "default" record length for external files is only 256 characters.  I wish SAS would change it generally to avoid this problem but I suppose they have some reason not to do so.  The other thing you could do is add this statement to your "autoexec.sas" file: options lrecl=32000; That will change the option for all your SAS sessions, in case you forget to add it to your INFILE statement.  I do that myself. ... View more

Just curious if there is any update on this problem.  I can see that the code was changed to use an https reference on that SASWare Ballot link, but the problem did not go away; I still get that "Security Warning" dialog box.  I'm not a javascript expert and was just guessing. Again, I don't know if this is a widespread problem or if it is just something with my own browser (IE 8).  I can tell you that I do NOT have this problem when I visit the site using Firefox 11.0.  So, I guess I'll just use Firefox. Thanks, ... View more

I don't think so.  Try this: proc sql;    connect odbc (dsn);    create table claims as    select * from connection to odbc (       select mbr_id            , prov_mpin            , prov_id            , max(prov_row_eff_dt) as prov_eff_dt       from   co.table       where  mbr_id > 0       group by 1,2,3       )    order by mbr_id;    disconnect from odbc; quit; I reformatted your query to make it easier to read. I removed the DISTINCT keyword because I don't think it is needed, and I used column references (1,2,3) in the GROUP BY clause, which I'm pretty sure will work.  I also deleted a stray semi-colon from your example code (in front of your ORDER BY clause). ... View more

Thanks for mentioning the "link-to-nowhere."  A bad version of this page had slipped out to the production site.  We've since corrected this problem, and the content at http://support.sas.com/resources/thirdpartysupport/index.html again lists the correct releases. ... View more

I suggest you create a new post with a link back to this one. The reason being this post is already marked as answered so many participants won't bother to check it. ... View more

Thanks _null_, I had forgotten about that option. /* create some dummy files */ data _null_; do i=1 to 3;   call execute('filename file' || strip(i) || ' "/home/friedegg/file' || strip(i) || '.txt";');   call execute('data _null_;');   call execute(' file file' || strip(i) || ';');   call execute(' put "a b c d e";');   call execute(' put "f g h i j";');   call execute('run;'); end; run; filename indata '/home/mkastin/file*.txt'; data want; length _file _filex $512; infile indata eov=_firstrec_; input (blah1-blah5) (:$1.); if _n_ or _firstrec_ then delete; /* _firstrec_ will =1 for all files first record except the first */ run; /* remove this junk */ data _null_; do i=1 to 3;   call execute('x "rm -f /home/friedegg/file' || strip(i) || '.txt";'); end; run; ... View more