About chelsealutz

chelsealutz · ‎10-28-2016

Hi all, So I know there have been a lot of threads about this issue, but none of the solutions listed seem to be working for me. I have tried: data new; set '\\***.gov\project\***_***_Store1\**\***\Surveys for ********\**** **\2015-2016 *\Deliverables\2016 04 deliverables\Analytic files\hcp_analyt.sas7bdat'; run; and libname work '\\***.gov\project\***_***_Store1\**\***\Surveys for ********\**** **\2015-2016 *\Deliverables\2016 04 deliverables\Analytic files\hcp_analyt.sas7bdat'; proc print data=work.'\\***.gov\project\***_***_Store1\**\***\Surveys for ********\**** **\2015-2016 *\Deliverables\2016 04 deliverables\Analytic files\hcp_analyt.sas7bdat'; run; Both to no avail. I'm clearly missing something, and knowing me it's pretty obvious, but could someone please clear things up? Is it the length of my file name perhaps? The asterisks are actually words in my actual file, I just can't post the actual file. The spaces are actual spaces in my file name. The first code starts to work, but generates these errors: .......... ERROR: The format REGION_RAKE was not found or could not be loaded. ERROR: The format GENDER_RAKE was not found or could not be loaded........ (an error for each) NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0 observations and 432 variables.

chelsealutz · ‎03-09-2016

But will I have to repeat that code for every 550 observations? It appears you have to put in the specific year, month, and day?

chelsealutz · ‎03-09-2016

Good morning experts! I'm wondering if the following scenario is even possible in SAS - trying desperately to avoid having to do it by hand... I have 550 observations. Among my variables, I have the year the child was born, the month the child was born, the day the child was born (so, essentially, the birthdate split into three variables), child's age in months at the time of survey, and the date (year, month, day) that they recevied a vaccine. Is there a way to calculate how old in months each child was when they received their vaccine according to the record, or do I just need to go through all 550 and do that on my own? Hoping someone has an idea! Thanks in advance!

chelsealutz · ‎02-25-2016

Sorry all - it was as @Reeza pointed out and my arrays didn't match. Thank you though!

chelsealutz · ‎02-25-2016

I noticed that literally as soon as I posted the discussion - I thought I deleted it. Guess that's what I get for copy/paste. Thanks though!

chelsealutz · ‎02-25-2016

Hello all! I know there are a ton of "subscript out of range" posts on here, but none of them have helped me identify my problem... data want; data have; array barriers(19) $ unawareneed_86 unawarelaterdose_86 unawaretimeplace_86 fearsideeffects_86 longdistanceimmsite_86 toobusy_86 nopermission_86 postponed_86 heardneg_86 timeinconvenient_86 vaccinatorabsent_86 vaccinena_86 famprob_86 childillnottaken_86 childilltakendidnotreceive_86 lackoffaithinimm_86 longwaittime_86 lackoftrustinstaff_86 other_86; array barriercited(19) barriercited1-barriercited19; do i=1 to 19; if barriers(i)='Yes' then barriercited(i)=1; else if barriers(i)='No' then vacchx(i)=0; end; numberbarriers=sum(of barriercited(*)); run; I keep getting this error: "ERROR: Array subscript out of range at line 13972 column 43" (although the numbers tend to change when I re-run it each time. Hoping fresh eyes will help! Thanks!

chelsealutz · ‎02-25-2016

Thank you for clarifying! And @Reeza, thank you for that first step!

chelsealutz · ‎02-25-2016

I'm afraid I got this error: Proc freq data=stacked; 1425 By dist; 1426 Table tb*dset; 1427 Run; NOTE: Writing HTML Body file: sashtml.htm ERROR: Data set WORK.STACKED is not sorted in ascending sequence. The current BY group has dist = Samfya and the next BY group has dist = Luwingu. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 343 observations read from the data set WORK.STACKED. NOTE: PROCEDURE FREQ used (Total process time): real time 1.29 seconds cpu time 0.32 seconds And this output: The FREQ Procedure dist=Chienge Frequency Percent Row Pct Col Pct Table of tb by Dset tb Dset data1 Total 1 2 Total 124 72.94 100.00 72.94 124 72.94 46 27.06 100.00 27.06 46 27.06 170 100.00 170 100.00 Which is obviously only half of what I want. I apologize for being so new, I just don't know what this code is doing exactly. I understand combining the two datasets, but what exactly is the indsname option, or "source?" Data stacked; Set data1 data2 indsname=source; Dset=source; Run; Proc freq data=stacked; By district; Table tb*dset; Run; That is what I ran...

chelsealutz · ‎02-24-2016

Hi experts! So, I have two datasets, a midline and an endline. They have identical variables (different observations though, obviously) and I want to be able to compare changes in frequencies, etc between the two without having to go line by line in my output tables from each respective data sets' proc freq. I have 4 districts I'm looking at, and all of my proc freqs are stratified by these districtss. So, for example, what if I want to know the differences between how many said x, y, or z in response to indicator 4, from each set? Is there a way to do this? I found this macro: http://www2.sas.com/proceedings/sugi26/p097-26.pdf but to be honest I have no idea how to input the info related to my data sets. I also tried proc compare, but I have no idea what the output means. As I'm sure you can tell, I'm pretty limited in my SAS knowledge and have been having trouble with the more nuanced procedures/code. ANY help at all would be greatly appreciated! Thank you!

chelsealutz · ‎02-23-2016

Unfortunately I've been all over the boards and haven't found anything useful. I've also read several papers - I just can't seem to locate the syntax for an all-possible. In addition, I was hoping someone could break it down for me in less technical language so I could really understand AIC/Cp/etc...

chelsealutz · ‎02-23-2016

@mohamed_zaki Would you please be able to tell me how to do multiple conditions in one If-Then statement? (I, too, was fooled by the title of this thread). I am trying: if (opv0_card='Yes') & (opv0_recall=. or 'Yes') then opv0=1; else if (opv0_card=.) & (opv0_recall='Yes') then opv0=2; else opv0=3; But unfortunately none of my '3' values are showing up, and way too many are being sorted into my '2' values... I would really appreciate your help! Thanks!

chelsealutz · ‎02-23-2016

Hello all! I need to fit a logistic regression model and am wondering which model-seletion method would be best. I have been advised to stay away from forward/backward/stepwise regression. All-possible-regression seems attractive, but I must admit I'm a little lost on AIC/BIC/Cp/etc and exactly how I would go about picking the best model... I have a binary response variable, a categorical predictor, 10 categorical covariates, and 2 continuous covariates. Thank you in advance!

chelsealutz · ‎02-22-2016

The colon did the trick! Thank you very much for all of your help!

chelsealutz · ‎02-22-2016

I went ahead and added the "<=" and that's what ended up "fixing" part of it - originally it was more than just the "Strongly Disagree" that were missing; now, it's just those. I notice in my proc print output that it only displays "Strongly Disag." Could that be the problem? I assumed because my code still said "Strongly Disagree" that it didn't matter what the output display was. If so, how would I fix that?

chelsealutz · ‎02-22-2016

I'm afraid that's a little (and by that I mean very) outside of my understanding of SAS.

Online Status	Offline
Date Last Visited	‎10-31-2016 01:39 PM

How to import a .sas7bdat into SAS 9.4

Re: Calculate age at time of event

Calculate age at time of event

Re: Error: Array subscript out of range

Re: Error: Array subscript out of range

Error: Array subscript out of range

Re: Comparing same variable (freq, count, etc) from two datasets

Re: Comparing same variable (freq, count, etc) from two datasets

Comparing same variable (freq, count, etc) from two datasets

Re: Best Fit Logistic Regression Model

Re: Error: Array subscript out of range

Re: Comparing same variable (freq, count, etc) from two datasets

How to import a .sas7bdat into SAS 9.4

Re: Calculate age at time of event

Calculate age at time of event

Re: Error: Array subscript out of range

Re: Error: Array subscript out of range

Error: Array subscript out of range

Re: Comparing same variable (freq, count, etc) from two datasets

Re: Comparing same variable (freq, count, etc) from two datasets

Comparing same variable (freq, count, etc) from two datasets

Re: Best Fit Logistic Regression Model

Re: Multiple conditions in one if statement

Best Fit Logistic Regression Model

Re: Array Made Data Go Missing

Re: Array Made Data Go Missing

Re: Array Made Data Go Missing