Hi All,
I got a question here:
suppose I transfer a character variable to numeric variable, and I'll get a new numeric variable, and this new variable will be output at the end of my dataset. I know I can use retain statement to reorder variables. But if I have lots of variables, I need to type all variable names, really inconverient. Any other way to directly replace character variable?
for example:
I have variables: A B C D E
then Character to numeric and drop character: B C D E F(numeric, transferred from A)
then retain statement to reorder: F B C D E
Is ther a way to replace A with F directly?
many thanks,
Amy
... View more
Hi,
I got a question about below problem:
I have some records for every person's job per month. If he/she complete, that month will be 1, otherwise 0. The form like below:
Name
Jan
Feb
Mar
Apr
May
June
July
Aug
Sep
Oct
Nov
Dec
Amy
1
0
0
0
0
1
0
0
1
0
0
1
David
1
1
1
1
1
0
0
1
0
1
0
0
John
0
0
1
0
0
0
1
1
1
1
1
1
The question is: How to find person that doesn't complete job more than 3 continuous months (contains 3) in one record? For example, Amy has 0 from Feb to May, and John has 0 from Apr to June, Amy and John should be extract.
Anyone has some ideas?
Many thanks,
Chen
... View more
Hi PG, I can't understand your writing totally, what does select subset mean? If I have a dataset named myData, and all patients id in myData has set in to one of four mutually exclusive subsets (A, B, C, D), how could I make sure every id has in one of four subsets, no duplicate and no obsence? Could you help me more, please? Many thanks, Chen
... View more
Hi, I have a questions here: You have just written code that assigns each patient in your data set to one of four mutually exclusive subsets. How would you check to make sure that every patient has been assigned to a subset and none are in more than one? Knowing that every patient should fall into one of these categories, how would you handle those that don't? Anyone has know how to solve this? Even some idea are okay. Many thanks, Chen
... View more