What is P drive? Is that a shared drive ... View more

data temp; input Year WeekNo SalesRepID Region Amount; cards; 2012 1 001 1 100 2012 1 002 1 200 2012 1 003 1 300 2012 2 001 1 400 2012 2 003 1 500 ;run; proc print; run; data temp1; set temp; LastWeekAmount = lag(Amount); LastWeekAmount1 = lag(LastWeekAmount); run; proc print; run; proc sql; select sum(LastWeekAmount1) from temp1; quit; Output for temp1:                                                        Last       Last                             Week    Sales                         Week       Week              Obs    Year     No     RepID    Region    Amount    Amount    Amount1               1     2012      1       1         1        100         .         .               2     2012      1       2         1        200       100         .               3     2012      1       3         1        300       200       100               4     2012      2       1         1        400       300       200               5     2012      2       3         1        500       400       300                                         Sum:                                             ƒƒƒƒƒƒƒƒ                                                  600 ... View more

Here is another exmple that might help you data want; input grp $ deal $ first $; cards; FVJK TEST1 1 FVJK TEST2 1 FVJK TEST1 1 FVJK TEST3 1 FRGH TEST3 2 FRGH TEST3 2 FRGH TEST5 2 FRGH TEST6 2 run; proc freq data = want; tables grp*deal*first / list missing norow nocol nopercent nocum out=temp; run; data temp1; set temp; by grp; grp=ifc(first.grp,grp,' '); run; proc print; run; PROC EXPORT DATA= work.temp1             OUTFILE= "C:Test.xls"             DBMS=EXCEL REPLACE;      SHEET="T"; RUN;                       Obs    grp       deal     first    COUNT    PERCENT                         1     FRGH    TEST3      2        2        25.0                         2                  TEST5      2        1        12.5                         3                  TEST6      2        1        12.5                         4     FVJK    TEST1      1        2        25.0                         5                 TEST2      1        1        12.5                         6                 TEST3      1        1        12.5 ... View more

data have; input (id Name Gender Date) (:$10.); cards; 1           Dan              M                1/1/2012 1           Dan              M               12/23/2011 1           Dan              M               10/15/2011 1           Dan              M                9/17/2011 2           Carol            F                 8/12/2011 2           Carol            F                 7/15/2011 ; run; data want; set have; by id; name=ifc(first.id,name,' '); gender=ifc(first.id,gender,' '); run; proc freq data = want; tables id*name*gender / list missing norow nocol nopercent nocum out=temp; run; libname test 'c:\temp\test.xls'; proc sql; drop table test.sheet1; quit; data test.sheet1; set temp; run; libname test clear; ... View more

PROC IMPORT OUT= TEST             DATAFILE= "C:\Documents and Settings\Test.xls"             DBMS=excel REPLACE;    SHEET="Sheet1"; RUN; PROC IMPORT OUT= TEST1             DATAFILE= "C:\Documents and Settings\Test.xls"             DBMS=excel REPLACE;    SHEET="Sheet2"; RUN; Log: 32 PROC IMPORT OUT= TEST 33 DATAFILE= "C:\Documents and Settings\nbk8gia\My Documents\My SAS 33 ! Files\Test.xls" 34 DBMS=excel REPLACE; 35 SHEET="Sheet1"; 36 RUN; NOTE: WORK.TEST data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 3.06 seconds cpu time 0.79 seconds 37 38 PROC IMPORT OUT= TEST1 39 DATAFILE= "C:\Documents and Settings\nbk8gia\My Documents\My SAS 39 ! Files\Test.xls" 40 DBMS=excel REPLACE; 41 SHEET="Sheet2"; 42 RUN; NOTE: WORK.TEST1 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 3.18 seconds cpu time 0.84 seconds ... View more

rsubmit; x 'man ls > /etl//have.txt'; endrsubmit; ... View more

http://www.albany.edu/~msz03/epi514/notes/p121_142.pdf ... View more

data have; input  bday mmddyy8.; format bday mmddyy8.; cards; 11/12/87 12/04/56 03/06/79 04/05/94 03/07/99 03/07/99 ; run; data want; set have; age_days = today() - bday; run; proc print; run; Output:                                  Obs        bday    age_days                                    1     11/12/87       8890                                    2     12/04/56      20190                                    3     03/06/79      12063                                    4     04/05/94       6554                                    5     03/07/99       4757                                    6     03/07/99       4757 ... View more

filename tranfile ftp 'tport.dat' lrecl=80 blocksize=8000   recfm=f cd='mydir' host='myhost.mycompany.com'   user='myuser' pass='mypass'   rcmd='site umask 022 recfm=s'; http://support.sas.com/documentation/cdl/en/movefile/59598/HTML/default/viewer.htm#a001021283.htm ... View more

Is this what you are looking for? data test; input Roll_number Dob $8. Salary experience; cards; 1 11/12/87 2500 2 5 12/04/56 3400 3 3 03/06/79 1200 4 2 04/05/94 44560 4 4 03/07/99 12908 3 6 03/07/99 12908 7 ; run; data test1; set test; if _n_  ge 3 then output; run; proc print; run; Output:                      The SAS System        15:17 Tuesday, March 13, 2012   1                                Roll_                        Obs    number      Dob       Salary    experience                         1        3      03/06/79      1200         4                         2        2      04/05/94     44560         4                         3        4      03/07/99     12908         3                         4        6      03/07/99     12908         7 ... View more