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: 
Hansi_12345
‎07-27-2021
  • 10 Posts
  • 7 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: If Condition with and... or ... or... or... is incorrect

by Fluorite | Level 6 in New SAS User
‎07-27-2021 06:10 AM
‎07-27-2021 06:10 AM
I have a similar problem like yesterday but now with ...and... and.  I realy dot now why i am always struggling with this, in vba i have not such problems.... My Code is like below:   data work.xyz; if (a = 4 and b = 11108 and c = 6) Then d = 111; else if (a = 3 and b = 11219 and c = 6) Then d = 112; else if (a= 4 and b = 11223 and c = 6) Then d = 113; else if (a = 3 and b = 11223 and c = 6) Then d = 114; else if (a = 3 and b = 11203 and c = 6) Then d = 115; else if (a = 4 and b = 11205 and c = 6) Then d = 116; else if (a = 3 and b = 11206 and c = 6) Then d = 117; else if (a = 4 and b = 11200 and c = 6) Then d = 118; else if (a = 4 and b = 11319 and c = 7) Then d = 119; else if (a = 4 and b = 11319 and c = 8) Then d = 120; else if (a = 3 and b = 11319 and c = 7) Then d = 121; else if (a = 3 and b = 11319 and c = 8) Then d = 122; else if (a = 4 and b = 11323 and c = 7) Then d = 123; else if (a = 4 and b = 11323 and c = 8) Then d = 124; else if (a = 3 and b = 11323 and c = 7) Then d = 125; else if (a = 3 and b = 11323 and c = 8) Then d = 126; else if (a = 3 and b = 11303 and c = 7) Then d = 127; else if (a = 3 and b = 11303 and c = 8) Then d = 128; else if (a = 4 and b = 11305 and c = 7) Then d = 129; else if (a = 4 and b = 11305 and c = 8) Then d = 130; else if (a = 3 and b = 11306 and c = 7) Then d = 131; else if (a = 3 and b = 11306 and c = 8) Then d = 132; else if (a = 4 and b = 11300 and c = 7) Then d = 133; else if (a = 4 and b = 11300 and c = 8) Then d = 134; else d = 555;     set work.zyx; run; I placed the brackets at different places but i didn't find the right one.   If i have for a the value 3, for b the value 11319 and for c the value 7, I expect to get 121 as value but what i get is 555.   Thanks for your help.   ... View more

Re: If Condition with and... or ... or... or... is incorrect

by Fluorite | Level 6 in New SAS User
‎07-26-2021 07:22 AM
‎07-26-2021 07:22 AM
I dont know where i can answer to all of you at once. So Thanks to all of you for your fast answers 😄 ... View more

If Condition with and... or ... or... or... is incorrect

by Fluorite | Level 6 in New SAS User
‎07-26-2021 06:36 AM
‎07-26-2021 06:36 AM
data work.test_out; set work.test_in; if value < 0 and item= 1 or item = 2 Or item = 3 Or item =4 Then document= 4; else if value > 0 and item = 5 or item = 6 Or item = 7 Or item =8 Then document= 3; else if value < 0 and item = 9 or item = 10 Or item = 11 Or item =12 Then document= 3; else if value > 0 and item = 9 or item = 10 Or item = 11 Or item =12 Then document= 4; else document= ' '; run; Hi SAS-Experts, my code is like above and i have following problem:   When i have e.g. (+) 41 as value with Item-Nr. 10 i get  document-Nr. 3 but i expect 4 for document. The question is, where my mistake is. Maybe i have to clamp something but i dont know what.   Would be nice, if u could help me.   Thanks in advance. ... View more

Re: variable in data with an if-condition

by Fluorite | Level 6 in New SAS User
‎07-21-2021 06:22 AM
2 Likes
‎07-21-2021 06:22 AM
2 Likes
I found the solution. 😄   data Work.test; set input; value = 0.4* value_input; if value > 0 then reference_number = 123; else reference_number = 345; run; Sorry for disturbing you.   Have a nice day 😄   ... View more

Re: Define a macro with an if-condition

by Fluorite | Level 6 in New SAS User
‎07-21-2021 06:15 AM
‎07-21-2021 06:15 AM
Its difficult to explain. I just needed the macro for another code. The datas i used have e.g. the variable name "mrz_test" "apr_test" and so on. With the new macro i want to address this variable names via &test_a.test. And i dont want to give test_a the value "mrz" directly, because i already have so many different macros in my code. Thanks to PaigeMiller i managed to get the english month-names (Mar, May, Oct, Dec) but not the german ones (Mrz, Mai, Okt, Dez). So i changed all variable names into english and now i'm happy :D. My Code do what it is made for. ... View more

variable in data with an if-condition

by Fluorite | Level 6 in New SAS User
‎07-21-2021 05:25 AM
‎07-21-2021 05:25 AM
Hi guys, it's me again.   You helped me a lot but i have one more question 😄   I have the following code: data Work.test; set input; value = 0.4* value_input; reference_number = if value > 0 then reference_number = 123 else 345; run; My data has different positive and negative values in the variable value_input. The aim should be, that positive values get the reference_number  345 and all other values get the reference_number 123.   I get three syntax errors: 1. Missing !,!!, & ... 2. Expecting an arithmetic operator 3. The option or parameter is not recognized and will be ignored   Would be great if you could help me   Thanks in advance. ... View more

Re: Define a macro with an if-condition

by Fluorite | Level 6 in New SAS User
‎07-16-2021 08:27 AM
‎07-16-2021 08:27 AM
I tested your code and it works well. My problem is, that i have the names of the month in german. So Mar = Mrz, May = Mai, Oct = Okt, Dec = Dez. Is there a solution for this? Maybe another format? ... View more

Define a macro with an if-condition

by Fluorite | Level 6 in New SAS User
‎07-16-2021 08:11 AM
‎07-16-2021 08:11 AM
Hi SAS-Experts,   i have a problem and have no idea how to fix it.   I want to define a macro-variable with an if-condition. I mean i have e.g. the  macro-variable "current_month" that is 3. In the next step i want to convert it into a macro called "month_test" that include the month as a name.   I tried it with the attached code but get the error "Statement is not valid..."   %let current_Month = 3; %let month_test = &test_a; %macro testmonth(Month=); %if &Month = 1 %then %do; &test_a = Jan %end; %else %if &Month = 2 %then %do; &test_a = Feb %end; %else %if &Month = 3 %then %do; &test_a = Mar %end; %else &test_a = Dec;; run; %mend testmonth; %testmonth(Month=&current_Month); I hope u understand what i mean. I would be realy happy, if u could help me.   Thanks   ... View more

Re: If Then Else funktioniert nicht richtig

by Fluorite | Level 6 in New SAS User
‎07-15-2021 02:45 AM
‎07-15-2021 02:45 AM
Thanks a lot for all your advices. You helped me a lot. ... View more

If Then Else funktioniert nicht richtig

by Fluorite | Level 6 in New SAS User
‎07-13-2021 09:52 AM
‎07-13-2021 09:52 AM
Hallo liebes Forum,   ich habe folgendes Problem:   ich habe eine Makro-Variable "Monat" definiert, die die Werte 1-3 enthalten kann. Außerdem habe ich eine Datei, die Werte enthält. Jetzt möchte ich, dass bestimmte Dinge passieren, je nachdem, welcher Wert der Variable Monat vorher zugewiesen wurde.   So wäre mein Vorgehen jetzt gewesen:   %let Monat = 3; data work.test;      set work.test;      if &Monat = 1 then do;             Jan_multi=Jan*1;             drop Jan;      end;      else if &Monat = 2 then do;             Jan_multi= Jan*1;             Feb_multi= Feb*2;             drop Jan Feb;      end;      else if &Monat = 3 then do;            Feb_multi= Feb*2;            Mrz_multi= Mrz*3;            drop Jan Feb Mrz;      end;      else do;            test=Jan;      end; run;   Das Problem ist jetzt, dass der letzte Schritt, also die else do-Anweisung überflüssigerweise auch durchgeführt wird, obwohl ich oben ja nur die 3 angegeben habe. Also es wird auch eine Spalte test angelegt, die die Werte aus der Spalte Jan enthält, obwohl das nicht passieren sollte. Das macht in meinen Augen gar keinen Sinn... Woran liegt das denn, bzw. wie kann ich das verhindern?   Vielen Dank schon mal und freundliche Grüße ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-27-2021 04:12 PM
Likes given to
Likes from
View All
Quick links