I know if i want to find how many distinct a, I can use count (distinct a) Now I need find how many different combination of a and b. What I should do? ... View more

I have a survey dataset. such as    Q1 Q2 Q3 ... 0.5 yes most 0.1 no some …. Some one just answer some questions. for example, stop at Q15; stop at Q23. Is there any best way to identify these people?   ... View more

I imported a table from Excel. The variable name is "a2-4". How to deal with these names?   Thanks ... View more

I want to get one part of the data and calculate every time. for example, first time obs: 1 to 14, second time obs: 15 to 28 etc. I  use a macro   %macro agestd_one(number); %do i=1 %to &number %by 14;   data import; set T0314(firstobs=&i obs=14);   run; %end; %mend;   I run:　 %agestd_one(14); works well.   I run: %agestd_one(28);   error message: ERROR: FIRSTOBS option > OBS option - no data to read from file WORK.T0314.   what wrong at here?           ... View more

I use ods excel and proc report to save the results to excel file.   part of the codes look like:   Macro: ods excel %IF &state=1 %THEN file="\walter\3_10\&outexcel..xlsx"; cssstyle="style.css" options (embedded_titles = 'yes' embedded_footnotes='yes' title_footnote_nobreak='off' sheet_interval="table" sheet_name="T3.10.09&statename.");   footnote; 　 proc report data=datasheet1 split='@' style(header)=higherlevel{borderwidth=0.3};     I run this macro 6 times. But only save 5 sheets.   what happened? ... View more

A is: count pct year y 32751 8.6 2012 0 35200 8.4 2013 1 34422 7.8 2014 2 36195 7.6 2015 3 39035 7.5 2016 4 43060 7.6 2017 5 360673 6.2 2012 0 357294 5.9 2013 1 341996 5.3 2014 2 341963 5.1 2015 3 351231 5.2 2016 4 366421 5.3 2017 5 25432 6.6 2012 0 25219 6.0 2013 1 23947 5.4 2014 2 25239 5.3 2015 3 27019 5.2 2016 4 29103 5.1 2017 5 274908 4.7 2012 0 257168 4.2 2013 1 235824 3.6 2014 2 234645 3.5 2015 3 237780 3.5 2016 4 247493 3.6 2017 5 7319 1.9 2012 0 9981 2.4 2013 1 10475 2.4 2014 2 10956 2.3 2015 3 12016 2.3 2016 4 13957 2.5 2017 5 85765 1.5 2012 0 100126 1.7 2013 1 106172 1.6 2014 2 107318 1.6 2015 3 113451 1.7 2016 4 118928 1.7 2017 5       B is :   32751 8.6 360673 6.2 25432 6.6 274908 4.7 7319 1.9 85765 1.5 35200 8.4 357294 5.9 25219 6.0 257168 4.2 9981 2.4 100126 1.7 34422 7.8 341996 5.3 23947 5.4 235824 3.6 10475 2.4 106172 1.6 36195 7.6 341963 5.1 25239 5.3 234645 3.5 10956 2.3 107318 1.6 39035 7.5 351231 5.2 27019 5.2 237780 3.5 12016 2.3 113451 1.7 43060 7.6 366421 5.3 29103 5.1 247493 3.6 13957 2.5 118928 1.7 ... View more

I have the below data set. I want to use proc summary to get the summary like that sex total 1 … 2 …. 9 … all …         sex age total 1 1 408563 1 2 338258 1 3 311091 1 4 121462 1 5 102785 1 6 26971 1 7 8573 1 8 17051 1 9 20 2 1 3710 2 3 12209 2 4 12745 2 5 4205 2 6 584 2 7 15521 2 9 29 9 1 981 9 2 108 9 3 10 9 4 459 9 5 294 9 6 9 9 7 35 9 8 136 9 9 7901 ... View more