About Alucard_L

Alucard_L · ‎05-09-2018

If now I have a data like obs x 1 1 2 0 3 0 4 1 5 0 Variable x is numeric. The format of x is 2. if I want to convert 1 to 1.5, the output is like obs x 1 2 2 0 3 0 4 2 5 0 Because SAS rounded 1.5 to 2 due to the format. If I add a format statement like format x 1.1; Then the output is like obs x 1 1.5 2 0.0 3 0.0 4 1.5 5 0.0 My question is that how do I change the format to get a output like obs x 1 1.5 2 0 3 0 4 1.5 5 0 and x is still a numeric value. Thanks.

Alucard_L · ‎02-09-2018

Thanks! Your method also works!

Alucard_L · ‎02-09-2018

mapping chart A B StaffID ID Cartype car Food food Alcohol alcohollevel

Alucard_L · ‎02-09-2018

They are not in the same order. Variable names in dataset B are the names I want. I need to change variable names in dataset A. I have the mapping chart. So I know which variable maps to which.

Alucard_L · ‎02-09-2018

Hello everyone. I have two datasets A and B. They have some same variables but with different names. I'd like to rename these variable names in A using the variable names in B. For example, I have variable names StaffID, Cartype, Food, Alcohol, ... up to 200 variables in dataset A. ID, car, food, alcohollevel,.... up to 300 variables in dataset B. I want to rename staffID=ID, cartype=car, alcohol= alcohollevel. Is there a way to rename all the 200 variables in dataset A using array or macros? Thanks,

Online Status	Offline
Date Last Visited	‎05-10-2018 12:31 AM

Format question

Re: Rename variable names using macro or array

Re: Rename variable names using macro or array

Re: Rename variable names using macro or array

Rename variable names using macro or array

Format question

Re: Rename variable names using macro or array

Re: Rename variable names using macro or array

Re: Rename variable names using macro or array

Rename variable names using macro or array