Hi, Could you try this program?   filename in PIPE 'type c:\temp\prodrun.log'; data check;   infile in missover pad;   input line $1000.; run; ... View more

Thanks, Tom. Good thing I never relied on that for code to work. Wow. Best wishes, Ben ... View more

Check the US Census bureau or Post Office, but I'm fairly certain that's where the maps data originally come from anyways. https://support.sas.com/rnd/datavisualization/mapsonline/html/home.html ... View more

Another avenue that hasn't been mentioned yet is using the SPDE engine/format.  We had a set of very large files and processing streams that took several days to run.  Converting the masters to SPDE datasets resulted in substantial disk savings.  Often 90%.   While not all applications will benefit (random I/O being one), that is certainly something to consider.  SPDE also uses available memory and CPU which is both good and bad.  On the largest monthly job I was politely asked if I would run that on the weekend.  Oops.   --Ben ... View more

It's just a text file, it should be easy to read into SAS. ... View more

I did run this by SAS Tech Support. While they didn't say 'no, you can't do that', their response is 'we never do that'. LOL... That suggests to me it works now, but we won't guarantee it will work in the future. Close enough to 'no' for rme. --Ben ... View more

Yeah, Unix variants have much nicer toys than Windows.  This is on a Windows server, unfortunately.    --Ben ... View more

Hi Cynthia,   Sorry for the delay; apparently the root cause of the issue I was having is that Excel has a 31 character length limit on tab names, and SAS reserves a few of those, shrinking it down to somewhere around 28.  The data I had in the BY statement creating these things was at times exceeding this.  The warning system advising of this condition is apparently stealth mode. 🙂   Vince gave his ODS Excel Part 2 talk to the ValSUG group recently where I brought up this problem and it got resolved in a much cleaner way, with a pretty ToC page and much shorter tab names.   Thanks!   --Ben ... View more