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: 
Onizuka
‎08-07-2019
  • 117 Posts
  • 49 Likes Given
  • 5 Solutions
  • 4 Likes Received

Re: Match a period to a date

by Pyrite | Level 9 in SAS Programming
‎04-30-2019 09:28 AM
‎04-30-2019 09:28 AM
Thank you for your answer.   The problem is that i don't have a table with a start and end date.   This is where I'm calculating my periods :   %macro calcul_periode ; %local j ; %DO j = 1 %TO 3 ; /* 3 times because i have 3 files */ data mca.periode_niv&j (drop = date_fin_trim) ; set mca.res_niv&j ; Format periode 2. ; date_fin_trim = "31MAR2019"d ; if intnx('month', date_fin_trim, 0) <= date <= date_fin_trim then Periode = 1 ; %local i ; %DO i = 1 %TO 35 ; if intnx('month', date_fin_trim, %eval(-(&i)-1)) <= date < intnx('month', date_fin_trim, -&i) then Periode = %eval((&i)+1) ; %end ; run ; %end ; %mend calcul_periode ; ... View more

Re: Proc SQL to Data Step

by Pyrite | Level 9 in SAS Programming
‎04-30-2019 09:20 AM
‎04-30-2019 09:20 AM
Are you obliged to do that with data set ?   Because you are merging 4 tables.   You can do the same in SAS using merge.   But it is very long because you have to sort each table by the id and merge 4 times (i think) ... View more

Match a period to a date

by Pyrite | Level 9 in SAS Programming
‎04-30-2019 08:59 AM
‎04-30-2019 08:59 AM
Hello everybody,   (sorry for my english)   I am trying to add a date depending of a period.   Here an example of my datas :   Data have ; format cniv1_cniv2 $11. period 2. nbper 8. ; input cniv1_cniv2 period nbper; cards; 10000_20000 4 26 30000_40000 9 34 50000_60000 2 32 70000_80000 1 17 ; run ; I would like to add the last date of the period on a new variable "last_dt_period".   I have calculated the periods on another programm earlier : Period 1 = 01/03/2019 --> 31/03/2019 Period 2 = 01/02/2019 --> 28/02/2019 Period 3 = 01/01/2019 --> 31/01/2019 .... Period 36 = 01/03/2016 --> 31/03/2016   So what i want to do now, is add in my last table (have), the last date of each period to have something like this :   Data want ; format cniv1_cniv2 $11. period 2. nbper 2. last_dt_period $10.; input cniv1_cniv2 period nbper last_dt_period; cards; 10000_20000 4 26 31/12/2018 30000_40000 9 34 31/07/2018 50000_60000 2 32 28/02/2019 70000_80000 1 17 31/03/2019 ; run ; How can I do this ?   Thank you very much and good afternoon !   Onizuka   ... View more

Re: Select data with some criterias

by Pyrite | Level 9 in SAS Programming
‎04-26-2019 05:21 AM
‎04-26-2019 05:21 AM
Hello @andreas_lds    Thank you for you answer 🙂   Your solution is working very well, I have to say that i'm not understanding everything on your code ..   More precisely, I do not understand this part :   if not missing(summed) and (keeped < 3 or summed < 20) then do; keeped = keeped + 1; lastPeriode = periode; summed = sum_cum; end;   I don't understand the process for keeped and summed, because to me, keeped is always ❤️ and summed <20 because it equals 0 ? (on the beggining of the code)   Another question, why if i'm putting the do until(last.cniv1_cniv4); after the set, it don't work ?   Thank you very much and sorry for bad skills on SAS ... I though I was better in SAS that I really am haha   Onizuka ... View more

Re: Problem with a cumulative sum

by Pyrite | Level 9 in SAS Programming
‎04-26-2019 03:24 AM
‎04-26-2019 03:24 AM
Hello @ballardw    Thank you very much for your answer and for your example which permit me to understand the problem I had.   Normally I put code on the topic (Data Have) but I thought that the error should be a syntax error, sorry for that..   It is doing the same problem if you put the delete after the first.i.   Using the solution of @Astounding  it is working, putting a "where periode ne . "   Thanks to you two ! 🙂 ... View more

Problem with a cumulative sum

by Pyrite | Level 9 in SAS Programming
‎04-25-2019 11:00 AM
‎04-25-2019 11:00 AM
Hello,   I have a problem with my cumulative some per group.   I don't understand why sometimes it works perfectly, and all of a sudden, it's completly messes and then it work again...   This is my programm ...   Proc sort data = mca.res_periode_niv2 ; by cniv1_cniv4 periode ; run ; data mca.res_periode_niv2 ; set mca.res_periode_niv2 ; if periode = . then delete ; by cniv1_cniv4 ; if first.cniv1_cniv4 then sum_cum = 0 ; sum_cum + cpt4 ; run ; And here you can see a picture when it's working :   You can see for example on line 13, there is a new cniv1_cniv4 and the sum start to 0 again but ...     On line 1610, you can see that SAS don't understand that it is a new group and he continues to sum...   Any ideas  ? .. ... View more

Re: Select data with some criterias

by Pyrite | Level 9 in SAS Programming
‎04-25-2019 10:01 AM
‎04-25-2019 10:01 AM
Hello Andreas,   Thank you for your response as fast, I have an additionnal constraint which I forgot to put on my topic because I just thought about it and which can complicate a little bit the problem.   I want the same thing but i want to keep these periods only if i have respondents in period 0 or period 1 or period 2 (during the first quarter : 01/01/2019 --> 31/03/2019).   Indeed,  on my real datas, I have some ids which the first period is period 9 for example (9 month before so on jun 2018).   I don't know if my reply is clear .. =/   Thank you again for your time , really appreciate it ! 🙂     ... View more

Select data with some criterias

by Pyrite | Level 9 in SAS Programming
‎04-25-2019 08:46 AM
‎04-25-2019 08:46 AM
Hello everyone !   (sorry for my english) The tittle of the topic is not so explicit because i don't know how to tell that..   I'm putting here an example  and then I explain you what i'm expecting for :     Data have ; format id1 id2 $5. periode 2. cpt2 8. sum_cum 8.; input id1 id2 periode cpt2 sum_cum ; cards; 10000 00001 0 20 20 10000 00001 1 13 33 10000 00001 2 17 50 10000 00001 3 50 100 10000 00001 4 10 110 10000 00001 5 15 125 10000 00001 6 81 81 20000 00002 0 5 5 20000 00002 1 3 8 20000 00002 2 10 18 20000 00002 3 1 19 20000 00002 4 11 30 20000 00002 5 30 60 ; run ;     This is the table :     - id1 is a head office   - id2 is an agency   - periode : 0 is the last month of the first trimester (01/03/2019 --> 31/03/2019)   periode : 1 is the month before (01/02/2019 --> 30/02/2019)   periode : 3 is the month before (01/01/2019 --> 31/01/2019) ...   - cpt2 is the number of survey respondents per periode   - sum_cum is the number cumulated of cpt2   I'm trying to select data depending on 2 conditions :   I want to know which period i have to take acording to 3 criteria :   - I need minimum 3 periods (so minimum periode 0, 1 and 2) - I want minimum 20 respondents - The maximum of periode is 36,   If i don't have 20 respondents on the three periods, then i want to look for the next period and see if I have 20 respondents, if it is less than 20 again, see the next period, .... if i don't have 20 respondents in 36 periodes then delete, good bye, we don't care haha   So this is what i would like to have on the output :   Data want ; format id1 id2 $5. periode 2. cpt2 8. sum_cum 8.; input id1 id2 periode cpt2 sum_cum ; cards; 10000 00001 0 20 20 10000 00001 1 13 33 10000 00001 2 17 50 20000 00002 0 5 5 20000 00002 1 3 8 20000 00002 2 10 18 20000 00002 3 1 19 20000 00002 4 11 30 ; run ;   I don't know how write it in SAS, I don't think that it is very difficul but if you can help me, i will be very grateful !!   Thank you !   Onizuka ... View more

Re: Do loop on a macro with Array

by Pyrite | Level 9 in SAS Programming
‎04-18-2019 09:09 AM
‎04-18-2019 09:09 AM
@PaigeMiller wrote: I don't see where you are getting different results for &nbvareer or &&nbvarev&i depending on whether or not &I is 1 or 2.   You could use   ARRAY teer &list_eer_finale. %IF &i = 1 %THEN ceidfeer_1 ceidfeer_2; ; ARRAY tev&i. &&list_ev&i._finale. %IF &i = 1 %THEN ceidfev1_1_i1_ ceidfev1_1_i2_; ; in which case SAS figures out how many elements are in each array Aaaaaaaah ok... lol good to know... much easier indeed, I did not know that sas found the number of elements by himself..   Thank you very much ^^ ... View more

Re: Do loop on a macro with Array

by Pyrite | Level 9 in SAS Programming
‎04-18-2019 09:06 AM
‎04-18-2019 09:06 AM
I succeeded :   ARRAY teer[%IF &i = 1 %THEN %eval(&nbvar_eer. +2); %Else &nbvar_eer.;] &list_eer_finale. %IF &i = 1 %THEN ceidfeer_1 ceidfeer_2 ;; ARRAY tev&i.[%IF &i = 1 %THEN %eval(&&nbvar_ev&i.+2); %Else &&nbvar_ev&i.;] &&list_ev&i._finale. %IF &i = 1 %THEN ceidfev1_1_i1_ ceidfev1_1_i2_ ;; A little far-fetched but it works haha (i'm still learning about macro language and what you explained to me last time helps me a lot) ... View more

Re: Do loop on a macro with Array

by Pyrite | Level 9 in SAS Programming
‎04-18-2019 08:56 AM
‎04-18-2019 08:56 AM
@PaigeMiller wrote: The other problem in your code   ARRAY teer[&nbvareer.] &list_eer_finale. %IF &i = 1 %THEN ceidfeer_1 ceidfeer_2 %str(;) ; ARRAY tev&i.[&&nbvarev&i.] &&list_ev&i._finale. %IF &i = 1 %THEN ceidfev1_1_i1_ ceidfev1_1_i2_ %str(;) ; When &i=2, then the %IF statements don't execute, and I don't think your ARRAY statements end with a semi-colon.   I think you want this:   ARRAY teer[&nbvareer.] &list_eer_finale. %IF &i = 1 %THEN ceidfeer_1 ceidfeer_2; ; ARRAY tev&i.[&&nbvarev&i.] &&list_ev&i._finale. %IF &i = 1 %THEN ceidfev1_1_i1_ ceidfev1_1_i2_; ; The first semi-colon on each line ends the %IF, and the second semi-colon ends the ARRAY statement.   Okey, I thought we had to put %str( ; ) for the %IF. Thank you for this precision. I'm trying now to resolve my second problem. On my first loop, I have 17 variables +2 but on the second one I only have 17 variables so I have to modify the ARRAY teer[&nbvareer.] ARRAY tev&i.[&&nbvarev&i.] and more precisely my both macro variables ! ... View more

Re: Do loop on a macro with Array

by Pyrite | Level 9 in SAS Programming
‎04-18-2019 08:22 AM
‎04-18-2019 08:22 AM
Okey, i'am going to try it.   ARRAY teer[&nbvareer.] &list_eer_finale. %IF &i = 1 %THEN ceidfeer_1 ceidfeer_2 %str(;) ; ARRAY tev&i.[&&nbvarev&i.] &&list_ev&i._finale. %IF &i = 1 %THEN ceidfev1_1_i1_ ceidfev1_1_i2_ %str(;) ; I think I have another problem that I will try to solve :   &nbvareer. contain the number of variable in &list_eer_finale. These macro variable were creating previously, i'm doing the code step by step, when all works, i'm putting the entire code on the %macro %mend   &&nbvarev&i. contains :   number of variable in list_ev1_finale (17 +2) number of variable in list_ev2_finale (17 +2)   So i think that i have a problem, because when i'm doing the second loop, i don't have the additionnal two variables so it's wrong. i am going to modify this point. ... View more

Do loop on a macro with Array

by Pyrite | Level 9 in SAS Programming
‎04-18-2019 08:04 AM
‎04-18-2019 08:04 AM
Hello everyone,   (Sorry for my english)   I'm trying to create an array but using an extra condition if we are in the first loop of the "DO".   You can see here my code, I think I'm not very far from succeeding but I have a syntax problem in the macro language.   %MACRO traitement_spe_idf ; %DO i = 1 %TO 2 ; data tempoidf&i; set mdv.ev&i._finale; if niveau_plus_grd = "17515"; %let nbvareer = %eval(&nbvar_eer. +2); %let nbvarev&i. = %eval(&&nbvar_ev&i. +2); ARRAY teer[&nbvareer.] &list_eer_finale. %IF i = 1 %THEN ceidfeer_1 ceidfeer_2 %str(;) ; ARRAY tev&i.[&&nbvarev&i.] &&list_ev&i._finale. %IF i = 1 %THEN ceidfev1_1_i1_ ceidfev1_1_i2_ %str(;) ; do j=1 to dim(teer); teer[j]=tev&i.[j]; end; %IF i = 1 %THEN %DO ; eer_q7=ceidfev1_2; eer_q6_i1_=.; eer_q6_i2_=.; %END ; %ELSE %DO ; eer_q7=ceidfev2_1; ceidfeer_1=ceidfev2_2; eer_q6_i1=.; eer_q6_i2=.; ceidfeer_2=.; %END ; drop j &&list_ev&i._finale. &&list_ev&i._a_suppr.; run; %END ; %MEND traitement_spe_idf ;   My problem on this code :   When i'm generating the both arrays, i want to add 2 variables if I am on the first loop (i = 1) so i tried the %IF ....   I don't know if you have any ideas.   Thank you a lot,   Onizuka ... View more

Re: sas

by Pyrite | Level 9 in SAS Programming
‎04-17-2019 06:04 AM
‎04-17-2019 06:04 AM
@andreas_lds wrote: Please edit the title and add something meaningful. The word "sas" does not tell anybody anything about the issue you need to be solved.   You should although add data in usable format (data step with datalines) and explain. based on the input you show, what do expect as result. He also has the right to say "Hello" don't you think ? haha ... View more

Re: noprint option in proc sql

by Pyrite | Level 9 in SAS Programming
‎04-16-2019 05:46 AM
1 Like
‎04-16-2019 05:46 AM
1 Like
When you use the "noprint" option, it simply means that you are not going to have a display output on your screen. It can be used when you are creating macro-variables. For example :   Proc sql /* noprint */ ; select name into: list /* this create a macro variable "list" which contain all valus of var name */ from example; quit ; So when you do this, you may don't want to see the output so you put the option noprint. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-07-2019 09:19 AM
Likes given to
Likes from
Quick links