Hello! I have a (macro) variable with a value in the form "AB";"AG";"FZ","IE" of variable length. I would like to create a new variable with all the characters from my (macro) variable and blanks in between, i.e. AB AG FZ IE I tried the SCAN function in a do loop in the DATA step but I got an error because of the ;s in the value of the (macro) variable. How can I get it done? Thx, Stefan ... View more

How can I read the filenames from a library into a dataset? Thx, Stefan ... View more

Hi! I am trying to import yet another .csv-File into SAS via the following code. I am getting really strange errors although the line is supposed to end after 1. Yet it seems as if there are lots of numbers after "1." in the error report. However if I open the .csv in the text editor, there is nothing... the first 2 lines (nr. 3 and 4) are. Who can help? Thx, Stefan ------------------------------------------------------------------------------------------------------------------------------- 440000836024;440-Giro-2911331-1;28336;262;197;440-K3-GIRO;0;(EUR) Euro;1 440000836024;440-Giro-2911331-1-2-Z;28336;0;0;440-K3-GIRO;0;(EUR) Euro;1 -------------------------------------------------------------------------------------------------------------------------------- 15         /* Import der Adressrisiken */ 16         data rwaar   (drop = positionswert) ; 17         infile 'RWAAR.csv' dsd dlm=';' firstobs=3; 18         input       fdb   :                       12. 19                      c200 :                       $65. 20                      kusa :                       $10. 21                      positionswert :              commaX18. 22                      RWA :                        commaX18. 23                      LFS :                        $20. 24                      Nominal :                    commaX18. 25                      Waehrung :                   $30. 26                      Kurs :                       commaX8.; 27         run; NOTE: The infile 'RWAAR.csv' is:       File Name=/export/lkri2sa/sas/user/ex26878/RWAAR.csv,       Owner Name=ex26878,Group Name=gg_w_unix,       Access Permission=rw-r--r--,       File Size (bytes)=114404 NOTE: Invalid data for Kurs in line 3 72-73. RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      3   CHAR  440000836024;440-Giro-2911331-1;28336;262;197;440-K3-GIRO;0;(EUR) Euro;1. 73     ZONE  3333333333333333246762333333323333333333333333333243244543332455224776330     NUMR  440000836024B440D792FD2911331D1B28336B262B197B440DB3D792FB0B855290552FB1D fdb=440000836024 c200=440-Giro-2911331-1 kusa=28336 positionswert=262 RWA=197 LFS=440-K3-GIRO Nominal=0 Waehrung=(EUR) Euro Kurs=. _ERROR_=1 _N_=1 ... View more

Hi! I am using the following macro within a proc format to generate a format. It is working perfectly. However, if I replace the format DDMMYYP10. by YYMMD9. it suddenly does not work anymore. How can I fix it? &Stichdatum is a date, f.e. 31May2012 Thx, Stefan -------------------------------------- /* Dynamische Generierung der Intervallgrenzen */ %Macro genInt();       value faellig             low - %SYSFUNC(Intnx(Month, &Stichdatum, 0, e)) = '0_abgelaufen'             %put Stichdatum=&stichdatum;             %LET dvar = &stichdatum;             %LET hvar = %SYSFUNC(Intnx(month, &dvar, 1, e));             /* Falls Monatsende nicht mit Quartalsende zusammenfällt */             %IF %sysfunc(intnx(month,&dvar,0,e)) < %sysfunc(intnx(qtr,&dvar,0,e))                   %THEN                         %DO;                              %SYSFUNC(Intnx(Month, &dvar, 1, b)) - %SYSFUNC(Intnx(Qtr, &dvar, 0, e)) = %SYSFUNC(Intnx(qtr, &dvar, 0, end), DDMMYYP10.)                         %END;             %LET dvar = %SYSFUNC(Intnx(qtr, &dvar, 1, b)); /* nächstes Quartal */             /* Quartalsscheiben erzeugen */             %DO %UNTIL (%SYSFUNC(Intnx(Qtr, &dvar, 0, e)) > %SYSFUNC(Intnx(year, &hvar, 1, e)));                   %SYSFUNC(Intnx(qtr, &dvar, 0, b)) - %SYSFUNC(Intnx(Qtr, &dvar, 0, e)) = %SYSFUNC(Intnx(qtr, &dvar, 0, end), DDMMYYP10.)                   %LET dvar = %SYSFUNC(Intnx(qtr, &dvar, 1, b)); /* nächstes Quartal */             %END;             /* Halbjahresscheiben erzeugen */             %DO %UNTIL (%SYSFUNC(Intnx(semiyear, &dvar, 0, e)) > %SYSFUNC(Intnx(year, &hvar, 2, e)));                   %SYSFUNC(Intnx(semiyear, &dvar, 0, b)) - %SYSFUNC(Intnx(semiyear, &dvar, 0, e)) = %SYSFUNC(Intnx(semiyear, &dvar, 0, end), DDMMYYP10.)                   %LET dvar = %SYSFUNC(Intnx(semiyear, &dvar, 1, b)); /* nächstes Halbjahr */             %END;             /* Jahresscheiben erzeugen */             %DO %UNTIL (%SYSFUNC(Intnx(year, &dvar, 0, e)) > %SYSFUNC(Intnx(year, &hvar, 6, e)));                   %SYSFUNC(Intnx(year, &dvar, 0, b)) - %SYSFUNC(Intnx(year, &dvar, 0, e)) = %SYSFUNC(Intnx(year, &dvar, 0, end), YEAR4.)                   %LET dvar = %SYSFUNC(Intnx(year, &dvar, 1, b)); /* nächstes Halbjahr */             %END;             /* Restscheibe erzeugen */             %SYSFUNC(Intnx(year, &dvar, 0, b)) - high = %SYSFUNC(Catx(%str( ),nach ,%SYSFUNC(Intnx(year, &dvar, -1, e), YEAR4.)))             ; %mend genInt; ... View more

Hello, I am using a data step to import data from a csv file via the following code --------------------------------------------------------------------------------------------------------- data lls_dat.p_impairment&einlesemonat;       infile 'Impairments.csv' dsd dlm=';' firstobs=3;       input Impairment :     CommaX21.2;       format Impairment CommaX21.2; run; --------------------------------------------------------------------------------------------------------- The csv-File contains multiple values in the format 12.123.123, that shoud be importet as 12.123.123,00. However they are imported as 121.231,23!? What did I do wrong? thx, Stefan ... View more

Hello friends, I am using the following code to find values that contain _ ------------------------------------------------------------ proc sql; /* Ausgabe der KontoIDs, in denen noch Suffices vorhanden sind*/ create table lls_dat.p_Ktomitsuff&stichtag as select KontoID, KontOhneSuffix from lls_wrk.P_kos&stichtag where kontohneSuffix like "^_" escape "^";   quit; ------------------------------------------------------------ I am getting the following warning. How can I make it work? Thx, Stefan ------------------------------------------------------------ WARNING: Server is unable to execute the WHERE clause. ... View more