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: 
Yaqun
‎09-08-2020
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Do loop error problem

by Fluorite | Level 6 in SAS Studio
‎04-08-2020 02:48 PM
‎04-08-2020 02:48 PM
I put a FORMAT statement inside a DO loop. It is not executed. I know it does not make any sense now. Thank you! ... View more

Re: Do loop error problem

by Fluorite | Level 6 in SAS Studio
‎04-08-2020 02:46 PM
‎04-08-2020 02:46 PM
I see what you mean. That is helpful! ... View more

Re: Do loop error problem

by Fluorite | Level 6 in SAS Studio
‎04-08-2020 02:42 PM
‎04-08-2020 02:42 PM
It works when the code change to   data pnm_sur;set part3.pnm_sur; array fydate (14) fydate1-fydate14; fydate1= intnx('year',cv3date,1,'S'); do i=1 to 13; fydate(i+1)=intnx('year',fydate(i),1,'S'); end; format fydate1--fydate14 MMDDYY10.; run;   So do loop cannot be used in format? or the reason is something else ... View more

Re: Do loop error problem

by Fluorite | Level 6 in SAS Studio
‎04-08-2020 02:35 PM
‎04-08-2020 02:35 PM
I changed my code:   data pnm_sur;set part3.pnm_sur; array fydate (14) fydate1-fydate14; fydate1= intnx('year',cv3date,1,'S'); do i=1 to 13; fydate(i+1)=intnx('year',fydate(i),1,'S'); end; do i=1 to 14; format fydate(i) MMDDYY10.; end; run;   But there still some errors with the format: ERROR 85-322: Expecting a format name. It did not consider fydate(i)  as a format name? ... View more

Re: Do loop error problem

by Fluorite | Level 6 in SAS Studio
‎04-08-2020 02:04 PM
‎04-08-2020 02:04 PM
That is exactly what I want to do! Thanks a lot ! ... View more

Re: Do loop error problem

by Fluorite | Level 6 in SAS Studio
‎04-08-2020 12:19 PM
‎04-08-2020 12:19 PM
Hi PaigeMiller, Thanks a lot for your quick reply! I see my problem. I thought "array" may develop new variables, actually it cannot. I develop fy1date to fy13date in the former step and it works! Thank you! ... View more

Do loop error problem

by Fluorite | Level 6 in SAS Studio
‎04-08-2020 11:53 AM
‎04-08-2020 11:53 AM
Hi guys, I am a SAS starter.I just want to build new variables with the do loop, here is my code:   data pnm_sur; set part3.pnm_sur; fy1date=cv3date+365.25; array fydate(13) fy1date--fy13date; do i=1 to 13; fydate(i+1)=fydate(i)+365.25; end; run;   Errors happens " ERROR: fy13date does not follow fy1date on the list of previously defined variables. ERROR: Too few variables defined for the dimension(s) specified for the array fydate." I don't know how to figure it out and I want your help. Thanks a lot! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-08-2020 01:47 PM
Likes given to
View All
Quick links