Hey Tom, Here is my actual code it may help you to understand..   /********* Importing Raw data ********************************************************/ proc import out = master datafile = "c:\temp\file.txt" dbms = dlm replace; delimiter=';'; getnames = no; run; Data want( rename= (Var1=Client_Number Var2=Report_Number Var3=PI Var4=SP Var5=Plan  Var6=NP Var7=Sales Var8=RBS Var9=PG  Var10=Fe Var12=Prescriber Var13= First_Name Var14=Middle_Initial Var15=Address Var16=City Var17=ST Var18=Zip Var19=NP Var20=Pay Var21=DD Var22=Data_Date Var23=Maximum_Number_of_Buckets   Var24=NRx_10_07_2016 Var25=NRx_09_30_2016 Var26=NRx_09_23_2016 Var27=NRx_09_16_2016 Var28=NRx_09_09_2016  Var29=NRx_09_02_2016 Var30=NRx_08_31_2016 Var31=NRx_08_26_2016 Var32=NRx_08_19_2016 Var33=NRx_08_12_2016   .. ... ..... .............. Var150=NRx_10_03_2014 Var151=NRx_09_30_2014   /* same values for TRx now */ Var152=TRx_10_07_2016 Var153=TRx_09_30_2016 Var154=TRx_09_23_2016 Var155=TRx_09_16_2016 ........ .......... ........... Var278=TRx_10_03_2014 Var279=TRx_09_30_2014   /* same values for Nqty now */ Var280=Nqty_10_07_2016 Var281=Nqty_09_30_2016 ....... .......... .......... Var406=Nqty_10_03_2014 Var407=Nqty_09_30_2014   /* same values for Tqty now */ Var408=Tqty_10_07_2016 Var409=Tqty_09_30_2016 Var410=Tqty_09_23_2016 .......................... ............... ............. Var533=Tqty_10_10_2014 Var534=Tqty_10_03_2014 Var535=Tqty_09_30_2014 ) );   set master; run;     now I want to reduce my efforts becoze when I receive file the date of var22 will be diff now and according to that date  I have maintain data for 24 months going backwards 7 days the same logic, that's why I need to rename my vars every time when I get the file from client.   Please help me in here I hope I have made myself clear now.   Thanks   ... View more

Hi Tom, I really apriciate your intrest into this so here are the answers of your questions   Does that extend to the end of the line? yes from  24 to 535 vars set of three group of vars var24 to var151 and var152 to v279 and (next two set of 127 vars in each ).....till 535 What do the first 21 columns contain?  these are Client_Number,Report_Number,Prescriber_ID.. etc.... and these are fixed so I can easly rename this and they never change in any file we receive from client.   What does column 23 contain? Maximum_Number_of_Buckets   so data structure is something like var1 to var23 constant var names and from var24 to var 535 each of 127 set of vars  will have date values like I said going back 7 days from start date(var22) and if next month then end of month.   hope this will help   thanks!   ... View more

Hi Shmuel, I am trying to run your code and the result I am getting is like this var24 = v_10/13/2016 var24 = v_10/06/2016 var24 = v_09/30/2016 var24 = v_09/23/2016......   but if you see var24 is costant and date should be in underscore separated not by '/'; so desired output should be like this var24 = v_10_13_2016 var25 = v_10_06_2016 var26 = v_09_30_2016 var27 = v_09_23_2016....   Please help me in here.   Thanks ... View more

Thanks Shmuel, this is what I was looking towards, I am working on your code to make it work for me for all rest of the vars.   your help highly appreciated.   ... View more

So here is what i do everyday.   Firrt run Proc Import and get the text file in SAS.   Proc import datafile="File.txt" out=mydataset dbms=dlm replace; delimiter=";"; getnames=no; run;   Data want; set mydataset(rename= ( ar24=V_10_13_2016 Var25=V_10_06_2016 Var26=V_09_30_2016 Var27=V_09_23_2016 Var28=V_09_16_2016 Var27=V_09_09_2016 /*for all 500 vars */) run;   now want data is ready for me to work.   So I was trying to create a macro so that I can replace that I can call my macro rename=(%mymacro);   Please help me in here.   Thanks!   ... View more

1- In a DATA step, if the SCAN function returns a value to a variable that has not yet been given a length, then that variable is given a length of 200 characters. If you need the SCAN function to assign to a variable a word that is longer than 200 characters, then you should explicitly specify the length of that variable.     2-  If you use the SCAN function in an expression that contains operators or other functions, a word that is returned by the SCAN function can have a length of up to 32,767 characters, except in a WHERE clause. In that case, the maximum length is 200 characters.   3-  In the SQL procedure, or in a WHERE clause in any procedure, the maximum length of a word that is returned by the SCAN function is 200 characters.   4- In the macro processor, the maximum length of a word that is returned by the SCAN function is 65,534 characters.     Source : http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm   ... View more

In a DATA step, if the SCAN function returns a value to a variable that has not yet been given a length, then that variable is given a length of 200 characters. If you need the SCAN function to assign to a variable a word that is longer than 200 characters, then you should explicitly specify the length of that variable. ... View more

Hey, Cats, Catx, and Cat func always give 200 bytes len for the resulting var, untill unless you do'nt define the length explicitly, if you use || to concat then you get len of word 1 + word 2, so in ur case  if you use data work.words; word1='Is'; word2='It'; all=(word1||word2; run; proc conetnts;run; in this case you will find 4 len for all variable.   ... View more

you can simply use rename option , check this   proc import datafile="&file" out=want(rename=(col11=new_var col22=new_var2)) dbms=xlsx replace; getnames=yes; run; ... View more

Thanks for your help. any open suggestion for inserting multiple rows.     ... View more

Hey, your code does not have problem, tried same and working fine. Check if all your sas components are installed correctly i.e SAS/ACCESS and SAS/CONNECT   proc import datafile = "C:\Users\ak26\Desktop\Book1.csv" out = c11 dbms = csv replace; getnames =yes; run; proc print;run;         SAS Output                                                                                   The SAS System Obs A b c d e f g 1 132     . erf 8363 03/11/1997 2 135     08/02/1955 erg 4734 03/11/1997 3 132     . erf 620 03/11/1997 4 444     . ergf 9192 03/11/1997         ... View more

Yes Thanks, I figured it out when saw the output, thanks for pointing that out, but can we use those line pointer to skip the lines, I mean just curius to learn that.   ... View more