About Ashwini_uci

Ashwini_uci · ‎01-18-2018

Hi, I am trying to create one variable (liverdis)using the values contained in 25 other variables (dx1-dx25). The values are basically ICD 9 codes. I want to select some specific codes and range of codes of these ICD9s that would form this new variable. I am not quite sure how I can incorporate the range of these ICD9s in one single array. This is what I have at present- it contains individual specific codes -07022' '07023' '07044 and the code runs just fine. data library.CRT1; set library.CRT1; array dxmslivedis{25} dx1-dx25; if cmiss(of dx1-dx25)=25 then call missing(liverdis); else do; do i=1 to 25; if dxmslivedis {i} in('07022' '07023' '07044') then do; liverdis=1; return; end; else liverdis=0; end; end; run; But in the above SAS code, in addition to the specific ICD 9 codes, I also want to add range of codes as this '4560'<=dxmslivedis<='4562' or '5722'<=dxmslivedis<='5728' I tried different ways to add but then the above code doesn't run without showing errors. Any help/suggestions would be welcome! Thank you! A

Ashwini_uci · ‎02-05-2015

Thanks very much Steve.! I tried the above code by using another example.Regionwise afib hospitalizations. I am attaching the output to the original posts. I am not sure how to interprete the results though. For this analyses, I am referring to a published article and I've highlighted the part that I am trying to do for my analyses.In that paper, they have mentioned the posthoc comparisons in 3 figures which I have highlighted in the article and attached it to the oiginal post. I have made similar graphs and and my results are quite similar to theirs so I would like to do the posthoc comparisons as well. I have also attached my own results in the original post. Please take a look and if yo could advise on how I can obtain those p values; for the post-hoc comparisons ,that would bevery helpful!

Ashwini_uci · ‎02-03-2015

Hi, I am working on a cross table, for instance for the cross table Hospital regions vs ARF-NoARF hospitalizations, it would be 2 x 4 cross table and the p value yielded is applicable to the whole tables combined. How do I get the p values for difference between ARF-NOARF admissions for each region separately, the poct-hoc comparisons? I am attaching a part of the table and its figure here to this post.I want the p values for the highlighted #s in the table. I have also plotted them on the graph next to the table. All I need is the p values for the red/blue bars for each region. The overall p value that’s shown in the table is the combined p value. But in the graph you see that the ARF and NIS %s are very different for northeast and South regions but NOT very different for Midwest and West regions. So how do I get those p values exactly, separate for each region from this table that would allow me say if they are significant or not? SO basically the code I have used is below and that’s how I got the table below and I created the graph. You can take a look at the Figure 3 in that paper and read the description right below it. proc freq; table arf hospitalization *region /chisq; run;quit; Any help would be greatly appreciated! Thanks, Ashwini

Ashwini_uci · ‎01-21-2015

@ Ballardw: thanks for your elaborate response! Appreciate it! But me being just a intermidiate level programmer, it was difficult for me to follow this. I use SAS mostly to do stats so not much aware of most formatting/programming aspects of SAS procs.

Ashwini_uci · ‎01-21-2015

Thanks very much Cynthia for your timely response! It was helpful and it worked! It worked for the cross tables using Proc freq. However it didn't work for the proc freq for plain frequncies. Any idea what the reason may be? Is there any way I can get the whole numbers in the plain frequencies (no cross tables). Thanks again! Here are my codes: proc freq data= library.nis0111ARFall; Didn't work for this. tables amonth season female racecat income hosp_region hosp_location hosp_teach year died/ missing format= BEST16.; weight discwt; run; *Bivariate*/; proc freq data= library.nis0111ARFall; Worked for this one tables female*died hosp_region*died hosp_location*died hosp_teach*died racecat*died racenew*died income*died hosp_region * year/ chisq format=BEST16.; weight discwt; run;

Ashwini_uci · ‎01-20-2015

Below is the code and all numbers inthe output should be weighted numbers.. proc freq data= library.nis0111ARFall; tables amonth season female racecat income hosp_region hosp_location hosp_teach year died)/ missing; weight discwt; run;

Ashwini_uci · ‎01-20-2015

HI , I am working with a dataset with roughly 87 million cases (87,195,470 to be exact). And the SAS output that is generated is showing some of the numbers in a different format. For instance; as below; Any suggestions how I can get SAS to show we whole numbers or how to manually convert these results to get a correct whole number?Any help would be greatly appreciated. Best, Ashwini 1 2.155E8 50.52 97.67 51.59 5142105 1.21 2.33 58.34 2.206E8 51.72 2 4.566E7 10.71 98.07 10.93 899689 0.21 1.93 10.21 4.656E7 10.92 3 4.192E7 9.83 98.71 10.04 545909 0.13 1.29 6.19 4.247E7 9.96 4 8327958 1.95 97.97 1.99 172916 0.04 2.03 1.96 8500874 1.99 5 1.277E7 2.99 98.33 3.06 217178 0.05 1.67 2.46 1.299E7 3.05 6 9.354E7 21.93 98.07 22.39 1836836 0.43 1.93 20.84 9.537E7 22.36 Total 4.177E8 97.93 8814633 2.07 4.265E8 100.00 Frequency Missing = 451436.57331

Ashwini_uci · ‎11-14-2014

Well, I guess it has nothing to do with how the data is created. I am getting the same error for copying the data created by data/set statement as well.

Ashwini_uci · ‎11-14-2014

I am trying to copy the file from one library to another and I am getting folowing error message: ERROR: A lock is not available for LIBRARY.NISALL11.DATA. ERROR: File LIBRARY.NISALL11.DATA has not been saved because copy could not be completed. This is the file that was created using proc append. The file created using data/set statement was copied successfully. I am not sure what the above errros means and how to fix it so that the file is copied successfully.

Ashwini_uci · ‎11-12-2014

Thanks for suggesting this way. It has worked. I have another question. As far as further analyses is concerned; analyses such as multivariate regression and running some macros on the data, does it matter how the data is stacked, using data/set step or using proc append? Should I be anticipating any warning or errors based on how the data is appended? The reason I am asking this question because the data /set step really long to append the data compared to the proc append procedure. The proc append took hardly a few minutes to append all 10 yrs of data and the data/set step took almost over an hour to append all the data.

Ashwini_uci · ‎11-11-2014

I do have data for each year with 90% variables that are same..some have a few additonal ones and some don't /.I will try what you have suggested. Thanks!

Ashwini_uci · ‎11-10-2014

Hi, I tried using Proc append with force option and the log yield errors for appending the first it year's data itself. I am attaching the log to theoriginal post for your reference. It did not add the variables that were missing in the base databse. How can I have it add the new variables to the base data and also in the cases if some are missing from the new dataset? Should I just use data and set step to avoid all these errors? Thanks!

Ashwini_uci · ‎11-04-2014

Hi, I am working on NIS (Nationwide Inpatient Sample) database and I am going to have to combine/stack data for 10 years. There are numerous variables in this data but a few years do not have certain variables/columns in them so the information for those variables is missing from them. My question is what would be the best SAS code/procedure to perform this operation of stacking these 10 yrs of data. is the Data/Set procedure is fine or proc append is approrpiate? I had used the data/set procedure in the past to stack 3 years of data and all the columns from all 3 years were stacked properly, and the columns were also created in the final stacked version of the data, if any of the years didnot include that particular column/variable which was present in some other year. I thougtht of asking this question before proceeding with this as I just want to make sure I am heading in a right way with this as it involves a huge amount of data. Any suggestions, ideas, tips will behighly appreciated. Thanks! Ashwini

Ashwini_uci · ‎09-27-2014

Yes, I did. it all looks right. Thanks a lot again!

Ashwini_uci · ‎09-27-2014

Oh great, the 'truncover' worked! Thanks very much Reeza! That was a tremendous help. I can meet my deadline tonight

Online Status	Offline
Date Last Visited	‎04-25-2018 11:32 PM

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Keeping leading 0 while converting from character to numeric

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Non parametric Cuzick test for trend in SAS

Re: DO Loop and ARRAY

Re: Keeping leading 0 while converting from character to numeric

Re: Keeping leading 0 while converting from character to numeric

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Re: Non parametric Cuzick test for trend in SAS

Re: Keeping leading 0 while converting from character to numeric

DO Loop and ARRAY

Re: Post-hoc comparisons_obtaining p value for in-between group compar...

Post-hoc comparisons_obtaining p value for in-between group comparison...

Re: How to convert the format of the numbers in SAS results

Re: How to convert the format of the numbers in SAS results

Re: How to convert the format of the numbers in SAS results

How to convert the format of the numbers in SAS results

Re: Stacking data of 10 years

Re: Stacking data of 10 years

Re: Stacking data of 10 years

Re: Stacking data of 10 years

Re: Stacking data of 10 years

Stacking data of 10 years

Re: Converting text file (nont-delimited) into SAS file

Re: Converting text file (nont-delimited) into SAS file