after importing your csv file, try the code below: data temp; set sashelp.heart; n=ranuni(8); proc sort data=temp;   by n;   data training testing;    set temp nobs=nobs;    if _n_<=.7*nobs then output training;     else output testing;    run; ... View more

data have; do i=1 to 50; output;end; run; data want; set have; n=int((i-1)/5)+1; proc print;run; ... View more

data raw;    input stckcd 1. @3 date $7.+1return 2.; cards; 1 1995-01 1 1 1995-02 2 1 1995-03 3 1 1995-04 4 1 1995-05 5 1 1996-01 11 1 1996-02 22 1 1996-03 33 1 1996-04 44 2 1995-01 6 2 1995-02 7 2 1995-03 8 2 1995-04 9 2 1996-01 66 2 1996-02 77 2 1996-03 88 ; run; data raw1; set raw; year=year(mdy(input(scan(date,2),2.),1,input(scan(date,1),4.))); month=month(mdy(input(scan(date,2),2.),1,input(scan(date,1),4.))); run; proc print data=raw1;run;              Obs    stckcd     date      return    year    month                   1       1      1995-01       1      1995      1                   2       1      1995-02       2      1995      2                   3       1      1995-03       3      1995      3                   4       1      1995-04       4      1995      4                   5       1      1995-05       5      1995      5                   6       1      1996-01      11      1996      1                   7       1      1996-02      22      1996      2                   8       1      1996-03      33      1996      3                   9       1      1996-04      44      1996      4                  10       2      1995-01       6      1995      1                  11       2      1995-02       7      1995      2                  12       2      1995-03       8      1995      3                  13       2      1995-04       9      1995      4                  14       2      1996-01      66      1996      1                  15       2      1996-02      77      1996      2                  16       2      1996-03      88      1996      3 ... View more

Hi Mark, Below is an example using libname to create and read excel files. /* create excel file class.xls from dataset sashelp.class */ libname test "C:\TEMP\forum\class.xls";   data test.names;     set sashelp.class;   run; libname test clear; /* create sas dataset new_class from excel file class.xls */ libname ttt "C:\TEMP\forum\class.xls";    data new_class;      set ttt."names"n;   run; proc print;title &syslast;run; libname ttt clear; /* only import some cells of the excel file */ libname www "C:\TEMP\forum\class.xls" getnames=no;    data only_specific_cells;      set www."names$a8:c18"n;    run;    proc print;title &syslast;run; libname www clear; /* log file */ 46 47   /* create excel file class.xls from dataset sashelp.class */ 48   libname test "C:\TEMP\forum\class.xls"; NOTE: Libref TEST was successfully assigned as follows:       Engine:        EXCEL       Physical Name: C:\TEMP\forum\class.xls 49     data test.name; 50       set sashelp.class; 51     run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set TEST.name has 19 observations and 5 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds 52   libname test clear; NOTE: Libref TEST has been deassigned. 53 54   /* create sas dataset new_class from excel file class.xls */ 55   libname ttt "C:\TEMP\forum\class.xls"; NOTE: Libref TTT was successfully assigned as follows:       Engine:        EXCEL       Physical Name: C:\TEMP\forum\class.xls 56      data new_class; 57        set ttt."name"n; 58     run; NOTE: There were 19 observations read from the data set TTT.name. NOTE: The data set WORK.NEW_CLASS has 19 observations and 5 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds 59    proc print;title &syslast;run; NOTE: There were 19 observations read from the data set WORK.NEW_CLASS. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds 60   libname ttt clear; NOTE: Libref TTT has been deassigned. 61   /* only import some cells if the excel file */ 62   libname www "C:\TEMP\forum\class.xls" getnames=no; NOTE: Libref WWW was successfully assigned as follows:       Engine:        EXCEL       Physical Name: C:\TEMP\forum\class.xls 63      data only_specific_cells; 64        set www."name$a8:c18"n; 65      run; NOTE: There were 11 observations read from the data set WWW.'name$a8:c18'n. NOTE: The data set WORK.ONLY_SPECIFIC_CELLS has 11 observations and 3 variables. NOTE: DATA statement used (Total process time):       real time           0.01 seconds       cpu time            0.01 seconds 66      proc print;title &syslast;run; NOTE: There were 11 observations read from the data set WORK.ONLY_SPECIFIC_CELLS. NOTE: PROCEDURE PRINT used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds 67    libname www clear; NOTE: Libref WWW has been deassigned. ... View more