does the dataset cont_hist1 also contain the variable first_prin_bal, and with values missing for these 3 loan_no? ... View more

thank you very much Cynthia -- I will try it and let you know how it works for me! ... View more

well, i believe that although it may seem to have no harm in this simple code, it will bomb sooner or later ... it is always safe to precede the comment with a %, my hard-learned lesson! ... View more

seems that your code is from a macro. if so, any comment MUST be started with a %, e.g. %******Check the singularity of status values for all partition datasets********; very likely this is what your SAS is complaining about. ... View more

there are a variety of tedious but possible ways to read in such abnormally presented data, but my gut feeling is that you will be much better off if you can clean up the data from your source Excel spreadsheet to eliminate this kind of abnormality. ... View more

%eval is confused by one macro variable &m and one SAS dataset variable i. the easiest way out is not to use %eval: %let j=&m+i; ... View more

this is a quite unique request that all fields need to be replicated. I can not think of any one-step way to achieve that. 1. sort the data and assign a unique ID to each records within a cell_code. 2. output to 2 separate datasets with this ID and change variable names. 3. merge the 2 new datasets using proc sql, with value of original cell_code. or if you need to really 'concatenate' those fields, you may first concatenate all 4 fields first and then do transpose to this one concatenated field. if this is what you wanted then it's an easier way out. ... View more

I think you may drop the width= statement for most of the variables, maybe only keep for those columns that you specifically need a width. ... View more

it must be that your column 1 was defined as char, not likely only because of the negative sign. use a new variable to transform it to numeric: column3=input(column1, best.) ... View more

what is format F? ... View more

I dont think you can achieve that within one data-input-cards-... step for this purpose. use proc sql insert into and order. this should do both inserting and sorting in one step systematically. ... View more

proc print data=all label; label GBUSED="&sysdate"; run; ... View more

have you tried do while ('tail condition') loop? ... View more