I have a dataset of approximately 5000 observations.
Each observation is a firm, and each firm is part of a program. These programs have, over time, been inappropriately named values between 0 and 3 billion. All firms (in program X), have a project-id value of Y, but Y differs ALOT over the dataset.
Some of the examples of the project-id variable are 55051, 5,42, 23341212 etcetera.
So basically, what I’m looking to do, is for SAS to recognize (for example) the number 5,42 – and give a new variable a value of 1,01. The next step would be to find all the observations of 5,43, thus giving the new variable a values of 1,02, and so forth.
However, there are quirks. All of these seeming random program-id values, all fit under 14 large main programs (Z). If possible, program Z would be fitted with the same initial values, for an example 1,xxx.
Soooo. A quick resume, would be that I need SAS to run through numbers, from 1 to 3000000000, and every time SAS finds a unique value, call it something like n,(n-10)(n-1) for non-negative numbers.
I’ve been struggling with this problem all day, and I’m absolutely out of ideas.
I would appreciate any help that would point me in the right direction.
Hope you can help.
Kind regards
Tobias
... View more