Hello,
I am working with drug NDC codes of claims data. Initially, the format for this variable could only accomodate 9 numbers, thus I changed it to %12g. Now, I am able to see the codes but the leading 0s have disappered. for eg: 005447282 is seen as 5447282. Is there a way I can generate another variable with required numbers of leading 0s for each ndcnum (every ndcnum has varying numbers of deficient leading 0s) and then merge these two variables in the same dataset? Note: I imported this dataset from SAS
I am working with drug NDC codes of claims data. Initially, the format for this variable could only accomodate 9 numbers, thus I changed it to %12g. Now, I am able to see the codes but the leading 0s have disappered. for eg: 005447282 is seen as 5447282. Is there a way I can generate another variable with required numbers of leading 0s for each ndcnum (every ndcnum has varying numbers of deficient leading 0s) and then merge these two variables in the same dataset? Note: I imported this dataset from SAS
Comment