Thanks. This solution worked for me. ... View more

This is an example, this divides a 20 obs data set into .7-.3 proportions:   /*The following steps will allow you to divide data into multiple Random subsets with a give proportion*/ data hello; do i= 1 to 20; output; end; run; proc surveyselect data=hello out=chao method=srs samprate=.7 outall noprint; run; /*this steps creates a new variable named "Selected" which can be referenced later on*/ data train; set chao; if selected = 1; drop selected; run; data valid; set chao; if selected = 0; drop selected; run; proc print data=train; run; proc print data=valid; run; ... View more

I don't think this is the correct answer. That will not extract first 4 values. rather then it will give you blank value. the one way which I can think off. we can use it as below. data one; val=1234567; val1=substr(left(val),1,4); run;     ... View more

Then 'a' variable is what you are looking for ? ... View more

Hi there, I am trying to do the same thing as this user -- do a linear interpolation.  However my data are semi-annual and I want to go to a monthly frequency.  I have three reported periods: Dec. 2014, June 2015 and Dec. 2015 with the remaining months in between to be generated.  I have attached a screenshot of the data.       I tried modifying code in this thread but no luck.     I am new to this so any help greatly appreciated.   Thanks Jack ... View more