Thank you. ... View more

Sorry for the late reply. Thank you. ... View more

Thank you for explaining clearly. ... View more

Thank you. Will update the title. Typo error. Sorry for the inconvenience. ... View more

Thank You! ... View more

Thanks a lot for explaining it so well. The code worked perfectly. ... View more

Thank you. This code worked. The values I gave in the original dataset were single characters. I just gave them as an example. My main doubt was how to create a macro variable. Thanks a lot for the code. it worked perfectly. But I couldn't understand this line input (_all_) (+0);  Could you please explain this? I never saw _all_ in input statement. It's very interesting. Learning something new everyday from this community. ... View more

Thank you so much. It worked. ... View more

Sorry, Now I understood your point. I need dataset two like this based on dataset one data one; input variable$1-8; datalines; var1 $10 var2 $9 var3 $11 ; run; crreate a macro variable &x. length &x.; should resolve length var1 $10 var2 $9 var3 $11; data two; length var1 $10 var2 $9 var3 $11; input var1 $ var2 $ var3 $; datalines; a b c ; run; Hope I am clear this time. ... View more

Sorry, I need to create a macro variable &x. and its should resolve like this input var1 $10 var2 $9 var3 $11 I just gave some random values for those variables. All I need is to create a macro variable and it should resolve like mentioned above. Sorry for the confusion.   ... View more

Data want; DOB=today()-365*30; Format dob date9.; Run; ... View more