I know that it is simple to find the primary key of a dataset but it is not so simple to find the good keys between two datasets for which we have little information.   regards     ... View more

Good evening,   You have a very good point regarding the use of a missing variable. My client is asking me to develop algorithms either to extract data or to perform calculations.   Our dataset are relatively large and we don't know at the begining that in a certain dataset, for a particular variable, all the value are missing.   I have recently experiment this procedure to initialize missing value to zero without have to name all the variables, but it sound it not appropriate when all the values are missing.   Regards,   Alain   ... View more

Thanks for responding to my question.   I have test your code and it works but if a drop a variable I will not be able to set the missing value to zero.   Regards, Alain ... View more

Good evening,   I have tested two different codes and when all the values of a variable are missing, we get the warning message.   data have; infile datalines delimiter=','; input A B C; datalines; 1, ,3 3, ,4 3, ,5 ., ,7 2, ,3 6, ,. .,1 ,2 ; run; proc stdize data=have reponly out=want missing=0; var _numeric_; run;   The following code is not working because all the values of B are missing; data have; infile datalines delimiter=','; input A B C; datalines; 1, ,3 3, ,4 3, ,5 ., ,7 2, ,3 6, ,. .,.,2 ; run; proc stdize data=have reponly out=want missing=0; var _numeric_; run; ... View more

I agree with both you. Thanks for refering to implicit conversion. ... View more

I agree with you that best12. is not the best format to choose.  I have change it to 3 Moreover, I have made some test with my data at home (using sas university edition)   First, my excel file contains the data from the sas dataset Data performance_AgentVente1.  I have exported this table using sas enterprises guide 7.1 into an excel file.   When I have read this file at home, I was unable to calculate the variable pointage using the proc format. Then I have open my excel file, I have deleted the column classement and I have made a new one named Rank I have entered manualy the data (1 2 3 1 2 3 and so on..) and I have save my excel file   After those actions, I was able to create the variable Pointage using the following code. It tells me that my sas table was either corrupted or the way the variable Classement was created is unapropriate. When I will come back tomorrow to the office, I will send you the piece of code I have been using to create the variable Classement. It could be that?   Thanks for your comments   /** Import an XLSX file. **/ PROC IMPORT DATAFILE="/folders/myshortcuts/Study1/classeur1.xlsx" OUT=WORK.MYEXCEL DBMS=XLSX REPLACE; RUN; /** Print the results. **/ proc format ; value PtPerfo 1=120 2=110 3=100 4=80 5=70 6=50 7=40 8=34 9=32 10=30 ; run; proc format ; value PtPerfoATO 1=120 2=60 3=30 ; run; Data Temp1 ; set work.myexcel ; Pointage=input(put(Rank, PtPerfoATO.), 3.); run; PROC PRINT DATA=WORK.Temp1; RUN;   ... View more

I have test the following code and it works:   proc format ; value PtPerfo 1=120 2=110 3=100 4=80 5=70 6=50 7=40 8=34 9=32 10=30 ; run; Data Temp; input Classement 8.; datalines; 1 2 3 4 5 6 7 8 9 10 ; run; Data Temp2; set Temp; Pointage=input(put(Classement,PtPerfo.),best12.); run;   But When I am using the following code it is not working.  I have no error message but it generate a new classement variable (empty) and pointage is empty also??  Any idea how to solve that?   Data performance_AgentVente3; set performance_AgentVente3; Pointage=input(put(Classement,PtPerfo.),best12.); run;   Performance_AgentVente3 look like:   ...Classement     Pointage    classement 1                            .                   . 2                            .                    . 3                             .                   .   and so on....         ... View more