Here's the documentation explaining the default data type translations:   http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#n0h4i25zq3t58en1lgr8jjx1rads.htm   What is the mismatch you are getting?   ... View more

If you have network shares set up for both your source and target servers, using Windows Explorer to copy and paste the required data folders is probably the simplest approach. ... View more

See the SAS Usage Note about interpolation. For a more mathematical treatment, see the article "Linear interpolation in SAS", which also provides links to other SAS techniques. ... View more

If you don't want x_16 why are you including it in the array declaration?    Add an IF Condition, such that if there is no value then it doesn't try and get the variable name.    If index ne 0 then variable_name = ...;     ... View more

Can you post your real data in TEXT file or Data Step Code? And don't forget post the output either . ... View more

@akhilesh_joshi That's why it's so important that you post sample data and then explain us how the desired result needs to look like.   Here you go: data have; length xyz $32; do xyz='xyz_1','xYz_2','xyz_16','xyz_17','abc_1','xyz','xyz_1_abc','xyz_abc_1','xyz'; output; end; run; data want; set have; if upcase(scan(xyz,1,'_'))='XYZ' and ( 1 <= input(substrn(xyz,findc(xyz,'_')+1),?? f12.) <= 16 ); ; run;   ... View more

data want; set have; _var = input(substr(var,3),best.); if 6 <= _var <= 16; drop _var; run; ... View more

Hi Ballardw,   Thank you for your reply.    I wil try to be more concise and would avoid duplicate posts.   I already have x_1 and x_16. Currently, the program creates columns x_2 to x_15 in output data created after I run the program. Instead, I want to declare a variable say x_(number) where I can input a number of my choice say (10) to have columns only from that number(x_10) to x_16. y is X_16 - X_1.   so instead of x_1 I want to output to start from x_(number) so that x_(number) is my new x_1.   I create x_2 to x_15 currently by using    x_2 = x_1 + ((1)/15)*y); x_3 = x_1 + ((2/15)*y); . . x_15 = x_1 + ((14/15)*y);   I include them in output data using  DATA = name_of_data (KEEP = x_1 x_16 x_2 x_3 x_4 x_5 x_6 x_7 x_8 x_9 x_10 x_11 x_12 x_13 x_14 x_15)             ... View more

Which is why we suggest providing example input and output. ... View more