Hi In processing a data step, is there a way to indicate the first record in an overall data set? I know using 'first' works to indicate the first grouping of a certain combination of variables, but I am wondering about the entire data set. Paul ... View more

Hi When you are merging two SAS data sets where both have one or more of the same column (and not used in the 'by' statement: in below example 'age'), which data set's value is retained as the value in the final, merged data set? Example: group1: ID      name     age     startdate group2: ID     age     salary data group3; merge group1 group2; by ID; run; ... View more

Hi I have two data sets that come from the same code, but run at two different points in time. One of the variables, Jur2006, has more 2000 observations marked as 'true' in the prior run than the current run. I would expect a few hundred different, but 2000 is too many. To see what the difference is relative to the observations, I would like to compare the two data sets and identify the observations marked as 'true' in the prior run, but no longer marked as 'true' in the current run and output those observations in a 3rd data set. Is there a way to do this with PROC COMPARE or using a simple merge (which I am trying)? Paul ... View more

Hi I would like to export a SAS data set keeping it in SAS format (sas7bdat). I have tried variations of PROC EXPORT below and none seem to work. Has anyone used the CPORT proc for this? Paul proc export data=work.surrenderTprCount    outfile='F:\MetricFiles\9_2013' DBMS=sas       replace; run; ... View more

Hi I have trying to merge two data sets as indicated below. For the variable I am looking for merge (CohortYearTotalAge), the merge is merging the value for the first record in the sort, but not the remaining. Anyone see anything by any chance? I tried it several ways. Paul 1st data set: proc sort data=surrenderTprCount2; by County Year AgeRange Filing; run; 2nd data set: proc sort data=s1Permanency1c; by County Year AgeRange Filing; run; Merge: data s1Permanency2; merge s1Permanency1c surrenderTprCount2; by County Year AgeRange Filing; run; Part of the result: County Year AgeRange Filing Exit ExitMonthCategory CohortYearTotal CohortYearTotalAge DistributiveNumber CumulativeNumber 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 0 12188 157 0 0 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 0.5 12188 4632 1 1 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 1 12188 4632 0 1 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 2 12188 4632 0 1 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 3 12188 4632 1 2 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 4 12188 4632 3 5 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 5 12188 4632 2 7 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 6 12188 4632 4 11 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 12 12188 4632 10 21 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 18 12188 4632 26 47 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 24 12188 4632 23 70 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 30 12188 4632 26 96 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 36 12188 4632 18 114 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 42 12188 4632 15 129 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 48 12188 4632 8 137 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 54 12188 4632 5 142 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 60 12188 4632 4 146 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 66 12188 4632 1 147 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 72 12188 4632 4 151 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 78 12188 4632 1 152 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 84 12188 4632 0 152 1 - New York State 2006 1 - 0 to 3 2 - AS Filed, No TPR All 87 12188 4632 1 153 ... View more