Proq Freq help please

[mrob]

Hi,

i have a data set which has variable X as (3-, 4+, 5, 5- and so on).

i want to do a proc freq based on  variable X - but the output should be based on like a reference data of X i.e. (0, 1+, 2- etc.) .

Given 0, 1+, 2- are not in dataset so the desired output will be;

variable frequency percent cumulative frequency cumulative precent

0

1+

2-

3-         4                   10%       4                              10%

4+        5                   3%          9                              13%

Thanks

Rob

[Kurt_Bremser]

Look at this paper: https://pharmasug.org/proceedings/2015/QT/PharmaSUG-2015-QT33.pdf

It shows how to simulate the preloadfmt option in proc freq.