cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sniff_1
‎09-01-2015
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

minus sign follows number

by Calcite | Level 5 in SAS Procedures
‎02-19-2013 01:59 AM
‎02-19-2013 01:59 AM
Hi I’m getting number data, where the minus sign is at the and instead of in front. is there a possibility to change the format with Proc Formt ? I’m not so familiar with this function. Thanks for help. ist     ANLN1                  BUKRS       ANLKL           KANSW01       MENGE 000002500001      0001           00001258      8300.00-            1.000 000002500002      9600           00001258      20213.40-          1.000 000002500003      0300           00001258      28992.05           4.000 000002500004      0340           00001258      67450.00-          1.000 000002500008      0001           00001258      4001774.94      68.000 000002500011      2000           00001258      11306.65-           1.000 000002500013      0400           00001258      350451.05-      18.000 000002500018      2250           00001258       0.000 000002500019      0001           00001258       0.000 Soll ANLN1                  BUKRS       ANLKL           KANSW01       MENGE 000002500001      0001           00001258      -8300.00            1.000 000002500002      9600           00001258      -20213.40          1.000 000002500003      0300           00001258      28992.05           4.000 000002500004      0340           00001258      -67450.00         1.000 000002500008      0001           00001258      4001774.94      68.000 000002500011      2000           00001258      -11306.65         1.000 000002500013      0400           00001258      -350451.05      18.000 000002500018      2250           00001258       0.000 000002500019      0001           00001258       0.000     My Approach: Data BASIS (drop=KANSW01_D)); retain ANLN1 BUKRS KANSW01 MENGE; set BASIS (rename=(KANSW01=KANSW01_D)); length   KANSW01 8.; if index(KANSW01_D,'-') > 0 then   do;    KANSW01=input(cats('-',substr(KANSW01_D,1,index(KANSW01_D,'-')-1)),12.2);   end; run; ... View more

Re: Proc Export to Excel: how to retain SAS formatting

by Calcite | Level 5 in SAS Programming
‎11-09-2012 02:09 AM
‎11-09-2012 02:09 AM
Run a Excel macro modul to do your formats? options noxsync noxwait ;         filename sas2xl dde 'excel|system';         data _null_;         length fid rc start stop time 8;          fid=fopen('sas2xl','s');          if (fid le 0) then do;           rc=system('start excel');           start=datetime();           stop=start+10;           do while (fid le 0);            fid=fopen('sas2xl','s');            time=datetime();            if (time ge stop) then fid=1;           end;          end;         rc=fclose(fid);         run;         data _null_;             file sas2xl;             put '[error(false)]';             PUT "[open("'"'"&OutputFile&FakBez..xlsm"'"'")]";             put '[workbook.activate("Total")]';             put '[Run("Start_Mod",False)]'; '             put '[error(false)]';             put '[Save()]';             put '[Close()]';         run;         filename sas2xl clear; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links