About Flexluthorella

Flexluthorella · ‎11-11-2019

See attached for initial data set. there are several wt values for each patient_id. I need the min and the max for each pat ID. The original file was too large to upload.

Flexluthorella · ‎11-11-2019

when I ran the var in the class statement, there were missing data spots. What do you mean by adding proc means results to original data set? How would I do that

Flexluthorella · ‎11-11-2019

Male and death need to be in the final table but not analyzed. I am creating two datasets with minwt and maxwt then merging these two together. My final output should have the delta weight where delta is gt 10 lbs and the tables will have only the proportion of deceased (death=1 only) or males vs females. final table is most likely proc freq with cum percentage.

Flexluthorella · ‎11-11-2019

I designated the name as minWt. If I did autoname, how would that help with carrying over the other variables.?

Flexluthorella · ‎11-11-2019

I need the min weight per patient_id. the var male and death are numeric. male is gender and values include 1 for male 0 for female. Death values include 1 for deceased 0 for not deceased. I do not need the min or any stats for these.

Flexluthorella · ‎11-11-2019

How will it changes the results? I need the absolute min per patient ID

Flexluthorella · ‎11-11-2019

data Hivdata; merge learn.demogdemo (keep=patient_id male death arvstart) learn.visitdemo (keep=patient_id weight apptdate); by patient_id; run; *identify min weight prior to ARTstart by seperating records where appt date is less than or equal to arvstart to find min weight by id; proc means data=work.Hivdata min noprint; class patient_id; var weight male death; where apptdate le arvstart; output out=minweight min=minWt; run; This code is outputing the new var minWt but the other variables like male and death are not being keep. I also need to do this with max weight and compare difference.

Flexluthorella · ‎11-08-2019

Yes this also works! Thank you

Flexluthorella · ‎11-07-2019

The values in the variables x y z a1 a2 a3 a4 a5. They are simple numbers ranging from 2-999. Example the 1st value in variable X is 4 therefore X3 in newvar should be 12.

Flexluthorella · ‎11-07-2019

I am so sorry I am very new at this and I feel as though the output I need does not make sense. I am still not getting the correct output. It still include the character variables and the newvar do not show up. How do I add the multiplier of three to the numeric variables in the new dataset bythree? libname learn "XXX"; data by three: set learn.Nines; array oldvar(8) x y z a1 a2 a3 a4 a5; array newvar(8) x3 y3 z3 a13 a23 a33 a43 a53; do i = 1 to 8; if oldvar{i} = 999 the call missing (newvar{i}); end; drop i; run; of three to the new variables?

Flexluthorella · ‎11-07-2019

here is the code and error i have

Flexluthorella · ‎11-07-2019

Here is the original dataset

Flexluthorella · ‎11-07-2019

This is not the correct answer; I keep getting error

Flexluthorella · ‎11-07-2019

its a new variable in a new temporary dataset.

Flexluthorella · ‎11-07-2019

The question is "using dataset Nines, create a new temporary dataset which contains revised variables for all of the numeric variables such that the value of the revised variables is 3 times the original value except when the value is 999- code these as missing. Do this using 2 arrays and do not overwrite the data in the original variables."

Online Status	Offline
Date Last Visited	‎11-04-2020 12:54 AM

Re: Records by Date-Range

Records by Date-Range

2019 BRFSS data - truncation

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_access...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: Reading in 5GB birth dataset from https://www.cdc.gov/nchs/data_ac...

Re: How do you keep variables in the new dataset you create using proc...

Re: How do you keep variables in the new dataset you create using proc...

Re: How do you keep variables in the new dataset you create using proc...

Re: How do you keep variables in the new dataset you create using proc...

Re: How do you keep variables in the new dataset you create using proc...

Re: How do you keep variables in the new dataset you create using proc...

Re: How do you keep variables in the new dataset you create using proc...

How do you keep variables in the new dataset you create using proc mea...

Re: How do you create a new variable with Arrays that does not overwri...

Re: How do you create a new variable with Arrays that does not overwri...

Re: How do you create a new variable with Arrays that does not overwri...

Re: How do you create a new variable with Arrays that does not overwri...

Re: How do you create a new variable with Arrays that does not overwri...

Re: How do you create a new variable with Arrays that does not overwri...

Re: How do you create a new variable with Arrays that does not overwri...

Re: How do you create a new variable with Arrays that does not overwri...