08-23-2014 10:45 AM
I am using SAS 9.0 For windows, but it seems as if this version does not support DUPOUT for proc sort. I am using code-
PROC SORT DATA = test nodup dupout = temp ;
so what I want is to have a dataset with a duplicate row using DUPOUT. But I get syntax error :
ERROR 76-322: Syntax error, statement will be ignored.
08-23-2014 10:58 AM
WOW, SASA9.0 I can't believe there were still SAS9.0 exist in somewhere of the world . That was almost released at 1990 .
You can't use dupout= option with SAS9.0, but you can code it to accomplish your task .
data single dupout;
if first.group then output single ;
else output dupout;
08-23-2014 11:10 AM
It did already exist in V8 1566 - Why duplicate observations occur when using the NODUP SORT option
Please show your screenshots. Really 9.0? that is almost as old as V8.2. Time to upgrade.
08-23-2014 11:24 AM
Not to be picky but, according to the documentation ( http://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/whatsnew_10878.pdf ), dupout wasn't introduced until 9.1
08-23-2014 11:39 AM
Very well indeed Arthur. This one is for you.
I could not find it. But I was also not remembering when that dupout became an option, getting old, sometimes my memory is lacking or too slow.
08-24-2014 08:11 AM
Don't be shame of it ,Jaap. SAS is so huge, you can't remember every details of it , and further more , SAS add lots of function proc option in every SAS version release .That is why we need keep learning -> remember -> forgotten ->re-remember -> forgotten again ...... It is revolution .