Here is the solution that worked for me: data WORK.IMPORT; infile "/home/c.eroglu/fec/k.txt" delimiter = '|' firstobs=1 missover dsd; length cmte_id $9. amndt_ind $1. rpt_tp $3. transaction_pgi $5. image_num $18. transaction_tp $3. entity_tp $3. name $200. city $30. state $2. zip_code $9. employer $38. occupation $38. transaction_dt $8. transaction_amt 8. other_id $9. tran_id $12. file_num $22. memo_cd $1. memo_text $100. sub_id $19.; input cmte_id $ amndt_ind $ rpt_tp $ transaction_pgi $ image_num $ transaction_tp $ entity_tp $ name $ city $ state $ zip_code $ employer $ occupation $ transaction_dt $ transaction_amt other_id $ tran_id $ file_num $ memo_cd $ memo_text $ sub_id $; run; ... View more

Hi Chris, what do you mean by "Notepad++ data"? Do you mean the language definition? ... View more

Hi Chris, Thanks for your prompt reply. VS Code is not available in my work environment. But I must say that SAS has done an amazing job with the SAS extension for VS Code. In my work environment, I am writing SAS programs in a text editor and submitting them in batch mode. The only two text editors available to me are Gedit and Emacs. I know Emacs has ESS which provides SAS syntax highlighting, but I like the simplicity of Gedit. Gedit has small language extension files for syntax highlighting. I am not a software developer myself, but I thought writing a SAS extension file for Gedit would not be a major undertaking like the SAS extension for VS Code. Do you think SAS might be interested in producing a SAS syntax highlighting file extension for Gedit? Sincerely, Cuneyt ... View more

Thank you very much for response. I think you hit the nail right on the head. My scale is nominal and EDF tests are, therefore, not appropriate. As you suggested, I will use the chi-square test. Again, thanks for your insights. ... View more

Hello @FreelanceReinh ,   Thank you so much for your detailed response.   To your first point: I looked at several papers from the 1960's for p-value tables, but I wasn't quite comfortable using any of these tables as I am not very familiar with nonparametric statistics. I did not want to invest much time into carefully reading these papers to understand exactly what they were doing.   To your second point about ties: You mention that there are many ties in my data set because both samples have the same NAICS codes. If my understanding is correct, a tie refers to the y-values. In my case, NAICS codes are my x-values (categories) and the frequencies are my y-values. I used Example 8.2 in SAS documentation on PROC NPAR1WAY, where the responses (1 through 5, categorical) are x-values, and their frequencies are y-values. PROC NPAR1WAY compares two samples (active vs placebo). SAS Help Center: Example 85.1 Two-Sample Location Tests and Plots SAS Help Center: Example 85.2 EDF Statistics and EDF Plot From this point of view, I should not have any ties in my data set. Am I missing something?   To your last point about the computational difficulties: I ended up using an R function that implements K-S, C-vM, and Anderson-Darling tests and produces (if I understand correctly) exact p-values. 6.2 Comparison of two distributions | Notes for Nonparametric Statistics (bookdown.org) The numerical values from SAS and R do not agree. Could I be using the wrong R function?   Any insights would be greatly appreciated.   Sincerely, Cuneyt   ... View more

Thanks, Rick! ... View more

I am attaching the SAS data set. The code, log, and output are shown below: proc npar1way edf data=kl plots=none; class source; var naics; freq est_emp_acc_N; run; 68 proc npar1way edf data=kl plots=none; 69 class source; 70 var naics; 71 freq est_emp_acc_N; 72 run; NOTE: PROCEDURE NPAR1WAY used (Total process time): real time 0.04 seconds cpu time 0.03 seconds The SAS System 18:02 Friday, August 25, 2023 1 The NPAR1WAY Procedure Kolmogorov-Smirnov Test for Variable naics Classified by Variable source EDF at Deviation from Mean source N Maximum at Maximum 1 42522 0.577936 58.387741 2 1117060 0.284009 -11.391745 Total 1159582 0.294787 Maximum Deviation Occurred at Observation 19 Value of naics at Maximum = 33.0 Kolmogorov-Smirnov Two-Sample Test (Asymptotic) KS 0.055244 D 0.293927 KSa 59.488655 Pr > KSa <.0001 Cramer-von Mises Test for Variable naics Classified by Variable source Summed Deviation source N from Mean 1 42522 678.218161 2 1117060 25.817049 Cramer-von Mises Statistics (Asymptotic) CM 0.000607 CMa 704.035210 Kuiper Test for Variable naics Classified by Variable source Deviation source N from Mean 1 42522 0.293927 2 1117060 0.087944 Kuiper Two-Sample Test (Asymptotic) K 0.381872 Ka 77.287947 Pr > Ka <.0001 ... View more

Thank you. I think you are right. ... View more

Thanks, Tom. ... View more

Thanks for your response. I am now running the below code. In the second line, "datalines" is not colored blue. Is it not recognized by SAS?   When I run this code, SAS does not read the data. I get the following error:   ... View more

Sorry for my unclear question. When I use "009.9%", the first column's percentages are 62.5% and 37.5%, which DO add up to 100%.   b 0 1 a   5 6 0 Number Col Pct 62.5% 60.0% 1 Number 3 4 Col Pct 37.5% 40.0% All N 8 10     When I use "009%", the first column's percentages are 63% and 38%, which do NOT add up to 100%. How I can fix this problem?   b 0 1 a   5 6 0 Number Col Pct 63% 60% 1 Number 3 4 Col Pct 38% 40% All N 8 10 ... View more