I have a data set which looks like this:                     ID TIME CMT Y1 Y2 CP1 CP2 DV MDVX COUNT 1.00E+00 0.00E+00 1.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 1.00E+00 1.00E+00   Whenever the variable count changes the data looks like this with a row of literals (i.e., row 2 below) redefining the columns. 1.40E+01 2.40E+01 2.40E+01 2.30E+00 1.90E-02 9.18E-01 2.00E-02 0.00E+00 0.00E+00 1.00E+00 3.02E+03 2.09E+02 1.54E+03 1.66E+01 1.03E+02 1.11E+00 1.58E+02 3.45E+00 1.21E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 1.21E+00 0.00E+00 0.00E+00 ID TIME CMT Y1 Y2 CP1 CP2 DV MDVX COUNT RHYD RHYL RMETD RMETL CDLV CLLV CVD CVL CPREDI CRESI CWRESI CRES CWRES DV PRED RES WRES 1.00E+00 0.00E+00 1.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 1.00E+00 2.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00 0.00E+00   When I run the following code:   data one;   infile '/folders/myfolders/partialAUC/run20fit.csv/' dsd dlm=',' truncover firstobs=2;   INPUT ID TIME CMT Y1 Y2 CP1 CP2 DV ?? MDVX ?? COUNT;   if ID='ID' then delete; run;   I get this error in the log:   NOTE: Invalid numeric data, 'ID' , at line 77 column 9. RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                       2         1.00E+00,0.00E+00,1.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,1.00E+00,1.00E+00,0.00E+00,0       101  .00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00,0.       201  00E+00,0.00E+00,0.00E+00,0.00E+00,0.00E+00 242 ID=1 TIME=0 CMT=1 Y1=0 Y2=0 CP1=0 CP2=0 DV=0 MDVX=1 COUNT=1 _ERROR_=1 _N_=1 NOTE: Invalid numeric data, 'ID' , at line 77 column 9.   This repeats several times. How can I edit my code to have the program either skip or not read the line with the  id  time cmt etc each time it appears whenever the count changes from n to n+1 etc? ... View more

If I have a data set A: ID   Ratio 1      5 .       5 10     5   Data set B: ID   Time  conc 1      0       0 .       1       0.5 24    24     0.01   The (.) means that there are several values for A that end at 10 while for B they end at 24.  The question is how can I introduce the constant ratio value 5 into data B from data A for all the rows in data set B? ... View more

If I have a character value called epspropl=45.5c and I convert it to a numeric by:  vepspropl=input (epspropl,8.);   My question is since it contains an alphabetic character c, is there a way to convert epspropl to a numeric and get rid of the unwanted c or do I have to do something else to get rid of the c? ... View more

I have the following proc survey code which I  used to bootstrap the attached data set(1).  There are actually 24 subjects that comprise the data set with each subject having the same amount of data (e.g.,12 time points,  CMT's 1-24 for each time etc). When I run the code I do get bootstrapped samples but all of the data for a subject is not included.  The data for subjects 1,2,3 and 5 is shown with only 1 line of data retained for each wsub in the bootstrapped output (2).  What I want is for all of the data for a wsub to be retained during bootstrapping not just one line.  How can I adjust my code to do that? proc import datafile='/folders/myfolders/bootstrapaptensio_PED/ngroupalla.csv' out=newB replace; getnames=yes; run; PROC SURVEYSELECT DATA=NEWB METHOD=SRS REP=2 N=24 SEED= 3495 OUT=SAMPLE; RUN; BOOTSTRAP OUTPUT (2)               Replic   wsub       time       dv        cmt        ……... 1 1 12 0 4 0 2 1 23 1 6 2 1 2 5 0 12 0 2 1 20 1 6 1 1 2 12 0 9 0 2 1 20 1 6 1 1 3 0 0 18 0 2 1 23 1 6 1 1 3 6 0 12 0 2 1 23 1 6 1 1 5 5 0 7 0 2 1 33 1 9 2 1 5 10 0 19 DATA SET (1)     WSUB TIME DV CMT AMT EVID MDV WEIGHT SEX AGE AGROUP                     1 0 0 1 30000000 1 1 23 1 6 2                     1 0 0 2 30000000 1 1 23 1 6 2                     1 0 0 3 0 2 1 23 1 6 2                     1 0 0 4 0 2 1 23 1 6 2                     1 0 0 5 0 2 1 23 1 6 2                     1 0 0 6 0 2 1 23 1 6 2                     1 0 0 7 0 2 1 23 1 6 2                     1 0 0 8 0 2 1 23 1 6 2                     1 0 0 9 0 2 1 23 1 6 2                     1 0 0 10 0 2 1 23 1 6             2                                                                                                                                                                                                                                                                                                                                                                                                                                                         ... View more

I have the following data: a                        b                       c nrename        test1.nm7      0test1.nm7 nrename        test2.nm7      1test2.nm7 nrename        test3.nm7       0test3.nm7   What type of keep statement do I need that will allow me to keep only those rows which contain 1testi.nm7? I plan to handle the i with a do loop but not sure how to keep a  character statement.   I saw a post that gave the statement ,if sym_suffix in ('A', ' '); When I tried  data new; SET NEWB; if prefix in (1, ' '); run; I get the following error.  What statement can I use to keep character data with the 1 prefix? 74 data new; 75 SET NEWB; 76 if prefix in (1, ' '); ERROR: All variables in array list must be the same type, i.e., all numeric or character. 77 run;         ... View more

I found this code for listing directories at:http://support.sas.com/kb/24/820.html filename DIRLIST pipe 'dir "C:\Documents and Settings" /s'; data dirlist ; length buffer $256 ; infile dirlist length=reclen ; input buffer $varying256. reclen ; run ; However I get the following error when I insert my path. I am using SAS UE so I am certain that I should have access to my folders. Can someone tell me why this occurs and how to overcome the issue? OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 74 filename DIRLIST pipe 'dir "folders/myfolders/aptensio_secalc/finalsas" /s'; ERROR: Insufficient authorization to access PIPE. ERROR: Error in the FILENAME statement. 75 76 data dirlist ; 77 length buffer $256 ; 78 79 infile dirlist length=reclen ; 80 81 input buffer $varying256. reclen ; 82 run ;   ERROR: No logical assign for filename DIRLIST. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.DIRLIST may be incomplete. When this step was stopped there were 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds     83     ... View more