I have been experimenting with ODS statements trying to get the results of a PROC PRINT statement into a file in a format that is easy to cut/paste into an MS-Word document. The RESULTS of the PROC PRINT look perfect for my needs but I'm getting nowhere with writing to a file. Any suggestions would be appreciated. A portion of the code (ODS statements, the PROC PRINT) are attached: ... View more

I am trying to prompt a user via a couple of windows for information. The first window prompts for the last two digits of an I/P address and a model type. I am trying to build a windows file name. Our departmental standard has a convention like:      'z:\Mainframe\MF 47_'xx     where      xx      is the two digit I/P value and there are subsequent nodes of the file name to follow. Data Work.GetIP;       if _n_ = 1 then do;             format Last2IP $2.;             format VSPPLAT $4.;             format configr1 $250.;             format tdrv1 tdrv1a tdrv2 $120.;        window GetBoxNo irow=1 rows=15 color=white             #3 @10 'Enter the last two digits of the I/P address:'                  +2 Last2IP attr=underline autoskip persist=yes             #5 @10 'Enter Platform (ie: R700, R800):'                  +2 VSPPLAT attr=underline persist=yes;        display GetBoxNo blank;      /*     so let's assume the user replies     85     to the prompt for      Last2IP     and     R800     for the prompt for      VSPPLAT                                                            */   /* here is the first problem: trying to get the variable     configr1     to equal     z:\Mainframe\MF_47.85\Configs\Report_140531_CreateConfigurationReport\CSV               */       tdrv1 = trim("z:\Mainframe\MF_");       tdrv1a = cat(tdrv1,Last2IP);       tdrv2 = trim("\Configs\Report_140531_CreateConfigurationReport\CSV");       tdrv2a = cat(tdrv1a,tdrv2a);       configr1 = tdrv2a;      /*      I have tried a number of ways of concatenating a string     ("z:\Mainframe\MF_47." )     and     Last2IP     and then the string     "\Configs\Report_140531_CreateConfigurationReport\CSV")                but run into problems with length of values or it leaves the Last2IP value out     */      /*      Next problem: I want to retain the items entered in the previous box (but not allow update here) and display a prompt for the file name of the configuration report...displayed but the user can                over-type if they aren't meeting the standard or the date of the report is different     */       window GetRpt irow=1 rows=10 color=white             #3 @10     'Enter the last two digits of the I/P address:'                +2       Last2IP persist=yes protect=yes             #5 @10      'Enter Platform (ie: R700, R800):'                +2       VSPPLAT persist=yes protect=yes             #7 @10      'Enter Filename for Configuration Report:' /                @15      configr1 ;        display GetRpt; /*      I would like the cursor to tab directly to line-8, column-15 where the variable      configr1     begins but that may not be possible.     */ /*     below is relevant to subsequent steps and macro calls     */        %LET VSPIP = Ntests;        %LET VSPVERS = VSPPLAT;        output;        stop;   end;   output;   STOP;   run; quit; proc print data=Work.GetIP; run; quit; ... View more