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: 
PierreYvesILY
‎07-02-2021
  • 142 Posts
  • 109 Likes Given
  • 1 Solutions
  • 5 Likes Received

Re: othe rmacro code correction

by Pyrite | Level 9 in New SAS User
‎10-22-2020 10:20 AM
‎10-22-2020 10:20 AM
hello Paige, with the Code: %let KUM_param=1; * Hier für Monatsdashboard 0 eingeben - fürs kumuliertes Dashboard 1 eingeben ; %if &KUM_param=0 %then %do; %let KUM_Steuer = &Spanne.; %end; %else %do; %let KUM_Steuer = 33; %end;   I've got the following error:   %let KUM_param=1; * Hier für Monatsdashboard 0 eingeben - fürs kumuliertes Dashboard 1 eingeben ; 40 %if &KUM_param=0 %then %do; %let KUM_Steuer = &Spanne.; %end; ERROR: The %IF statement is not valid in open code. ERROR: The %END statement is not valid in open code. 41 %else %do; %let KUM_Steuer = 33; %end; ERROR: The %ELSE statement is not valid in open code. ERROR: The %END statement is not valid in open Code. ... View more

othe rmacro code correction

by Pyrite | Level 9 in New SAS User
‎10-22-2020 09:38 AM
‎10-22-2020 09:38 AM
hello dear SAS experts,   I have this Code: %let Auswertungstag = '01JAN2021'D; *Bei Bedarf: Datum vorgeben; %let Spanne=12; *Spanne: Anzahl der Monate des Dashboardszeitraum; *Der Monatszeitraum fängt an, mit dem Vormonat von dem Auswertungstag; %let KUM_param=0; %if &KUM_param=0 %then %let KUM_Steuer = &Spanne.; %else %let KUM_Steuer = 33; %put &Auswertungstag.; %put &Spanne. &KUM_param. &KUM_Steuer.;   which leads to the following errors:   GOPTIONS ACCESSIBLE; 26 %let Auswertungstag = '01JAN2021'D; *Bei Bedarf: Datum vorgeben; 27 %let Spanne=12; *Spanne: Anzahl der Monate des Dashboardszeitraum; 28 *Der Monatszeitraum fängt an, mit dem Vormonat von dem Auswertungstag; 29 %let KUM_param=0; 30 %if &KUM_param=0 %then %let KUM_Steuer = &Spanne.; %else %let KUM_Steuer = 33; ERROR: The %IF statement is not valid in open code. ERROR: The %ELSE statement is not valid in open Code.   what should I write? thank you ... View more

Convert month number into month name in GERMAN

by Pyrite | Level 9 in New SAS User
‎10-21-2020 09:03 AM
‎10-21-2020 09:03 AM
Dear SAS experts,   I Need to convert the numbers of the month in the year into the month names, in german: 1 => Januar 2 => Februar 3=> März etc   I know that ther is such a Format like deudfmn10. but I can't write the appropriate Code. I Need the correction of this, wehre date is the number of the month Monat = tranwrd(put(date,deudfmn10.),'ä','ae');   How can I get this? ... View more

Re: correction of macrocode needed

by Pyrite | Level 9 in New SAS User
‎10-19-2020 09:23 AM
‎10-19-2020 09:23 AM
hello,   thank you for your help.   the results of the Code: 930 %let Auswertungstag = '01OCT2020'D; *Bei Bedarf: Datum vorgeben; 931 %let Spanne=9; *Spanne: Anzahl der Monate des Dashboardszeitraum; 932 *Der Monatszeitraum fängt an, mit dem Vormonat von dem Auswertungstag; 933 %let Monat= %eval(%month(&Auswertungstag.)); 934 %let Jahr1= %eval(%year(&Auswertungstag.)); 935 %let Jahr2= %eval(&Jahr1.-1); 936 %put NOTE: &=Auswertungstag.; NOTE: AUSWERTUNGSTAG='01OCT2020'D 937 %put NOTE: &=Spanne. &=Monat. &=Jahr1. &=Jahr2.; 10 The SAS System 14:47 Monday, October 19, 2020 NOTE: SPANNE=9 MONAT=10 JAHR1=2020 JAHR2=2019 938 %put NOTE: Subnmitted from &_CLIENTAPP version &_CLIENTVERSION; NOTE: Subnmitted from 'SAS Enterprise Guide' version '7.100.5.6214' 939 %put NOTE- Running on SAS version &sysvlong; Running on SAS version 9.03.01M2P081512 ... View more

Re: correction of macrocode needed

by Pyrite | Level 9 in New SAS User
‎10-19-2020 09:19 AM
‎10-19-2020 09:19 AM
hello Paige,   I'm a SAS new user, and I don't know much about macrocode. %superq and %qsysfunc are functions I don't know at all. Finally, what I Need is : 1. a macro Monat where the month as a 'number' is saved : for instance: January =1 and December = 12. The &Monat. has to be the month BEFORE the &Auswertungstag. therefore: if &Auswertungstag. = '01JAN2021'D => &Monat. = 12 2. a macro Jahr1 where the year of that given monat is stored. &Auswertungstag. = '01JAN2021'D => &Monat. = 12 and &Jahr1.=2020 &Auswertungstag. = '01DEC2020'D => &Monat. = 11 and &Jahr1.=2020 &Auswertungstag. = '01FEB2021'D => &Monat. = 1 and &Jahr1.=2021 I tried: %let Auswertungstag = %sysevalf('01OCT2020'd); *Bei Bedarf: Datum vorgeben; %let Spanne=9; *Spanne: Anzahl der Monate des Dashboardszeitraum;   *Der Monatszeitraum fängt an, mit dem Vormonat von dem Auswertungstag; %if %sysfunc(month(&Auswertungstag.)) ne 0 %then %let Monat=%sysfunc(month(&Auswertungstag.)); %else %let Monat=12; %if &Monat ne 12 %then %let Jahr1= %sysfunc(year(&Auswertungstag.)); %else %let Jahr1= %sysfunc(year(&Auswertungstag.)-1); %let Jahr2= %eval(&Jahr1.-1); %put &=Auswertungstag.; %put &=Spanne.; %put &=Monat.; %put &=Jahr1.; %put &=Jahr2.;   and I got the Errors: ERROR: The %IF statement is not valid in open code. ERROR: The %ELSE statement is not valid in open code.   Could you help to correct this?   Thanks for your help     ... View more

Re: correction of macrocode needed

by Pyrite | Level 9 in New SAS User
‎10-19-2020 08:10 AM
‎10-19-2020 08:10 AM
hallo Paige,   I've got the following error messages ; is it possible, that it is due to SAS 9.3?   43 %let Auswertungstag = %sysevalf('01OCT2020'd); *Bei Bedarf: Datum vorgeben; ERROR: Open code statement recursion detected. 44 %let Spanne=9; *Spanne: Anzahl der Monate des Dashboardszeitraum; ERROR: Open code statement recursion detected. 45 *Der Monatszeitraum fängt an, mit dem Vormonat von dem Auswertungstag; 46 %let Monat= %sysfunc(month(&Auswertungstag.)); ERROR: Open code statement recursion detected. 47 %let Jahr1= %sysfunc(year(&Auswertungstag.)); ERROR: Open code statement recursion detected. 2 The SAS System 13:41 Monday, October 19, 2020 48 %let Jahr2= %eval(&Jahr1.-1); ERROR: Open code statement recursion detected. 49 %put &=Auswertungstag.; ERROR: Open code statement recursion detected. 50 %put &=Spanne.; ERROR: Open code statement recursion detected. 51 %put &=Monat.; ERROR: Open code statement recursion detected. 52 %put &=Jahr1.; ERROR: Open code statement recursion detected. 53 %put &=Jahr2.; ERROR: Open code statement recursion detected. 54 55 GOPTIONS NOACCESSIBLE; 56 %LET _CLIENTTASKLABEL=; ERROR: Open code statement recursion detected. 57 %LET _CLIENTPROCESSFLOWNAME=; ERROR: Open code statement recursion detected. 58 %LET _CLIENTPROJECTPATH=; ERROR: Open code statement recursion detected. 59 %LET _CLIENTPROJECTPATHHOST=; ERROR: Open code statement recursion detected. 60 %LET _CLIENTPROJECTNAME=; ERROR: Open code statement recursion detected. 61 %LET _SASPROGRAMFILE=; ERROR: Open code statement recursion detected. 62 %LET _SASPROGRAMFILEHOST=; ERROR: Open code statement recursion detected. 63 ... View more

correction of macrocode needed

by Pyrite | Level 9 in New SAS User
‎10-19-2020 07:50 AM
‎10-19-2020 07:50 AM
Hello, my Code: %let Auswertungstag = '01OCT2020'D; *Bei Bedarf: Datum vorgeben; %let Spanne=9; *Spanne: Anzahl der Monate des Dashboardszeitraum; *Der Monatszeitraum fängt an, mit dem Vormonat von dem Auswertungstag; %let Monat= %eval(%month(&Auswertungstag.)); %let Jahr1= %eval(%year(&Auswertungstag.)); %let Jahr2= %eval(&Jahr1.-1); %put &Auswertungstag.; %put &Spanne.; %put &Monat.; %put &Jahr1.; %put &Jahr2.;   I get following Errors in the log:   GOPTIONS ACCESSIBLE; 27 %let Auswertungstag = '01OCT2020'D; 28 %let Spanne=9; 29 30 %let Monat= %eval(%month(&Auswertungstag.)); 31 %let Jahr1= %eval(%year(&Auswertungstag.)); NOTE: The quoted string currently being processed has become more than 262 bytes long. You might have unbalanced quotation marks. 32 %let Jahr2= %eval(&Jahr1.-1); 33 %put &Auswertungstag.; 34 %put &Spanne.; 35 %put &Monat.; 36 %put &Jahr1.; 37 %put &Jahr2.;   Why is there no result in the log after the %put Statement? it seems it doesn't calculate anything.   How can I correct this?       ... View more

Re: week selection over the end of the year

by Pyrite | Level 9 in New SAS User
‎10-15-2020 11:08 AM
‎10-15-2020 11:08 AM
Hello Kurt, thank you for your Suggestion. I could use it to built my solution. Have a nice evening. Regards ... View more

week selection over the end of the year

by Pyrite | Level 9 in New SAS User
‎10-15-2020 09:11 AM
‎10-15-2020 09:11 AM
dear SAS experts,   I must select data over several weeks and over the end of the year. In the table, I have a column JAHR (year) and a column KW (week), as in the attached file. In the week 1 (KW = 1), I Need to select the green selection. In the week 1 (KW = 4), I Need to select the yellow selection. In the week 1 (KW = 5), I Need to select the red selection. How could I proceed?   ... View more

Re: how to chain datasets with same name and variables structure

by Pyrite | Level 9 in New SAS User
‎08-07-2020 06:43 AM
‎08-07-2020 06:43 AM
thank you Kurt, have a nice day! ... View more

how to chain datasets with same name and variables structure

by Pyrite | Level 9 in New SAS User
‎08-07-2020 06:33 AM
‎08-07-2020 06:33 AM
Hello SAS experts,   I have a list of datasets with the same name and variables structure, and I want to add them all in a single one. this doesn't work: data vzk_2020; do i=1 to 8; set vzk_2020_i; end; run; what's the correct way?   regards, PY ... View more

Re: proc transpose problem

by Pyrite | Level 9 in New SAS User
‎06-30-2020 08:31 AM
‎06-30-2020 08:31 AM
thank you Kurt, case solved.     ... View more

proc transpose problem

by Pyrite | Level 9 in New SAS User
‎06-30-2020 07:06 AM
‎06-30-2020 07:06 AM
hello,   I have the following type of dataset:   I would like to transpose the column VERWEND_ZWECK_CLUSTER to obtain a table: here are the values of the Column 'Quote' used as values for each VERWEND_ZWECK_CLUSTER value, which are used as column names in the target dataset.   How can I proceed?   thanks in advance PY ... View more

Re: format based on more than 1 variable

by Pyrite | Level 9 in New SAS User
‎04-23-2020 11:37 AM
‎04-23-2020 11:37 AM
I use 2 variables: VERTRBGN and DTENDFLG, in a function. It's using the difference between those 2 dates to build a cluster : for instance, if DTENDFLG - VERTRBGN < 12, the cluster is labelled '12'.   My question is how to create the format that would give the same result as the code that I posted. My result can be in text or in character, it's not important for this step. ... View more

format based on more than 1 variable

by Pyrite | Level 9 in New SAS User
‎04-23-2020 10:24 AM
‎04-23-2020 10:24 AM
dear SAS experts,   how can I simplify such blocks: - it's a new varaible based on more than 1 variable and using a formula - I have many of these structures in many programs   Can I define a format to make it easier and how?   /* LAUFZEIT_CLUSTER_HJ */ (CASE WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 6 THEN 6 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 12 THEN 12 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 18 THEN 18 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 24 THEN 24 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 30 THEN 30 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 36 THEN 36 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 42 THEN 42 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 48 THEN 48 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 54 THEN 54 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 60 THEN 60 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 66 THEN 66 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 72 THEN 72 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 78 THEN 78 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 84 THEN 84 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 90 THEN 90 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 96 THEN 96 WHEN FLOOR(DATDIF(t1.VERTRBGN, t1.DTENDFLG, '30/360')/30) <= 120 THEN 120 ELSE 10000 END) FORMAT=BESTX12. AS LAUFZEIT_CLUSTER_HJ,   Regards, PY ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-02-2021 10:24 AM
Group Hubs for PierreYvesILY
View All
Likes given to
Likes from
View All
Quick links