input @1 var1 1. @3 var2 $1. @5 var3 $1. @7 var4 1. @9 var5 $1.;
1 Y A 7 Z
3 J A 6 T
2 E A 5 S
7 Z A 4 Q
4 Q B 3 J
6 T B 2 E
5 S B 1 Y
proc sort data=one out=one_s(drop=var4 var5);
by descending var1;
set one(keep=var4 var5);
Monday, September 22, 2008
SAS can also do the partial sorting like Excel does. Since SAS deals with observation as basic unit, subsetting and merging is necessary before a partial soring by Proc Sort.
As a formal statistician and a current engineer, I feel that a successful engineering project may require both the mathematician’s abilit...
ABSTRACT PROC SQL is not only one of the many SAS procedures and also a distinctive subsystem with all common features from SQL (Stru...
This is a following post after my previous post about SAS/SQL. SAS’s SQL procedure has a basic SQL syntax. I found that the most challe...
The Hadoop system has its unique shell language, which is called FS . Comparing with the common Bash shell within the Linux ecosystem, the...