About lmyers2

lmyers2 · ‎01-22-2018

That's very helpful, thanks - so if 2 arrays in different data steps reference the same columns Def1-Def69, can you use the same name or does the array name have to be different, even between data steps? Thanks Laura

lmyers2 · ‎01-21-2018

Hello, I'm using SAS 9.4 edition. I have would like to define several different variables using the same 69 rows of data in the same data step but I believe the array names have to differ. My coding is here: array DEFENDANT_TYPE [69] $ DEFENDANT_TYPE1-DEFENDANT_TYPE69; Org_named=0; do g= 1 to 69; if DEFENDANT_TYPE [g]='Organization' then Org_named=1; end; array DEFENDANT_TYPE [69] $ DEFENDANT_TYPE1-DEFENDANT_TYPE69; n_defendant=0; do h= 1 to 69; if DEFENDANT_TYPE [h] > ' ' then n_defendant + 1; end; When I change the name "DEFENDANT_TYPE" to "Org_named" in the first array or "n_defendant" in the second array, I get the following error messages. ERROR: Illegal reference to the array Paid. ERROR: Undeclared array referenced: DEF_INDEMNITY_PAID. ERROR: Variable DEF_INDEMNITY_PAID has not been declared as an array. ERROR: Illegal reference to the array Paid. Can someone help?

lmyers2 · ‎01-20-2018

Hello, I'm using SAS 9.4 edition. I'm trying to selectively remove duplicate observations but I'm not sure how to tell SAS to keep certain rows. I'd like to keep the row with more data in the state field, for example. My code is below and it's not working. Thanks for the help! CASE_ID State 1 MA 1 proc sort data=casemergedata out=newdata nodupkey; by CASE_ID; run; proc freq data=newdata; tables CASE_CONTROL; run;

lmyers2 · ‎01-04-2018

Thanks for the suggestion but it still reads all observations as sepsis=0, and I've used this formatting before where you set the variable=0 for everyone and then make if/then statements.

lmyers2 · ‎01-04-2018

Hello, I'm using SAS 9.4 full edition. For some reason, SAS is not recognizing my character array for when sepsis=1. I get all observations as sepsis=0. Please note that even though the variable appears as a number, it is a character variable so I included the dollar sign and quotation marks. Can someone find an error in my coding? Thanks Laura data; set; array DXarray [*] $ DX1-DX70; do a=1 to 70; sepsis=0; if DXarray[a]='99591' then sepsis=1; end; run; proc freq; tables sepsis; run;

lmyers2 · ‎01-02-2018

Hello - I had a related question. Since the below is in a data step, how do you get the actual numeric sum? When I did proc freq below, sas gave me the list of values and not the actual sum. data; set; sum_range=sum(of a1-a5); run; proc freq; tables sum_range; run; Thanks Laura

lmyers2 · ‎12-31-2017

Hello, I'm using SAS 9.4 full edition via a virtual desktop. I have 71 co-morbidities and would like to find the most frequent ones. I have shown 3 examples of below of how the variables are coded and then tried to code the array with these 3 example comorbidities. They aren't numbered 1-3 but rather have character coding that distinguish each comorbidity. Do I take the numbers out of the array? Do I have to rename all of the variables? CM_PULMCIRC CM_RENLFAIL CM_LIVER data want; set have; array CM_' ' [3] CM_' '1-CM_' '3; do i=1 to 3; if CM_' ' [i] > ' ' then do; diagnosis = CM_' '[i]; output; end; end; keep diagnosis; run; proc freq order=freq; tables diagnosis; run; I

lmyers2 · ‎12-31-2017

Hello, I'm using SAS 9.4 full edition through a virtual desktop. There is an integer variable that goes 1-11 and I'm trying to categorize it into 4 categories using an "in" statement but it's not working. Can someone fix my code below? Thanks Laura elix_category=0; if comorb_comp in(1, 2, 3, 4) then elix_category=1; if comorb_comp in(5, 6, 7, 8, 9) then elix_category=2; if comorb_comp in(10, 11) then elix_category=3; if comorb_comp=. then elix_category=.;

lmyers2 · ‎12-09-2017

Hello, I'm using SAS 9.4 full edition. I have some missing data for some covariates and would like to determine the N upon which the model is being based (some patients might have missing data for all the covariates or different patients might have different variables missing). I don't see anywhere on the SAS output that mentions the final N that is used. Do you have to program it to give you this result? Thanks! Best Laura

lmyers2 · ‎12-07-2017

Hello, I'm using SAS 9.4 full version. Is there a place in the following proc logist coding to put a where statement? I'd like to run this regression only when a binary variable CASE='1'. Thanks Laura proc logist descending; class VARIABLE1 VARIABLE2 VARIABLE3; model Payment=VARIABLE1 VARIABLE2 VARIABLE3 VARIABLE4 / rsquare; run;

lmyers2 · ‎12-06-2017

Hello, I'm using SAS 9.4 full edition and am trying to add up money within an array. The variable MONEY below is coded as a numeric variable with format dollar15.2. I think the if statement is the problem because I keep getting 0 as the answer. I don't know how to code that line which adds up all the amounts in the MONEY array for a given row. Thanks for the help! Best Laura array MONEY [50] MONEY1-MONEY50; TotalCost=0; do i= 1 to 50; if MONEY [i]=' ' then TotalCost + ' '; end; format TotalCost dollar15.2;

lmyers2 · ‎12-06-2017

Thanks - the manual doesn't mention how to program the reference group though using class statement in proc quantreg. Would someone mind posting sample code? Best Laura

lmyers2 · ‎12-06-2017

Hello, I'm using SAS 9.4 full edition. I am trying to do a median regression analysis. I pasted the base code below but it's not working. I also pasted the error messages below. proc quantreg ci=resampling; class VARIABLE1 (param=ref ref='CONTROL'); model COST=VARIABLE1 VARIABLE2 VARIABLE3 / quantile=0.25 0.5 0.75; run; ERROR 22-322: Syntax error, expecting one of the following: a name, ;, -, /, :, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 76-322: Syntax error, statement will be ignored. Thanks very much in advance for the help! Best Laura

lmyers2 · ‎12-06-2017

Yes, but for all other analysis except this, it's easier to have it in the wide format and use arrays so really I just need to figure this out once.

lmyers2 · ‎12-06-2017

Sorry, am trying to post again because it looked like it posted before as one long line of code...Again the goal is to do this array when another binary variable sex=1. data work.workingfile; set final.finalfile; array DIAGNOSIS [50] DIAGNOSIS1-DIAGNOSIS50; do i=1 to 50; if DIAGNOSIS [i] > ' ' then do; NEW_DIAGNOSIS = DIAGNOSIS [i]; output; end; end; keep NEW_DIAGNOSIS; run;

Online Status	Offline
Date Last Visited	‎05-20-2021 12:21 AM

compressing hyphens and slashes

Re: subtracting dates

subtracting dates

finding overlapping patients in 2 datasets

moving long data into a column name

Re: subtracting dates in datetime20 form

subtracting dates in datetime20 form

Re: subtracting 2 dates

subtracting 2 dates

Re: creating a variable using temporal criteria in a long data file

Re: question about naming arrays differently within a data step

question about naming arrays differently within a data step

question about selectively removing duplicates

Re: question about coding an array

question about coding an array

Re: How to sum along row?

programming arrays with part character variables

using an "in" statement to rename a categorical variable

coding within proc logist

question about where statement within Proc Logist

adding money in an array statement

Re: coding for median regression

coding for median regression

Re: question about array

Re: question about array