Hallo @FreelanceReinh, vielen Dank für die ausführliche Antwort und die vielen Erklärungen sowie Verbesserungsvorschläge! Liebe Grüße und einen schönen Abend ... View more

Das Problem ist gelöst! Es lag daran, dass die neu gebildete Variable nicht numerisch, sondern alphanumerisch war. Ich habe die Buchstaben durch Zahlen ersetzt und entsprechend die Hochkommata entfernt, wie@Criptic es vorgeschlagen hatte. Vielen Dank an alle für die umfangreiche Hilfe. Ohne Eure geduldige Hilfe wäre ich verzweifelt... Liebe Grüße und einen schönen Abend ... View more

Hallo @FreelanceReinh, danke für die Erklärung! Die Variable typ_alter ist numerisch und hat 3 Stellen. Ich werde es mit dem Tip von @andreas_lds versuchen zu erstellen. Liebe Grüße ... View more

Hallo @andreas_lds, hier das Log-Fenster: 187 libname Haase 'C:\Users\Margaretha\Desktop\FDZ\DRG\Data'; NOTE: Libref HAASE was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\Margaretha\Desktop\FDZ\DRG\Data 188 PROC format; 189 value AlterTyp 190 1 - 3 = 'a' 191 4 - 5 = 'b' 192 6 - 7 = 'c' 193 8 - 9 = 'd' 194 10 - 11 = 'e' 195 12 - 13 = 'f' 196 14 - 15 = 'g' 197 16 - 17 = 'h' 198 18 - 21 = 'i' 199 22 = 'j' 200 other = ' ' 201 ; NOTE: Format ALTERTYP is already on the library WORK.FORMATS. NOTE: Format ALTERTYP has been output. 202 RUN; NOTE: PROZEDUR FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 203 204 DATA Work.Daten_2007; 205 set Haase.Drg2007_3846_sf(keep= typ_alter pat_land icd_hd); NOTE: Datei HHASE.DRG2007_3846_SF.DATA besitzt das systemeigene Format eines anderen Host, oder die Dateicodierung entspricht nicht der Sitzungscodierung. Cross Environment Data Access wird verwendet. Dies kann weitere CPU-Ressourcen erfordern und die Performance wird beeinträchtigt. 206 length typ_alter_neu $ 1; 207 208 typ_alter_neu = put(input(typ_alter, 2.), AlterTyp.); 209 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 208:27 NOTE: There were 200 observations read from the data set REEH.DRG2007_3846_SF. NOTE: The data set WORK.DATEN_2007 has 200 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 210 211 PROC SQL; 212 CREATE TABLE Daten_2007 AS 213 SELECT sex, 214 typ_alter, 215 pat_land, 216 icd_hd, CASE 217 WHEN typ_alter >= 01 AND typ_alter <= 03 THEN 'a' 218 WHEN typ_alter >= 04 AND typ_alter <= 05 THEN 'b' 219 WHEN typ_alter >= 06 AND typ_alter <= 07 THEN 'c' 220 WHEN typ_alter >= 10 AND typ_alter <= 11 THEN 'e' 221 WHEN typ_alter >= 08 AND typ_alter <= 09 THEN 'd' 222 WHEN typ_alter >= 12 AND typ_alter <= 13 THEN 'f' 223 WHEN typ_alter >= 14 AND typ_alter <= 15 THEN 'g' 224 WHEN typ_alter >= 16 AND typ_alter <= 17 THEN 'h' 225 WHEN typ_alter >= 18 AND typ_alter <= 21 THEN 'i' 226 WHEN typ_alter = 22 THEN 'j' 227 ELSE typ_alter 228 END AS typ_alter_neu 229 230 FROM Haase.Drg2007_3846_sf; NOTE: Datei HAASE.DRG2007_3846_SF.DATA besitzt das systemeigene Format eines anderen Host, oder die Dateicodierung entspricht nicht der Sitzungscodierung. Cross Environment Data Access wird verwendet. Dies kann weitere CPU-Ressourcen erfordern und die Performance wird beeinträchtigt. ERROR: Result of WHEN clause 11 is not the same data type as the preceding results. 231 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROZEDUR SQL used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 232 PROC print; 233 RUN; NOTE: There were 200 observations read from the data set WORK.DATEN_2007. NOTE: PROZEDUR PRINT used (Total process time): real time 0.05 seconds cpu time 0.04 seconds Ist es überhaupt möglich, dass man die von Dir vorgeschlagene Syntax vor einem Proc SQL einfügen und zusammen mit diesem verwenden kann? Vielen Dank für die Hilfe! ... View more

Hallo @andreas_lds, vielen Dank für den Tip! Immerhin wird mir jetzt schon eine Spalte mit der Variablen typ_alter_neu angezeigt, in der jedoch keine Werte enthalten sind... Ich habe scbon verschiedene Möglichkeiten versucht, aber probiere es weiter. Liebe Grüße ... View more

Hallo @jh_ti_bw, vielen Dank für die schnelle Antwort. Ich habe meine Syntax entsprechend geändert: libname Haase 'C:\Users\Margaretha\Desktop\FDZ\DRG\Data'; PROC SQL; CREATE TABLE Daten_2007 AS SELECT sex, icd_hd, pat_land, typ_alter, (CASE WHEN typ_alter = '22' THEN 'j' WHEN typ_alter in ( '1', '2', '3') THEN 'a' WHEN typ_alter in ( '4', '5' ) THEN 'b' WHEN typ_alter in ( '6', '7' ) THEN 'c' WHEN typ_alter in ( '8', '9' ) THEN 'd' WHEN typ_alter in ('10', '11' ) THEN 'e' WHEN typ_alter in ('12', '13' ) THEN 'f' WHEN typ_alter in ('14', '15' ) THEN 'g' WHEN typ_alter in ('16', '17' ) THEN 'h' WHEN typ_alter in ('18', '19', '20', '21' ) THEN 'i' ELSE typ_alter END) AS typ_alter_neu FROM Haase.Drg2007_3846_sf; QUIT; PROC print; RUN; Leider erhalte ich noch keine Tabelle mit der neuen Variablen und im Log-Fenster wird mir folgende Fehlermeldung angezeigt: 37 libname Haase 'C:\Users\Margaretha\Desktop\FDZ\DRG\Data'; NOTE: Libref HAASE was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\Margaretha\Desktop\FDZ\DRG\Data 38 PROC SQL; 39 CREATE TABLE Daten_2007 AS 40 SELECT sex, 41 icd_hd, 42 pat_land, 43 typ_alter, 44 (CASE 45 WHEN typ_alter = '22' THEN 'j' 46 WHEN typ_alter in ( '1', '2', '3') THEN 'a' 47 WHEN typ_alter in ( '4', '5' ) THEN 'b' 48 WHEN typ_alter in ( '6', '7' ) THEN 'c' 49 WHEN typ_alter in ( '8', '9' ) THEN 'd' 50 WHEN typ_alter in ('10', '11' ) THEN 'e' 51 WHEN typ_alter in ('12', '13' ) THEN 'f' 52 WHEN typ_alter in ('14', '15' ) THEN 'g' 53 WHEN typ_alter in ('16', '17' ) THEN 'h' 54 WHEN typ_alter in ('18', '19', '20', '21' ) THEN 'i' 55 ELSE typ_alter 56 END) AS typ_alter_neu 57 FROM Haase.Drg2007_3846_sf; NOTE: Datei HAASE.DRG2007_3846_SF.DATA besitzt das systemeigene Format eines anderen Host, oder die Dateicodierung entspricht nicht der Sitzungscodierung. Cross Environment Data Access wird verwendet. Dies kann weitere CPU-Ressourcen erfordern und die Performance wird beeinträchtigt. ERROR: Expression using equals (=) has components that are of different data types. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Result of WHEN clause 11 is not the same data type as the preceding results. 58 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROZEDUR SQL used (Total process time): real time 0.06 seconds cpu time 0.04 seconds 59 PROC print; 60 RUN; NOTE: There were 200 observations read from the data set WORK.DATEN_2007. NOTE: PROZEDUR PRINT used (Total process time): real time 0.05 seconds cpu time 0.04 seconds Wo könnte mein Fehler liegen? Liebe Grüße ... View more

Hallo @Criptic , vielen Dank für die schnelle Antwort! Ich habe das IF jetzt durch WHEN ersetzt und mich an Deiner Beispielsyntax orientiert und folgende Syntax verwendet: libname Haase 'C:\Users\Margaretha\Desktop\FDZ\DRG\Data'; PROC SQL; CREATE TABLE Daten_2007 AS SELECT sex, icd_hd, pat_land, typ_alter, CASE WHEN typ_alter >= '1' AND typ_alter <= '3' THEN 'a' WHEN typ_alter >= '4' AND typ_alter <= '5' THEN 'b' WHEN typ_alter >= '6' AND typ_alter <= '7' THEN 'c' WHEN typ_alter >= '8' AND typ_alter <= '9' THEN 'd' WHEN typ_alter >= '10' AND typ_alter <= '11' THEN 'e' WHEN typ_alter >= '12' AND typ_alter <= '13' THEN 'f' WHEN typ_alter >= '14' AND typ_alter <= '15' THEN 'g' WHEN typ_alter >= '16' AND typ_alter <= '17' THEN 'h' WHEN typ_alter >= '18' AND typ_alter <= '21' THEN 'i' WHEN typ_alter = '22' THEN 'j' ELSE typ_alter END AS typ_alter_neu FROM Haase.Drg2007_3846_sf; QUIT; PROC print; RUN;   Leider klappt es noch nicht, im Log-Fenster steht jetzt folgendes: 35 libname Haase 'C:\Users\Margaretha\Desktop\FDZ\DRG\Data'; NOTE: Libref HAASE was successfully assigned as follows: Engine: V9 Physical Name: C:\Users\Margaretha\Desktop\FDZ\DRG\Data 36 PROC SQL; 37 CREATE TABLE Daten_2007 AS 38 SELECT sex, 39 icd_hd, 40 pat_land, 41 typ_alter, CASE 42 WHEN typ_alter >= '1' AND typ_alter <= '3' THEN 'a' 43 WHEN typ_alter >= '4' AND typ_alter <= '5' THEN 'b' 44 WHEN typ_alter >= '6' AND typ_alter <= '7' THEN 'c' 45 WHEN typ_alter >= '8' AND typ_alter <= '9' THEN 'd' 46 WHEN typ_alter >= '10' AND typ_alter <= '11' THEN 'e' 47 WHEN typ_alter >= '12' AND typ_alter <= '13' THEN 'f' 48 WHEN typ_alter >= '14' AND typ_alter <= '15' THEN 'g' 49 WHEN typ_alter >= '16' AND typ_alter <= '17' THEN 'h' 50 WHEN typ_alter >= '18' AND typ_alter <= '21' THEN 'i' 51 WHEN typ_alter = '22' THEN 'j' 52 ELSE typ_alter 53 END AS typ_alter_neu 54 FROM Haase.Drg2007_3846_sf; NOTE: Datei HAASE.DRG2007_3846_SF.DATA besitzt das systemeigene Format eines anderen Host, oder die Dateicodierung entspricht nicht der Sitzungscodierung. Cross Environment Data Access wird verwendet. Dies kann weitere CPU-Ressourcen erfordern und die Performance wird beeinträchtigt. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using IN has components that are of different data types. NOTE: The IN referred to may have been transformed from an OR to an IN at some point during PROC SQL WHERE clause optimization. ERROR: Expression using equals (=) has components that are of different data types. ERROR: Result of WHEN clause 11 is not the same data type as the preceding results. 55 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROZEDUR SQL used (Total process time): real time 0.04 seconds cpu time 0.04 seconds 56 PROC print; 57 RUN; NOTE: There were 200 observations read from the data set WORK.DATEN_2007. NOTE: PROZEDUR PRINT used (Total process time): real time 0.05 seconds cpu time 0.06 seconds Hättest Du eine Idee, woran es trotz der nun geänderten Syntax liegen kann? Liebe Grüße ... View more

Vielen Dank für die schnelle Antwort! Ich habe das Komma hinter der Variablen icd_hd weggelassen. Danach hat es direkt funktioniert und ich habe die gewünschte Tabelle erhalten.   Nochmals danke und einen schönen Abend! ... View more