Hi, I try to install SAS with sasdepot 9.4 with 'Perfom a Planned Deployement' options. I use ubuntu 22.10. When I chose 'DIServer, one machine' , I get this error: The following characters are invalid for the Deployment Plan location: % * " & ? : > \ | ( ). Is there a way to bypass this problem? ... View more

Hi, in sas VA, -the filter n Between inclusive (4,5) it means:        n <=5 and n>=4 -the filter n  OutsideExclusive(4,4) it means:         n <4 and n >4   is it right? ... View more

Hi, I have two table, one has this value: a=2894378 and the second has this value: b = 28943.78. I make the join between them, and when i verify if they are equal : c = a / 100 if  c = b  sas interprets like different value. I try to change also the format, but after there are only 0 value.   I don't understand why... ... View more

Hi, I need to convert this Oracle Code in SAS :   row_number() over (partition by Var1, Var2, Var3 order by Var 4, Var5, Var6) I'm trying with proc rank, but it requires just one variable in rank parameter. I would like to know if is there any chance to implement it with proc rank. Thanks ... View more

Hi,  I use SAS Data Integration in order to append some data. I would like to use the transformation "Insert Rows", but actually it puts automatically the options "COMPRES=YES" in data output. When I run the job, SAS DI shows this warning:   461 /*---- Insert rows into target table ----*/ 462 proc sql; 463 insert into inp.out_v ( 464 COMPRESS = YES, 465 V1, V2, V3, V4, V5 466 ) 19 The SAS System 16:38 Tuesday, July 5, 2022 467 select 468 W7FCUX5.V1 length = 8 469 label = 'V1', 470 W7FCUX5.V2 length = 32 471 label = 'V2', 472 W7FCUX5.V3 length = 3 473 label = 'V3', 474 W7FCUX5.V4 length = 255 475 label = 'V4', 476 W7FCUX5.V5 length = 255 477 label = 'V5' 478 from 479 work.W7FCUX5 as W7FCUX5 480 ; 481 quit; 482 483 %global etls_sql_pushDown; 484 %let etls_sql_pushDown = &sys_sql_ip_all; 485 486 %rcSet(&sqlrc); 487 488 %mend etls_sql_insert_rows; 489 490 /* execute etls_sql_insert_rows */ 491 %etls_sql_insert_rows; WARNING: The option COMPRESS is not valid in this context. Option ignored. WARNING: The option COMPRESS is not valid in this context. Option ignored. Is there a way to remove this warning? ... View more

Hi, I would like to create a table with 99 rows and 99 columns automatically. With this macros I'm able to create 99 row automatically.: %MACRO CALCULATE(COLUMN=); data &column; do i=1 to 99; output; end; rename i=freq_range; run; %MEND; %CALCULATE(COLUMN=_1); but I haven't any idea how to create 99 columns automatically. Is there a way? ... View more