About dannywilmot

dannywilmot · ‎09-24-2014

thanks PGstat and RW9. thats works great! Rgds, Danny

dannywilmot · ‎09-23-2014

Solution provided by RW9 will work but will require me to change the SQL everyone when the list of variables to repeat is changed, can we get the list from the table instead of hard coding this in SQL.

dannywilmot · ‎09-23-2014

Yes, trans_id is unique in both the tables.

dannywilmot · ‎09-23-2014

Hi PGStats, I have now placed all the required inputs and expected output in an excel file (attached). Unfortunately, I can not share the original data thats why I have tried to create a dummy dataset for this example, For this example we can assume that all the fields are character variables, Also orginal master dataset will have around 200 variables and Var_repeat will have around 30 variables which needs to be repeated in the input table. Rgds, Danny

dannywilmot · ‎09-22-2014

Hi Experts, I need to repeat some of the variables in my input table with prefix "MD_". These new varaibles should carry all the non-missing values from the original variable, however for missing values, it should join this table with master dataset on trans_id and get the value from there. List of required varaibles to be repeated are saved in a separate table (Repeat_Table). Can someone please help me understand how to build this. o Many thanks in advance DW

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Copy of variables with a prefix

Re: Copy of variables with a prefix

Re: Copy of variables with a prefix

Re: Copy of variables with a prefix

Copy of variables with a prefix

Re: Copy of variables with a prefix

Re: Copy of variables with a prefix

Re: Copy of variables with a prefix

Re: Copy of variables with a prefix

Copy of variables with a prefix