Thanks, I appreciate your time answering this. Regards ... View more

Hi, Thanks for the reply, The code was not working on my computer, until I added ELSE as you mentioned. Great advice, Keep the great work and have a good week-end, ... View more

Thanks, the ?? removed the error messages as you said ... View more

Thanks again,    I'm done with one variable, one more to go,   the other variable  has character values that I want to convert to categories, it should be straight forward:   Here is what I tried,   IF Fumeacutellementadmission = 'Jamais' THEN SMOKING = 0 ; IF Fumeacutellementadmission = 'Dans passe' THEN SMOKING = 1 ; IF Fumeacutellementadmission = 'Presentemen' THEN SMOKING = 2 ; IF Fumeacutellementadmission = 'Chaque jour' THEN SMOKING = 2 ; IF Fumeacutellementadmission = 'Inconnu' THEN SMOKING = . ; IF Fumeacutellementadmission = . THEN SMOKING = . ;   Thanks ... View more

I just realized that it worked for this variable, even with the presence of errors messages. Thanks, ... View more

Also , what about the other variable, this one has character values that I want to convert to categories, it should be straight forward:   Here is what I tried,   IF Fumeacutellementadmission = 'Jamais' THEN SMOKING = 0 ; IF Fumeacutellementadmission = 'Dans passe' THEN SMOKING = 1 ; IF Fumeacutellementadmission = 'Presentemen' THEN SMOKING = 2 ; IF Fumeacutellementadmission = 'Chaque jour' THEN SMOKING = 2 ; IF Fumeacutellementadmission = 'Inconnu' THEN SMOKING = . ; IF Fumeacutellementadmission = . THEN SMOKING = . ;   Thanks ... View more

Hello,   Thanks for the reply,   I tried it but it did not work (problem with INPUT) . I find it weird. here is the log.   407 DATA EXMED_test2; 408 set exmed_test1 (rename=(distancetestmarche6minfinprogram=_d)); 409 distancetestmarche6minfinprogram=input(compress(_d,'kd'),12.); 410 run; NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Dans passe ID=2 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=2 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=n/a Fumeacutellementadmission=Jamais ID=16 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=16 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Dans passe ID=85 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=85 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Dans passe ID=92 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=92 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Jamais ID=116 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=116 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Jamais ID=133 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=133 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Dans passe ID=141 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=141 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Jamais ID=155 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=155 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Jamais ID=159 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=159 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Presentemen ID=161 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=161 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Jamais ID=163 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=163 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Presentemen ID=165 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=165 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Unk Fumeacutellementadmission=Dans passe ID=172 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=172 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Dans passe ID=180 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=180 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Jamais ID=189 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=189 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Dans passe ID=190 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=190 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Dans passe ID=193 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=193 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=Inc Fumeacutellementadmission=Presentemen ID=194 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=194 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. _d=n/a Fumeacutellementadmission=Jamais ID=196 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=196 NOTE: Invalid argument to function INPUT at ligne 409 colonne 36. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. _d=Inc Fumeacutellementadmission=Jamais ID=205 distancetestmarche6minfinprogram=. _ERROR_=1 _N_=205 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 54 dans 409:36 NOTE: There were 410 observations read from the data set WORK.EXMED_TEST1. NOTE: The data set WORK.EXMED_TEST2 has 410 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds   ... View more

I was wondering, does this blog allow sharing SAS data files or no? I was unable to do so, it said contents of file does not correspond with the name!? ... View more

https://liveumoncton-my.sharepoint.com/personal/pse2915_umoncton_ca/_layouts/15/guestaccess.aspx?docid=1d62a060b99a04863ab8db96a0038fe2e&authkey=AaTF79pYDzTtp1K5hvKjRWY ... View more

The attachement is not working, I uploaded a onedrive link. It's from my university account (secured) ... View more

The attachement is not working, I uploaded a onedrive link. It's from my university account (secured) ... View more

https://liveumoncton-my.sharepoint.com/personal/pse2915_umoncton_ca/_layouts/15/guestaccess.aspx?docid=1d62a060b99a04863ab8db96a0038fe2e&authkey=AaTF79pYDzTtp1K5hvKjRWY ... View more

Sorry for that, I was trying several variables. It gives me the same error message 391 proc freq data=EXMED_NOTMULTI_3; 392 tables TADdebutvisite1; 393 where TADdebutvisite1 > ' ' and input(TADdebutvisite1, ??8.) = . ; - 22 200 ERROR: Erreur de syntaxe détectée lors de l'analyse de la clause WHERE. ERROR 22-322: Expecting un nom de format. ERROR 200-322: The symbol is not recognized and will be ignored. 394 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

Hi,   Hi,   Thanks for the reply,  I tried compress before, it worked for another variables but not the ones with 5 character values, it said (error too many arguments)   I'm uploading a tata file with the two variables that need to be reformatted.   Thanks,     ... View more