topic Re: Adding first two observations in SAS Programming

Adding first two observations

vijay24 — Tue, 16 Jul 2019 14:47:39 GMT

edu_lvl Frequency Percent CumulativeFrequency CumulativePercent123456

16	0.26	16	0.26
655	10.80	671	11.06
182	3.00	853	14.06
573	9.45	1426	23.51
2254	37.16	3680	60.68
2385	39.32	6065	100.00

My variable name is education level. Considering low responses I want to add levels '1' and '2' together. help, please.

Re: Adding first two observations

vijay24 — Tue, 16 Jul 2019 14:48:57 GMT

Something messed up. obs 1 = 16 and obs 2 = 655. I want to combine them into one observation.

Re: Adding first two observations

PeterClemmensen — Tue, 16 Jul 2019 14:49:08 GMT

So given this data, what does your desired result look like?

Re: Adding first two observations

PaigeMiller — Tue, 16 Jul 2019 14:50:26 GMT

@vijay24 wrote:
Considering low responses I want to add levels '1' and '2' together.

I don't understand this sentence.

Please show us the results you want from this data.

In addition, it is best if you provide the data in a readable form, prefereably as a SAS data step, instructions are here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Re: Adding first two observations

Tom — Tue, 16 Jul 2019 14:52:07 GMT

the easiest way might be to create a format that combines those two values. Assuming the values are numbers then the format definition might look like:

proc format ;
value edu_combo
  1,2 = '1 or 2'
;
run;

Then just use that format with your PROC .

proc freq data=mydata ;
  tables edu_lvl;
  format edu_lvl edu_combo.;
run;

Re: Adding first two observations

vijay24 — Tue, 16 Jul 2019 14:55:27 GMT

@Tom Thank you so much. This worked perfectly fine.