Dear SAS community, I would like to add a SAS dataset to an existing SQL Server table.  I would like to add the SAS dateset "adding" to the sql table "have."  I have been using the below code. proc append base=SQLSERVER.have data=WORK.adding; run; However, when I run the code, I receive this error. NOTE: Appending WORK.adding to SQLSERVER.have. WARNING: Variable X1 was not found on DATA file. WARNING: Variable X2 was not found on DATA file. WARNING: Variable X3 was not found on DATA file. NOTE: There were 1 observations read from the data set WORK.adding. NOTE: 0 observations added. NOTE: The data set SQLSERVER.have  has . observations and 44 variables. ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit        value for identity column in table 'have' when IDENTITY_INSERT is set to OFF. NOTE: Statements not processed because of errors oted above. I believe the errors are a result of two reasons. 1) I have variables (i.e. variables X1, X2, X3) in the SQL table that are not in the SAS dataset 2) I have one variable (i.e. variable X4) in the SQL table that is in a different format as that same variable in the SAS dataset Is there a way to force the append without adding variables to the SAS dataset? And without changing the format of the variable shared by both sources? Thanks! ... View more

Hi SAS Users, I have the following sample dataset with 3 variables: ID m_start and m_end where m_start and m_end correspond to months in a year (e.g. m_start =1 is January and m_end=12 is December; m_start=2 is February and m_end=5 is May). data have; ID m_start m_end 1   1          3 2   5          8 3   7          12   I would like to create 12 new variables: new_m1-new_m12 that counts the months from m_start to m_end.  So my new dataset would resemble the below data set. data want; ID m_start m_end new_m1 new_m2 new_m3 new_m4 new_m5 new_m6 new_m7 new_m8 new_m9 new_m10 new_m11 new_m12; 1   1          3           1          1            1          .               .               .          .          .               .               .          .          . 2   5          12          .           .            .           .              1              1          1          1             1               1          1         1   3   7          12         .            .           .            .               .               .          1          1             1               1          1          1 Thanks! ... View more

Hi SAS Users, I have a question regarding how to set-up a sum function based on the dataset below. I think I need to use an array as well, but I am not certain. If you could offer some input, that'd be great. My objective is to sum up the number of days the student is enrolled (aka "sum_enroll") using variables "enroll_start" to "enroll_end" to determine the start and end points for summing. I have included a description of the variables along with the desired dataset including the new variable "sum_enroll". Thank you! ID               = student enroll_start  = day student was enrolled enroll_end    = last day student was enrolled day1-day10  = a binary variable (1, 0) indicated if they were in attendance on that day sum_enroll   = sum of the number of days the student is enrolled Note:  Variables enroll_start and enroll_end do not necessarily match up the with the first "1" and the last "1" value written for variables day1-day10. data want; input  ID   enroll_start enroll_end sum_enroll day1 day2 day3 day4 day5 day6 day7 day8 day9 day10;          AA  day1          day10         10             1      1       1      1      1       1     1      1      1       1          BB  day1          day 7            4             1      0       0      0      1       1     1      0      1       0          CC  day4          day8             5             0      1       1      1      1      1      1       1      1      1          DD   day5         day8             3             0      0       0      1      1       1     1       0      1      0          EE   day3         day10            8            0      0       1      1      1       1     1      1       1      1          FF   day1         day7              3             0      0       0      0      1       1      1      0       0      0 ;; ... View more