About stc200896

stc200896 · ‎01-05-2020

I run a report each week via SAS ods tagsets, which produces an output file that I then manually paste into an existing report. I'm currently using SAS 9.3 via a remote session so DDE is not an option unfortunately. I haven't used EG much and was recently upgraded to 7.1, which is running on 9.4 desktop server. I've read many abstracts and tons of other research via the Google and just haven't had any luck around finding a solution. Is there a way to import the exact styles/formatting used in the excel report that I can then modify an existing style template or create a new one? This is only one example of about 10 reports I run each week that *I think* would need a separate template. If there's not a way to import the specifics into SAS, is there an easy way to create it in EG? Thanks in advance for any help as it's greatly appreciated. I've been writing daily code via SAS for 10+ years but when it comes to proc templates/reports, etc., I get a little lost in the details. -SLB

stc200896 · ‎08-13-2018

No, I didn't realize until after I posted that excel wasn't opening. I get an error saying excel.exe not found. I've reached out to my IT team but haven't heard back yet. I've verified it's in that location. NOTE: Remote submit to MIRAGE commencing. REMOTE(MIRAGE): /bin/ksh: C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE: not found 2412 x '"C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE"'; ; 2413 2414 data _null_; 2415 x=sleep(30); 2416 run; NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 2417 2418 data _null_; 2419 file sas2x1; 2420 put '[Open("C:\My Documents\TEMPLATE.xlsb")]'; 2421 run; NOTE: 1 record was written to the file SAS2X1. The minimum record length was 68. The maximum record length was 68. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 2422 2423 filename sas2x1 dde 'excel|WHSE_10!r7c1:r150c57' lrecl=1024; ERROR: Invalid device type. ERROR: Error in the FILENAME statement. 2424 2425 data _null_; 2426 set Staci.whse_10; 2427 file sas2x1; 2428 put var1 '09'x var2 '09'x var3 '09'x var4 '09'x var5 2429 run; NOTE: 15042 records were written to the file SAS2X1. The minimum record length was 1. The maximum record length was 256. NOTE: There were 8420 observations read from the data set STACI.WHSE_10. NOTE: DATA statement used (Total process time): real time 0.13 seconds cpu time 0.13 seconds 2430 2431 2432 2433 data _null_; 2434 file sas2x1; 2435 put '[error(false)]'; 2436 cmnd = '[save.as("C:\My Documents\Testing_DDE.xlsb")]'; 2437 put cmnd; 2438 put '[file.close(true)]'; 2439 put '[quit()]'; 2440 run; NOTE: 4 records were written to the file SAS2X1. The minimum record length was 8. The maximum record length was 54. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Remote submit to MIRAGE complete.

stc200896 · ‎08-13-2018

Hi All, I'm trying desperately to determine what is invalid in this code. I have an excel template .xlsb already created and I'm trying to export my output into it. I keep getting "invalid device type, error in the FILENAME statement" and it appears to be the only thing that's keeping the rest of the code from running. I'm using SAS9.3, 64bit version. Excel is the 32bit version. Could someone help point me in the right direction? options mprint; x '"C:\Program Files (x86)\Microsoft Office\Office14\excel.exe"'; data _null_; x=sleep(30); run; data _null_; file sas2x1; put '[Open("C:\My Documents\TEMPLATE.xlsb")]'; run; filename sas2x1 dde 'excel|WHSE_10!r7c1:r150c57' lrecl=1024; data _null_; set Staci.whse_10; file sas2x1; put var1 '09'x var2 '09'x var3 '09'x var4 '09'x var5; run; data _null_; file sas2x1; put '[error(false)]'; cmnd = '[save.as("C:\My Documents\Testing_DDE.xlsb"".xlsb")]'; put cmnd; put '[file.close(true)]'; put '[quit()]'; run; On another note, when I try running the x command below, I get errors saying the first two are unrecognized SAS option names: options noxwait noxsync mprint; x '"C:\Program Files (x86)\Microsoft Office\Office14\excel.exe"'; Thanks, Staci B

stc200896 · ‎11-13-2017

I can't tell you how many times I tried that and it still wouldn't go away! But of course, I try it now and it's gone! Thanks so much. I feel so silly but you have just made my day. Thanks again!

stc200896 · ‎11-13-2017

This is a very basic "how to customize SAS session" that has me going crazy! I recently made some changes to my current SAS session using the Tools menu only. I unchecked/checked a couple of boxes within the Tools menu under preferences and customize, changed two keys and the color scheme. However, since doing so, there is a blank line at the top of my enhanced editor window. It appears to be a message line because because if I run code, it displays how many lines were submitted. Another message line is also visible above the "Contents of SAS Environment" Explorer window that displays the nbr of "members" in the contents of a selected folder. I have not made any other modifications outside of using the Tools menu and CANNOT figure out how to get rid of these message displays. I know it has to be something very simple and obvious but I just can't find it. Could someone please help? Many thanks in advance!!! 🙂

stc200896 · ‎06-05-2017

I tried both solutions and they both worked! Thank you so much!

stc200896 · ‎06-05-2017

I have two massive datasets that I need to merge. All of the fields are the same with the exception of the time field. I want to merge the two datasets where T1.time is within 30 minutes of T2.time. I have tried everything I can think of but that's probably not saying too much ;-). Here's a sample of data below... DATA T1; INPUT STORE KEY2 DATE TIME VAR3 DATALINES; 3 163003 03SEP2016 18:47 1; RUN; DATA T2; INPUT STORE KEY2 DATE TIME VAR1 VAR2; DATALINES; 3 163003 03SEP2016 18:33 1 1; RUN; DATA T3; MERGE T2 (IN=A) T1; BY STORE KEY2 DATE; IF A; IF.........; RUN; The final table should be a left join to T2 to pull in var3 from T1 if T1.time is within 30 minutes of T2.time. I sincererly appreciate any help anyone could provide. Thanks.

Online Status	Offline
Date Last Visited	‎01-05-2020 05:15 PM

Create proc template from existing format in Excel file

Re: SAS DDE Error

SAS DDE Error

Re: New message line above enhanced editor and Explorer

New message line above enhanced editor and Explorer

Re: how do I merge 2 datasets on 2 different timestamps

how do I merge 2 datasets on 2 different timestamps