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: 
DartRodrigo
‎06-01-2022
  • 223 Posts
  • 69 Likes Given
  • 7 Solutions
  • 21 Likes Received
About
SAS Base Programmer Certified SAS Platform Administrator Certified SAS Visual Analytics SAS DI SAS RTDM SAS Macro Linguage (Mean)

Re: Mixed procedure not working working during remote submit

by Lapis Lazuli | Level 10 in SAS Programming
‎11-30-2015 06:49 AM
‎11-30-2015 06:49 AM
Hi i found this:   ODS is complaining because WORK.yourdata1 and WORK.yourdata2 are already assigned as ODS OUTPUT data sets. Why that is the case cannot be determined from the code fragment. Presumably they were assigned in previously executed code. I recommend that you contact Technical Support with this problem. You can submit it online at http://support.sas.com/ctx/supportform/index.jsp .   Link from PROC MIXED Convergence criteria not met.   Hope this helps ... View more

Re: Date and time variables in SAS macro behaviour. Date works, time d...

by Lapis Lazuli | Level 10 in ODS and Base Reporting
‎11-27-2015 09:29 AM
‎11-27-2015 09:29 AM
Hi mate, welcome.   I've made a little change in your code and it worked as you said in the Log: TheDate is 20408 and ThisDay is TODAY() and the diff is -11   %Let TheDate= %sysfunc(datepart('16NOV2015:00:00:00'dt),best12.); %Let ThisDay = %sysfunc(TODAY(),date9.); %Put TheDate is &Dato and ThisDay is &Thisday and the diff is %eval(%eval(%sysfunc(today(),best12.)) - %eval(&TheDate)); Hope this helps ... View more

Re: Mixed procedure not working working during remote submit

by Lapis Lazuli | Level 10 in SAS Programming
‎11-27-2015 07:26 AM
‎11-27-2015 07:26 AM
Are you using rsubmit ? ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 12:34 PM
‎11-26-2015 12:34 PM
No Reeza, Thanks again guys, amazing answers.   Thanks  ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 12:29 PM
‎11-26-2015 12:29 PM
The exactly number is 50.063.860 ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 12:27 PM
‎11-26-2015 12:27 PM
That's the number of possibilities of a Raffle game.  ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 12:26 PM
‎11-26-2015 12:26 PM
Yes ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 12:17 PM
‎11-26-2015 12:17 PM
Amazing man, that't exactly what i need, but if i would need 50.063.860 ( )   just asking ! How much should i need to create to get the top 50.063.860 ? ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 11:37 AM
‎11-26-2015 11:37 AM
Hum, it's ok but what i need is sixty different possibilities of sequences.   Thanks ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 11:30 AM
‎11-26-2015 11:30 AM
Oh yes, this can't happen.   Thanks ... View more

Re: Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 11:14 AM
‎11-26-2015 11:14 AM
No, order doesn't metter but what metter is: if one sequence exists, it can not be duplicated. That's all, thanks ... View more

Do loop

by Lapis Lazuli | Level 10 in SAS Programming
‎11-26-2015 11:09 AM
‎11-26-2015 11:09 AM
Hi,  I have the following code sent to me by Reeza:     data random; array s(60) s1-s60 (60*0); array p(6) p1-p6; do i=1 to 6; do while(p(i)=.); p(i)=floor(rand('uniform')*60+1); if s(p(i))=0 then s(p(i))=1; else p(i)=.; end; end; keep p1-p6; call sortn(of p(*)); run; This code create six random numbers from 1 to 60 without duplicating them.   Now i need a loop to create 60 lines with diferente possibilities, the sequence (can't,may not) duplicate What i mean: if the sequence is: 1,2,3,4,5,6 the next line may not duplicate, so it can be any other sequence,  1,2,3,4,5,7 or 13,24, 25,30,57,58   Thanks in advance,   Rodrigo ... View more

Re: Import raw data

by Lapis Lazuli | Level 10 in SAS Programming
‎11-24-2015 07:07 AM
‎11-24-2015 07:07 AM
I import every part of this file as strings. The third part is a doc number and it is a string column. It does make sence because this is how it is in my raw file. This file is extracted with a robot.   The generated file is as shown before. I need to import every part of this as strings, after all of this, i can change the formats, but what i need for now is a way to import when cases like this happens. And because some politicies they can't change the file to be generated in its right form.   Thanks   ... View more

Import raw data

by Lapis Lazuli | Level 10 in SAS Programming
‎11-24-2015 06:34 AM
‎11-24-2015 06:34 AM
Hi,   Need help on importing raw file to SAS. The example below shows how is the file:     011 30000092 10498100037500000000003000006274966080000018000 Condo 180,00 Ha 05/11/2015 13:16 Ha 031 34300000 39900000000000000000000000000023800000000000000 Fat Porto 794,02 Ha 05/11/2015 14:05 Ha 031 34000003 39994000000000000000000000000024100000000000000 car porto 2.568,42 Ha 05/11/2015 14:45 Ha 010 34000000 00190000090142509602911765526170266030000074031 carro 740,31 Ha 05/11/2015 07:46 Ha   If you see, the first five values of the fourth line, should be at the third line. And the fourth line should begin in the 010.   The next textbox is how it should be:   031      34340033 39994000000000000000000000000024100000000000000  cartão porto 2.568,42 Ha 05/11/2015 14:45 Ha 010      34000000 00190000090142509602911765526170266030000074031  carro                      740,31 Ha   05/11/2015 07:46  Ha   How can i solve this when i import the file ?   Thanks in advance ... View more

Re: Groups of Data

by Lapis Lazuli | Level 10 in SAS Programming
‎11-23-2015 12:05 PM
‎11-23-2015 12:05 PM
Actualy i need the proc step. What i need is, establish tracks, just like:   if the value is lower than 10 then all values that are lower then 10 are in this group if the value is lower than 20 then all values that are lower then 20 are in this group if the value is lower than 30 then all values that are lower then 30 are in this group   I think there is a way to do this with proc tabulate but i don't remember how.   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-01-2022 09:35 AM
  • Contact User via MSN
  • Contact User via AIM
Likes given to
Quick links