About lmyers2

lmyers2 · ‎12-06-2017

I agree, thanks for being willing to look at my code. I want the below array to run only when another binary variable is sex=1. I'm not sure if I can put a where statement in the do statement. When I tried, it failed so there must be another option but I can't find it on the SAS arrays document. Here it is: 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;

lmyers2 · ‎12-06-2017

Hello, I'm using SAS 9.4 full edition. I'm wondering if you can use a where statement within an array. I'm looking for a certain diagnosis within an array but only where sex=female. Could someone post a sample code conditioning on a binary predictor? Thanks so much!!! Laura

lmyers2 · ‎12-02-2017

Hello, I'm using SAS 9.4 full edition through a server. I will be running a logistic regression model with a very large data set (2700 observations in smaller group and 50000 observations in larger group). I have several categorical variables and am not sure how you program using the class statement and choosing the reference group for each, since I've only run a logistic regression model with 1 categorical variable. Can you help? Thanks Laura

lmyers2 · ‎11-30-2017

Thanks so much for the help. Because I'm on a virtual desktop, I can't copy paste between virtual and where I can access my email. However, I attached a screenshot with the code and error log. The error says that finalfile is not valid even though that's the name of the dataset to read n. NOTE: Libref FINAL was successfully assigned as follows: Engine: V9 Physical Name: H:\CBS to run final analyses 441 proc copy in=finalfile out=finalfilefinally; ERROR: "FINALFILE" is not a valid name. ERROR: "FINALFILEFINALLY" is not a valid name. 442 select final; 443 run; NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE COPY used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: The SAS System stopped processing this step because of errors. 443! quit; libname final 'H:\CBS to run final analyses'; proc copy in=finalfile out=finalfile; select final; run; quit;

lmyers2 · ‎11-30-2017

Does the term "myfolder" have to be a compound name. The name of my merged data is finalfile but SAS gives me an error saying that's not a valid SAS name. Also, do I use this same name for the 'myData' term? Thanks!

lmyers2 · ‎11-30-2017

Hello, I'm using sas 9.4 full edition via a server. I have merged multiple excel files and can see in explorer that I have the dataset that I want. However, I'm having trouble making a sas7bdat file from which to do my analyses going forward. Does anyone have generic code for this? Thanks!

lmyers2 · ‎11-28-2017

Thank you, this works perfectly! In response to this "keep" statement, SAS literally only keeps the new variable, so I have to reload and remerge the datasets after I do this proc. Is there a way to tell SAS to keep all of the old variables in addition to the new variable? Thanks again - I really appreciate the help! Best Laura

lmyers2 · ‎11-27-2017

Thank you - that coding worked! Now if I want to find the most frequent comorbidity among the 34 columns, I should probably do an array as well but have to retain the characters instead of counting between apostrophes ' '. I think you had suggested doing each variable individually via proc freq but that was when there were only 3 columns.

lmyers2 · ‎11-27-2017

Thanks so much - if I used the following code you sent and there are up to 34 comorbidities, is there a quick way to code 1-34 without listing them all? Would I then have to use an array? Thanks Laura YOUR ORIGINAL CODE: data want; set have; n_comorbs = (comorbid1 > ' ') + (cormorbid2 > ' ') + (cormorbid3 > ' '); run;

lmyers2 · ‎11-27-2017

Hello, I'm using SAS 9.4 full version. I have the following sample data where the payments are formatted into a money variable. I want to code an array to keep the highest payment per line and maintain money formatting. Is an array the best way to do this? How do I maintain the money formatting? Payment1 Payment 2 Payment 3 Person 1 $500 . $750 Person 2 $100 . . Person 3 . $450 $400 I want: Highest Payment Person 1 $750 Person 2 $100 Person 3 $450 Thank you in advance for the help!

lmyers2 · ‎11-27-2017

Here is some sample data: Comorbidity1 Comorbidity2 Comorbidity 3 Patient 1 Diabetes Heart failure Chronic renal failure Patient 2 Chronic renal failure Diabetes . Patient 3 Diabetes . . For the first question, what I want is a table with descending frequencies of comorbidities: Diabetes 3 (most frequent) Chronic renal failure 2 Heart failure 1 For the second question, what I want is a count number for each patient: Patient 1 3 comorbidities Patient 2 2 comorbidities Patient 3 1 comorbidity

lmyers2 · ‎11-26-2017

Hello, I am using the full version of SAS 9.4 via a virtual desktop. I had two questions about coding an array. My data is in character format. 1. Each row is a different case and there are 3 columns of comorbidities. Patients can have 0-3 comorbidities but one person cannot have a repeated diagnosis. I am interested to know the overall most frequent diagnosis regardless of whether it is in position 1, 2 or 3. Is there a special name for an array like this? 2. Second, I would like to know the average number of comorbidities per person from the above data. How do I code this such that SAS counts and assigns a number of co-morbidities to each patient? Then I can do proc means to get the mean number. Thank you in advance for the help! Best Laura

lmyers2 · ‎11-21-2017

Thanks so much for looking at the code. Below is the proc import statement and data step, along with the proc contents result showing ASSERT_DATE as a numeric variable, and the error messages; they are all in the attachment if that is easier to read. proc import datafile='location' dbms=xlsx replace out=CBScontrolfile; sheet='case'; getnames=yes; run; proc sort data=CBScontrolfile; by CASE_ID; run; data CBScontrolfile; set CBScontrolfile; length NewASSERT_DATE 8; NewASSERT_DATE=input(ASSERT_DATE, yymmdd10.); format NewASSERT_DATE date9; run; proc contents position; run;

lmyers2 · ‎11-21-2017

Here are the data steps for each. I know the first line about length is redundant but I don't think it's the reason why it's not working for one file. CODE FOR CASES WHICH WORKS data CBScasefile; set CBScasefile; length NewASSERT_DATE 8; format NewASSERT_DATE date9.; NewASSERT_DATE=input(ASSERT_DATE, yymmdd10.); run; CODE FOR CONTROLS WHICH DOESN'T WORK data CBScontrol file; set CBScontrolfile; length NewASSERT_DATE 8; format NewASSERT_DATE date9.; NewASSERT_DATE=input(ASSERT_DATE, yymmdd10.); run; In the excel file that SAS is reading from, here is how a sample date is formatted n each file. CASE 2013-09-06 CONTROL 2003-01-20

lmyers2 · ‎11-21-2017

Thank you very much for responding. The file casefile.sas7bdat doesn't exist yet, because that was what I was trying to make! Do I make a SAS file first and then make it into a SAS library? I'm just confused what the difference is between a library and SAS file. My goal here is to make the file casefile.sas7bdat. Best Laura

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 array

question about array

categorical variables in proc logist

Re: making a sas7bdat file

Re: making a sas7bdat file

making a sas7bdat file

Re: questions about array coding

Re: questions about array coding

Re: questions about array coding

question about coding array for money and choosing highest payment

Re: questions about array coding

questions about array coding

Re: problem with coding data variable as numeric

Re: problem with coding data variable as numeric

Re: making a SAS library