DATA Step, Macro, Functions and more

Proq Freq help please

Reply
New Contributor
Posts: 3

Proq Freq help please

[ Edited ]

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

Super User
Posts: 7,758

Re: Proq Freq help please

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 73 views
  • 0 likes
  • 2 in conversation