cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ashwini_uci
‎04-25-2018
  • 189 Posts
  • 26 Likes Given
  • 0 Solutions
  • 2 Likes Received

Re: Keeping leading 0 while converting from character to numeric

by Obsidian | Level 7 in SAS Procedures
‎04-25-2018 10:53 PM
2 Likes
‎04-25-2018 10:53 PM
2 Likes
Thank you @Reeza! Compress function worked fine in getting rid of the quotations marks. Then I was able to convert the format to z5. It all finally worked. Thank you! ... View more

Re: Keeping leading 0 while converting from character to numeric

by Obsidian | Level 7 in SAS Procedures
‎04-25-2018 10:51 PM
‎04-25-2018 10:51 PM
Thank you @Astounding! That is what I was hoping to achieve, but the drop-down list does not know z5 format. So I ended up importing the data as is. Then i used the compress fucntion to get rid of the quotations marks first followed by converting the format to z5. It finally worked. ... View more

Re: Keeping leading 0 while converting from character to numeric

by Obsidian | Level 7 in SAS Procedures
‎04-25-2018 06:42 PM
‎04-25-2018 06:42 PM
I am using SAS enterprise and I am using the import data option from File menu and following the prompts. The data is being imported fine. But when I try to convert from character to numeric, it shows all misisng values and I think it is because of the quotation marks around the values. I am not sure how i can get rid of the quotation marks. They disappear when I choose the numeric option during the import process. In that case the quotation marks go away but the values end up missing the leading zeros as well. Hope this description helps.   ... View more

Re: Keeping leading 0 while converting from character to numeric

by Obsidian | Level 7 in SAS Procedures
‎04-25-2018 06:29 PM
‎04-25-2018 06:29 PM
Thank you Reeza. It is actually showing me all blanks after conversion because the values carry the single quotation marks. Is there any way i can get rid of those before conversion from character to numeric? ... View more

Keeping leading 0 while converting from character to numeric

by Obsidian | Level 7 in SAS Procedures
‎04-25-2018 06:03 PM
‎04-25-2018 06:03 PM
Hi, I use SAS enterprise. While importing a comma delimited excel -csv file into SAS, I want to convert the first column (A) from character filed to numeric field without losing the leading zeros. I selected w.d and bestw.d formats from the drop-down menu but the leading zeros were not retained. Is there any other format i can select to serve this purpose. I also want to get rid of the single quotation marks from the values under the columns. Any ideas/ suggestions/help are greatly appreciated!   I am attaching the sample of the file here..   ... View more

Re: Non parametric Cuzick test for trend in SAS

by Obsidian | Level 7 in Statistical Procedures
‎04-25-2018 05:54 PM
‎04-25-2018 05:54 PM
Thank you! ... View more

Re: Non parametric Cuzick test for trend in SAS

by Obsidian | Level 7 in Statistical Procedures
‎03-12-2018 04:49 PM
‎03-12-2018 04:49 PM
Is is possible for you to post the link (that you've shared in the following message) again? For some reason, it opens the same message window.   Thanks! Ashwini ... View more

Re: Non parametric Cuzick test for trend in SAS

by Obsidian | Level 7 in Statistical Procedures
‎03-12-2018 04:46 PM
‎03-12-2018 04:46 PM
Thank you! This was helpful!   Ashwini ... View more

Non parametric Cuzick test for trend in SAS

by Obsidian | Level 7 in Statistical Procedures
‎01-25-2018 08:04 PM
‎01-25-2018 08:04 PM
Hi, I have used following code to obtain percentages for some cardiac procedure complications, over the period of 10 years.   proc freq data=library.CRT;  tables (died complication1 complimortality majorcompli majcomplimortality hemreqtrans) *year /chisq; where crt51=1; Title 'Table 2- yearwise- 0051'; run;   I got the ouput that look like this:       To test the trend I need to obtain the p value  ( to compare 10 counts of percentages over 10 years),by using Cuzick test for trend in SAS. Is there any easy/simple way without using any macro to accomplish this in SAS? I have never used this test before.    Any help would be greatly appreciated!   Thanks, Ashwini                     ... View more

Re: DO Loop and ARRAY

by Obsidian | Level 7 in SAS Programming
‎01-19-2018 05:09 PM
‎01-19-2018 05:09 PM
Thank you!   So I want to include these codes below   5820,5821....58231..5824.... 58281, 58289,  and there are quite a lot of them. But is there any way to ask in your SAS code to return all ICD9 numbers that start with 582 and may end up being 4 and 5 digit long numbers,  instead of including them all in the code?   or (dxmslivedis(i)=:'582')       ... View more

Re: DO Loop and ARRAY

by Obsidian | Level 7 in SAS Programming
‎01-18-2018 09:41 PM
‎01-18-2018 09:41 PM
Also for a range including  the following codes 5820,5821..58231..5824, 58281, 58289, is there a way to ask the SAS code to return all ICD9s that start with 582?  ... View more

Re: DO Loop and ARRAY

by Obsidian | Level 7 in SAS Programming
‎01-18-2018 09:25 PM
‎01-18-2018 09:25 PM
I have a quick question: In the array above, I want to define range as 25300-25099 ('25030'<=dxmslivedis(i)<='25099') By the very nature of ICD9 code format, the sequence will go like this - 25030,25031,.....,25040,25041,25050....25070...25099. and then the codes for next diagnosis begin from 2501 which I am not interested in.   What will be the best way to define range here if I don't know the upper level code for every diagnosis that wish to code? In this particular case I happen to know the higher/upper level of range will be 25099.  If I use this following sequence, not sure if it will capture all and ONLY the codes between 25030-25099? ('25030'<=dxmslivedis(i)<'2501')   ... View more

Re: DO Loop and ARRAY

by Obsidian | Level 7 in SAS Programming
‎01-18-2018 06:33 PM
‎01-18-2018 06:33 PM
Thank you very much! It worked with no errors. I'd be careful about the string variables. Appreciate it!   Ashwini ... View more

Re: DO Loop and ARRAY

by Obsidian | Level 7 in SAS Programming
‎01-18-2018 06:29 PM
‎01-18-2018 06:29 PM
so the same variables used in defining the array : dx1-dx25, these are 25 variables that may contain the icd9 codes included in that range.  The variables look some thing lie below. Hope it makes sense      ... View more

Re: DO Loop and ARRAY

by Obsidian | Level 7 in SAS Programming
‎01-18-2018 06:17 PM
‎01-18-2018 06:17 PM
Thank you but my question is how to add range of codes as this '4560'- '4562'  and  '5722'- 5728' in addition to the specific ICD 9 codes.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-25-2018 11:32 PM
Likes given to
Likes from
View All
Quick links