Hello, My company uses SAS EG on a grid but to get the results  to Excel we need to copy down to a linux site and use a transfer program to get it into excel. Nice for larger reports but for smaller, it's a pain. I use copy/paste but the result in Excel is 9.9E+27 instead of 000000000000990000000012345678900837   In my other company I was able to take a result from EG, and export to Excel directly. Prior to that I had just the SAS PC interface and all was fine. Not in this case. I asked and this company does not have SAS PC (or at least distribute anything other than EG).   Any suggestions are appreciated.   Thanks!!   Paula ... View more

Hello, Although I've been using SAS ince 1983 (HELLLOOOOO JCL & TSO), all my SAS PC work has been on the base, one file per program version. I have a new job where the manager insists on having a process for Libnames Macro variables Extractions (data retrieval) Transformations Loads or Reports I understand his approach but what I don't understand is how EG does this. What I mean is do I save each program separately (ie I'll have 4 programs for transformations) or do I save it all under the EG project, or both?   In a past employer, we tried to use EG and the projects would corrupt, losing our work.   Any guidance is appreciated   Thank  you   Paula Sims   ... View more

Hello, I successfully ran a PROC REPORT but can't find my file. Here's the code & relavant log.   Where do I find the file? I want it as N:\SAS Results\New.txt. When I refresh the Windows Explorer, it's no there   Thanks   proc export data = work.customer_file      outfile = 'N:\SAS Results\New.txt'      dbms = dlm;      delimiter = '09'x;     run;     --- clode snipped 41 data _null_; 42 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ 43 %let _EFIREC_ = 0; /* clear export record count macro variable */ 44 file ''N:\SAS Results\New.txt' delimiter='09'x DSD 44 ! DROPOVER lrecl=32767; 45 if _n_ = 1 then /* write column names or labels */ 46 do; 47 put 48 "SALES_MKT_NAME" 49 '09'x 50 "SALES_REGION_NAME" 51 '09'x --- code snipped NOTE: The file 'N:\SAS Results\New.txt' is: Filename=/sasdata/work/sasuser/BACON/'N:\SAS Results\New.txtt, Owner Name=bacon,Group Name=bacon, Access Permission=-rw-r--r--, Last Modified=15Jun2022:22:20:27 NOTE: 3211240 records were written to the file 'N:\SAS Results\New.txt'. The minimum record length was 130. The maximum record length was 271. NOTE: There were 3211239 observations read from the data set WORK.CUSTOMER_FILE. NOTE: DATA statement used (Total process time): real time 4.79 seconds cpu time 4.80 seconds 3211239 records created in N:\SAS Results\New.txt from WORK.CUSTOMER_FILE. ... View more

I have 30+ years of SAS programming experience (hello TSO/MVS!!) but am a total neophyte when it comes to SAS  Studio (but I like it). in the SAS PC version, when listing the data-sets, you can right click on a data-set and there is an option to immediately export to Excel. Is there such an option in Studio? If so, would someone please kindly point me to where it can be found?   I don't need to write code, I just want a quick export.   Thanks ... View more