About Rover17

Rover17 · ‎10-06-2024

Thanks Kurt, I was thinking this was a utility macro within the SAS system, like the %ds2csv macro. So, are you suggested that I need to ask the authors for the actual macro code? I don't have it. Regards

Rover17 · ‎10-06-2024

Hi Quentin, Thank you for following up. I will provide the log output after I provide some additional background. The lrdif_es macro was created by a SAS user, and presented in a report that can be found here: https://www.ets.org/Media/Research/pdf/RM-16-17.pdf My SAS log result shows the following: 159 %lrdif_es(data=Middle.Final_Middle_Sample_All_DIF, MLOGIC(LRDIF_ES): Beginning execution. 160 items= &HT_A_CFA_Items , SYMBOLGEN: Macro variable HT_A_CFA_ITEMS resolves to _3410 _3413 _3415 _3422 _3424 _3425 _3426 _3438 _3443 _3465 161 group=Male_Female Male_Other White_AfrAmer White_Hispanic White_AmerIndAlask 161! White_Asian White_NatHaPaI White_IndicOther White_Unknown, 162 criterion=HT_A_rawscore, 163 sig_level=0.00555, 164 RS_P_crit_B=0.035, 165 RS_P_crit_C=0.070, 166 outfile=Middle.LRDIF_Holland_Type_A_Middle, 167 plot=yes); MLOGIC(LRDIF_ES): Parameter DATA has value Middle.Final_Middle_Sample_All_DIF MLOGIC(LRDIF_ES): Parameter ITEMS has value _3410 _3413 _3415 _3422 _3424 _3425 _3426 _3438 _3443 _3465 MLOGIC(LRDIF_ES): Parameter GROUP has value Male_Female Male_Other White_AfrAmer White_Hispanic White_AmerIndAlask White_Asian White_NatHaPaI White_IndicOther White_Unknown MLOGIC(LRDIF_ES): Parameter CRITERION has value HT_A_rawscore MLOGIC(LRDIF_ES): Parameter SIG_LEVEL has value 0.00555 MLOGIC(LRDIF_ES): Parameter RS_P_CRIT_B has value 0.035 MLOGIC(LRDIF_ES): Parameter RS_P_CRIT_C has value 0.070 MLOGIC(LRDIF_ES): Parameter OUTFILE has value Middle.LRDIF_Holland_Type_A_Middle MLOGIC(LRDIF_ES): Parameter PLOT has value yes MLOGIC(LRDIF_ES): Ending execution. I get no error message and no results. Thank you

Rover17 · ‎10-06-2024

Hi All, I am struggling with calling the following SAS macro. Can someone please help me figure this out. In a report, the authors only provide the following statements. Thank you %macro lrdif_es(data, items, group, criterion, exo_con=, exo_cat=, sig_level=0.05, RS_D_crit_B=0.035, RS_D_crit_C=0.070, RS_P_crit_B=0.035, RS_P_crit_C=0.070, foc_size=100, ref_size=100, combined_size=400, outfile=LRDIF, plot=NO, size_ratio=0, out_parameter=0); %lrdif_es(data=sample, items=item1-item8, group=gender black, exo_con=income age, exo_cat=parent_education state, criterion = score, outfile=results, plot=yes)

Rover17 · ‎10-02-2023

Hi All, I have a question about how to use proc varcomp when there are effects that reflect two levels of nesting. For my analysis, I have human raters nested in faculty, and faculty nested in departments. You can see my proc varcomp procedure below. SAS reports an error because it doesn't like the term of Rater(Faculty(Department)) in the Model statement . So, I am wondering if I specified the two levels of nesting correctly in the first place. proc varcomp data = OneDrive.long_&Year._wide_c method = reml; class Department Faculty Rater item ; model Dependent = item Department Faculty(Department) Rater(Faculty(Department)) Department*item / FIXED=1; run; title; Can someone please explain to me how to correct my code? Could I correct it by replacing the term Rater(Faculty(Department)) with the two terms of Rater(Faculty) and Faculty(Department) instead? Thank you

Rover17 · ‎07-16-2023

Hello Fellow SAS Programmers, I am trying to classify ranked observations in my dataset. I am interested in identifying the top 10 performing observations. The challenge is that there can potentially be tied values among more than the top 10 performing observations. In my dataset, I have performance score (X variable) for each of 270 observations. Some observations have the same score. After I conduct a descending sort of the file using the variable X, I want to identify the top 10 scoring observations in a way that permits tied observations can be included in the top 10 performance category (i.e., Top_10 = 'Yes'). Below, I display an example of what I am trying to achieve. Can someone please help me by suggesting SAS code that can achieve what I want. It would be great if it were part of a data step, but it doesn't have to be. For instance, I could probably create a file that has no duplicate performance scores, then create a counting variable, and then merge that file with the initial dataset. X Top_10 99 Yes 90 Yes 83 Yes 83 Yes 72 Yes 71 Yes 71 Yes 65 Yes 52 Yes 43 Yes 31 Yes 20 Yes Thank you, Rover17

Rover17 · ‎02-08-2023

Hi All, I am trying to use PROC IRT procedure. I am getting the following warning messages. After the following warning messages, I provide my code below. WARNING: The M step for the EM algorithm fails to converge. Number of iterations or number of function calls exceeds limit. WARNING: The estimation algorithm did not converge. proc irt data=mald.calibration_file_d link=logit itemstat outmodel=mald.initial_parameters_file_d guessprior=(0.2,20) slopeprior=(1,2) fconv=.01 technique=EM maxiter=1000 maxmiter=1 noad qpoints=11; group group; var C9_21 C8_22 C8_23 C8_24 C10_25 C9_26 C10_27 C12_28 C12_29 C13_30 C11_31 C11_32 C12_33 C12_34 C13_35 C12_36 C11_37 C11_38 C11_39 C12_40; model C9_21 C8_22 C8_23 C8_24 C10_25 C9_26 C10_27 C12_28 C12_29 C13_30 C11_31 C11_32 C12_33 C12_34 C13_35 C12_36 C11_37 C11_38 C11_39 C12_40/resfunc=threep; run; Can someone please suggest how to correct my code so that the model converges? Thank you, Aaron

Rover17 · ‎01-31-2023

Hello All, I am trying to use the PROC IRT OUTMODEL= option, but I get errors. My code is attached, and it shows the errors I get. Can someone please explain to me how to correct my code? Thanks, Rover17

Rover17 · ‎02-06-2022

This is also a big help. Thanks!

Rover17 · ‎02-06-2022

This is a great explanation on the difference between SAS supplied vs user created macros. Regards

Rover17 · ‎02-05-2022

Thanks Reeza. I will try that later today. However, I was under the impression that the %match macro I asked about would function the same way as the %ds2csv macro that converts SAS datasets to CSV files. For the %ds2csv, there is no need to use the %marco and %mend statements. For example; Data CASES; Input PTID AGMT CHK AGMN WT; Cards; 101 39 1 13 118 102 35 1 14 129 103 28 1 12 108 104 31 1 14 110 105 41 1 13 138 ; %ds2csv(data=CASES, csvfile='c:\CASES.csv', runmode=b); Why do they differ? Regards, Aaron

Rover17 · ‎02-04-2022

Hi All, I am trying to run a SAS macro that I found in the following SAS Statistics and Data Analysis Paper: An Introduction to Matching and its Application using SAS. I attached the paper to this post. Below are the two SAS data steps to create the input datasets for the macro. These data steps run fine. But, I cannot get the %match macro to run. The macro is after the two data step programs below. Data CASES; Input PTID AGMT CHK AGMN WT; Cards; 101 39 1 13 118 102 35 1 14 129 103 28 1 12 108 104 31 1 14 110 105 41 1 13 138 ; Data CONTROLS; Input PTID AGMT CHK AGMN WT; Cards; 201 39 2 11 175 202 62 1 11 170 203 35 2 11 170 204 42 1 13 118 205 30 1 14 130 206 39 2 12 135 207 27 2 12 127 208 58 1 10 140 209 36 1 14 110 210 41 2 12 129 211 55 2 13 193 212 45 1 11 154 213 61 2 13 153 214 31 2 11 97 215 28 2 11 145 ; %match(case=CASES, control=CONTROLS, idca=PTID, idco=PTID, mvars=AGMT, wts=2, dmaxk=2, method=optimal, ncontls=2, maxiter=10000, out=MTCH, print=y); run; Can someone please help me understand why this %match macro wont run? I get the following output when trying to run it. 71 %match(case=CASES, control=CONTROLS, idca=PTID, idco=PTID, mvars=AGMT, wts=2, dmaxk=2, - 180 WARNING: Apparent invocation of macro MATCH not resolved. ERROR 180-322: Statement is not valid or it is used out of proper order. 72 method=optimal, ncontls=2, maxiter=10000, out=MTCH, print=y); 72 ! run; Thanks

Rover17 · ‎04-30-2021

Hi SAS Community, When I run my code below to create a set of boxplots, I use the INSETGROUP statement to insert Min, Mean, and Max values. The Min and Max values display as requested, but the Mean values don't. Each Mean value has 3 numbers before a decimal, then 2 numbers after the decimal. Sincere there are 15 boxplots in the chart, I don't think there is enough space to show the Mean values for all the boxplots. Some boxplots show an asterisk for the Mean value. How can I adjust the spacing or request truncated mean values for each of the boxplots in the chart? proc boxplot data=boxplot_3; plot Step1_1*Program ; inset min mean max / header = 'Overall Statistics' pos = tm; insetgroup min mean max / header = 'Min & Max Values for Each Program'; label Step1_1 = 'Step 1 Scores'; run; Thank you, Aaron

Rover17 · ‎04-28-2021

Hi SAS Community, I'm using the following code to create a chart of boxplots. In my dataset, I have a continuous variable called Step1_1. I also have a categorical variable called Program. There are 30 Programs, and each Program is to have a boxplot. I want to create a single chart that shows the 30 boxplots all displayed on a single page. I'm using ODS to output the chart in a RTF document. The orientation is landscape. The problem I have is that Proc Boxplot is splitting the chart to display 15 boxplots on the first page and the remaining 15 on the second page. proc boxplot data=boxplot_3; plot Step1_1*Program ; inset min mean max / header = 'Overall Statistics' pos = tm; insetgroup min max / header = 'Min & Max Values for Each Program'; label Step1_1 = 'Step 1 Scores'; run; Thanks for your help !!

Rover17 · ‎04-07-2021

Thanks. This probably would come in handy. I'll refer to it in the future.

Rover17 · ‎04-07-2021

Thanks. The libname of Library was being specified in the external file, using the wrong directory among my set of shared drives. I opened the external file, and fixed it. Regards, Aaron

Online Status	Offline
Date Last Visited	‎10-06-2024 11:56 PM

Re: I am trying to call a SAS macro, but I need some help.

Re: I am trying to call a SAS macro, but I need some help.

I am trying to call a SAS macro, but I need some help.

How to use proc varcomp when there are effects that reflect two levels...

Identifying top 10 scoring observations in a way that permits tied obs...

PROC IRT Won't Converge

PROC IRT OUTMODEL= option is giving me errors. Can someone please expl...

Re: Can someone help me understand why the %match macro wont run?

Re: Can someone help me understand why the %match macro wont run?

Re: Can someone help me understand why the %match macro wont run?

Re: Identifying top 10 scoring observations in a way that permits tied...

Re: Can someone help me understand why the %match macro wont run?

Re: Can someone help me understand why the %match macro wont run?

Re: Please help me figure out error after %INCLUDE statement. ERROR: L...

Re: Please help me figure out error after %INCLUDE statement. ERROR: L...

Re: Can someone help me understand why the %match macro wont run?

Re: I am trying to call a SAS macro, but I need some help.

Re: I am trying to call a SAS macro, but I need some help.

I am trying to call a SAS macro, but I need some help.

How to use proc varcomp when there are effects that reflect two levels...

Identifying top 10 scoring observations in a way that permits tied obs...

PROC IRT Won't Converge

PROC IRT OUTMODEL= option is giving me errors. Can someone please expl...

Re: Can someone help me understand why the %match macro wont run?

Re: Can someone help me understand why the %match macro wont run?

Re: Can someone help me understand why the %match macro wont run?

Can someone help me understand why the %match macro wont run?

PROC BOXPLOT wont correctly display Mean values using INSETGROUP

Proc Boxplot is not showing all boxplots in a single chart on a single...

Re: Please help me figure out error after %INCLUDE statement. ERROR: L...

Re: Please help me figure out error after %INCLUDE statement. ERROR: L...