Explain why I am getting all the EVEN values when I am doing i+j as a final result in the nested loop:   data floyd; array arr(*) col1-col5; do i=1 to 5; do j=1 to i; arr(i) = i+j; end; output; end; drop i j; run; proc print; run; As per my understanding output has to be : Expected output: and so on......... Can anyone please explain.   ... View more

Can anyone explain to me the logic behind these 2 codes please (uses set in loop):   Code 1: Data class1 ; Do I=1 to 2 ; Set sashelp.class; End; Run; proc print; run; Code 2: Data class1 ; Do I=1 to 3 ; Set sashelp.class; End; Run; proc print; run; Output code 1:   Output code 2:        ... View more

data s2; retain sum; assign = sum; sum + 1; proc print; run;       *Anyone knows why here:* assign=. whereas sum=1 because when we apply the + operator with any missing value the final result should be. (missing) ... View more

I am unable to resolve the value of %let project_path in %include statement:   SAS code: %let project_path = %str(E:/Murli/Project); %put %str(&project_path); %include "&project_path/Utils/Macro/connect2mssql.sas"   log: ERROR: Cannot open %INCLUDE file CONNECTION. 812 %include "&project_path/Utils/Macro/connect2mssql.sas" ... View more

I am trying to connect MSSQL Server with SAS using the following:   1. SQL Pass-Through, or explicit pass-through 2. LIBNAME statement, or implicit pass-through   But I am unable to make a connection between them.   Here are my MSSQl details (I am trying to do this using Windows authentication)     Can anyone help with the complete code I can use in my SAS EG to connect SAS with MSSQL?   -Vijay ... View more

Hi All,   I am looking for a solution to this problem using Datastep. Using SAS transform have dataset to want dataset. Output all observations with maximum price by item (do not remove duplicates).   have: id item price 1 Apple 98 1 Apple 99 1 Apple 100 1 Apple 100 2 Banana 30 2 Banana 45 2 Banana 48 3 Orange 76 3 Orange 78 3 Orange 78 3 Orange 83 3 Orange 83   want: id item price 1 Apple 100 1 Apple 100 2 Banana 48 3 Orange 83 3 Orange 83   Dataset code:   Data have; input id item $ price; datalines; 1 Apple 98 1 Apple 99 1 Apple 100 1 Apple 100 2 Banana 30 2 Banana 45 2 Banana 48 3 Orange 76 3 Orange 78 3 Orange 78 3 Orange 83 3 Orange 83 ; run; proc print; run;     Solution using:   PROC SQL:   proc sql; create table want as select * from have as a where id in ( select id from have as b group by id having max(b.price) = a.price ); quit; proc print; run;     I am looking for a solution using Datastep.   ... View more

Hello SAS Community, I am currently facing an issue with the Bitwise NOT (BNOT) function in my SAS code. Instead of producing the expected inverse of 1 or 0, the function is returning random numbers in the result window.   I have tried using the BNOT function on binary values 1 and 0, but the output is not as expected. Has anyone encountered a similar problem or have any insights into what might be causing this issue?   Any help or suggestions would be greatly appreciated. Thank you in advance for your assistance!   data Logical_Input; input x y; datalines; 0 0 0 1 1 0 1 1 ; run; OPTION VALIDVARNAME=ANY; data Logical_operation_table; set Logical_Input; "x and y"n = BAND(x,y); "x or y"n = BOR(x,y); "x xor y"n = BXOR(x,y); "not x"n = BNOT(x); run; proc print noobs; run;   Output: x y x and y x or y x xor y not x             0 0 0 0 0 4294967295 0 1 0 1 1 4294967295 1 0 0 1 1 4294967294 1 1 1 1 0 4294967294   Best regards, Vijay ... View more