Hi, I encountered the following error when I tried to export a SAS dataset (897MB 481 variables) to excel spreadsheet from EG(5.1 (5.100.0.13108) Hot fix 13 (64-bit)) xport job An unexpected internal failure occurred in the FileSystem component, or one of its descendants. Type: Xceed.FileSystem.DiskFile FullName: C:\Users\tsaokf\AppData\Local\Temp\SEG1320\tmp2648.tmp I have PC/SAS runing Win 7 x64 with 16gb ram and 213 GB hard drive space. The SAS dataset is resides in local drive c:\test and SAS/EG is also resides in the same local drive.Can anyone able to tell me what this error means and anything I can do to make it work ? or  EG config need to be tweeted or switch to turn on/off ? I have no problem to export with smaller files. Thanks for all your help.       ... View more

a Hi , For some reason, I got hung on the following simple logic to fill value to a fix lenght without truncation. DATA TEST;   RETAIN B ;   RETAIN LENB 0;   LENGTH B $10.;    INPUT A $CHAR4.; LENA=LENGTH(A);   B=CATT(B,A); LENB=LENGTH(B); DIFF=10-LENB -1; IF DIFF < 0 THEN DO;     B=' ' ; LENB=0;   END; DATALINES;   aaaa bb ccc dd gggg F EE      HHH  ; What I am looking for is to fill the space B with A(including space) without truncation so the result should look like   aaaa bb ccc  dd gggg F EE      HHH Any idea ? Thanks ... View more

Is there a quick date time format that can convert datatime(today()) into mmddyyyyhhmmss without any colon or space ? Thanks ... View more

Hi , I need to calculate in the end of the month day (e.i. 30,31,28,29) . Does anybody has any idea ? Thanks ... View more

Hi, I have a following datasets: data final; input GP  mid $  value; datalines; 1   var1   4.5 1   var2    6 2   var1    8 2   var2    3 3   var1    6 3   var2    2 ; I want to creat a  vertical BAR CHART  group= GP with the Values on top of the vbar. Also, I would like to overlay a inteploiation line plot on each of the GP. I am using SAS/Unix  9.2 with SAS/Graph.Can this be done ? Anyone has any sample code I can sink my teeth on ? Thanks for all your help. ... View more

Hi We have a problem reading a huge file. The sas code only read part of the input records and stop without any error. Further examine the file where the input was stop, we find a symbol 'E S' that halted any further processing. The HEX value is '1A'.  We have tried: data _null_; infile fin lrecl=314 truncover; input @; _infile_=compress(_infile_,' ','NK'); input  ; file tst; put _infile_; run; But it does not work. Does anyone has this problem and how to resolve this issue ? Thanks for all your help ... View more