topic Can I combine proc ranks with proc format then save it into a new dataset? in SAS Studio

Can I combine proc ranks with proc format then save it into a new dataset?

jude1 — Tue, 09 Mar 2021 18:52:33 GMT

I have a dataset that i need to find the quartiles for one variable then change the numbers of the quartiles into words (assign low to 0, mid-low to 1, etc...). I am not sure how to combine both and then save it to a new dataset.

here is my code:

data mydata;

input var1 income population percentage;

datalines;

1 500 60 100%

2 400 70 90%

3 400 100 80%

4 800 222 80%

5 500 100 75%

6 600 213 70%

7 900 900 60%

8 1000 909 50%

9 100 600 40%

10 760 235 20%

;

run;

proc rank data=mydata groups=4 out=want;
var percentage;
ranks quartiles;

run;

I tried adding the proc format to the variable quartiles but i failed.

Thank you.

Re: Can I combine proc ranks with proc format then save it into a new dataset?

PaigeMiller — Tue, 09 Mar 2021 18:59:10 GMT

Again, I request that you provide your data as working code, that does what you want; and not code that kinda sorta gets close to what you want but doesn't really work.

Here is how to use custom formats with PROC RANK.

proc format;
    value rankf 0='Low'; /* I'm lazy, you type the rest */
run;
proc rank data=mydata groups=4 out=want;
    var percentage;
    ranks quartiles;
    format quartiles rankf.;
run;

Re: Can I combine proc ranks with proc format then save it into a new dataset?

Tom — Tue, 09 Mar 2021 18:58:51 GMT

What variable specifically are you trying to attach a format to?
What format are you trying to attach it?
How did you define the format?
How did you try to attach the format to the variable?