About ari2495

ari2495 · ‎09-11-2023

Actually, i've just tried and unfortunately fuzz option did not work. i'll try criterion method options, thanks

ari2495 · ‎09-11-2023

thank you, but neither the fuzz option worked. for the variables name, the difference was simply capital letter vs lower letter, and i solved it by formatting all variable names to capital letters

ari2495 · ‎09-11-2023

after running the proc compare statement, i identified the variables which are supposed to have unequal values; then, i appended them through a left join and i applied a filter through a where statement to display cases where variable 1 is not equal no variable 2 and i found that these values were the same. Yes, i sorted the two datasets using a sort statement by all variables, so i'm thinking that i could try to format the values also because when i displayed the summary of the compare statement i found out that the maximum difference was 4.191E-09

ari2495 · ‎09-11-2023

hi, i'm using a proc compare. Code below: proc compare base=db1 compare=db2 printall; title "title of compare"; run; i got a code error, here is the log: WARNING: Values of the following 24 variables compare unequal: variable names WARNING: The data sets db1 and db2 contain unequal values. i have manually checked some of the values, and it is not true that they are unequal, so i suppose there is a problem. Actually, i have detected a problem with variable names, some were lower case and some other were uppercase so i turned everything uppercase but it did not worked, the log goes on saying some variables are unequal. i have also checked the columns order, they are exactly equal. What could I check to solve the problem? thanks a lot

ari2495 · ‎09-04-2023

Thank you for being so helpful, i'm sorry for not being compliant to the community rules. I apologize

ari2495 · ‎09-04-2023

%macro check; data check_esp_2; set Base; %do i=1 %to 57; if var(i)>var(i-1) then flag=1 else flag=0; %end; run; %mend; %check;

ari2495 · ‎08-07-2023

Yes, i've just run, and i found out the format is "best". Can you suggest me what to do? thanks and excuse me, i'm a new user

ari2495 · ‎08-07-2023

Hi, I used commax format to format some numeric variables. Nevertheless, running the code I got an error: "character expression requires character format" proc sql; create table table as select variable1, variable2 format commax22.2 from source; quit; I'm sure variable 2 is numeric, why do I get the error? thanks anyone for help

ari2495 · ‎08-03-2023

DATA name_&AAMM..nom; SET input; where var=1; RUN; Hi, this code above does not work. I suspect the problem is with the & somewhere. Can you help?

ari2495 · ‎07-10-2023

data Db_1; set Db; by variable_order; if first.variable=1 then amount=0; amount+balance; if last.variable=1 then output; run; Hi, on the code as above i can't understand the use of first and last. Are they simply libraries or have they a specific function?

ari2495 · ‎07-10-2023

HI, i'm trying to understand a code, i found the following: data Db_1; set db; variable= variable*(-1) ; run; what could be the reason? i can't understand this data step

ari2495 · ‎06-28-2023

Hi, i'd like to ask if someone knows which one is Kolmogorov-Smirnov among the statistics provided by the auc. thank you! here is the list: N _GAMMA_ E_GAMMA L_GAMMA U_GAMMA _KENTB_ E_KENTB L_KENTB U_KENTB _STUTC_ E_STUTC L_STUTC U_STUTC _SMDCR_ E_SMDCR L_SMDCR U_SMDCR _SMDRC_ E_SMDRC L_SMDRC U_SMDRC _PCORR_ E_PCORR L_PCORR U_PCORR _SCORR_ E_SCORR L_SCORR U_SCORR _LAMCR_ E_LAMCR L_LAMCR U_LAMCR _LAMRC_ E_LAMRC L_LAMRC U_LAMRC _LAMDAS_ E_LAMDAS L_LAMDAS U_LAMDAS _UCR_ E_UCR L_UCR U_UCR _URC_ E_URC L_URC U_URC _U_ E_U L_U U_U

ari2495 · ‎06-28-2023

Hi everybody, what i mean is I have two dataset which are named the same with the difference of a number, can i use %let so that the code runs the two dataset? %let number=xx; data= DB&number; set DBinput; run; would this work? is it correct? thanks for support

ari2495 · ‎06-07-2023

proc import datafile='\\svm-sas-server\folder\name.xlsx' out=namefile dbms=xlsx replace; sheet=namefile; run; Hi guys, this is a kind of import i've never seen. Could you help me understanding where the file come from? i mean, what is the svm-sas-server?

ari2495 · ‎11-29-2022

I really have to thank you all for all Your answers; I detected that the problem was with the last “then do”; simply eliminating it the code worked well again. Many thanks!

Online Status	Offline
Date Last Visited	‎09-12-2023 08:32 AM

Re: Proc compare

Re: Proc compare

Re: Proc compare

Proc compare

Re: Hi, can you help me detect the error in this macro? thank you

Hi, can you help me detect the error in this macro? thank you

Re: commax format error

commax format error

How can I solve the log error?

Understanding a data step

Re: Hi, can you help me detect the error in this macro? thank you

Re: commax format error

Re: commax format error

Re: commax format error

Re: Understanding a data step

Re: can you detect errors in this code? i do not know what does not wo...

Re: Proc compare

Re: Proc compare

Re: Proc compare

Proc compare

Re: Hi, can you help me detect the error in this macro? thank you

Hi, can you help me detect the error in this macro? thank you

Re: commax format error

commax format error

How can I solve the log error?

Understanding a data step

multiplying a variable for -1

Identification of Kolmogorov-Smirnov metric within the metrics of GAUC

Can %let statement be used to substitute just a part of a word?

svm-sas-server

Re: can you detect errors in this code? i do not know what does not wo...