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: 
GS2
‎10-25-2024
  • 247 Posts
  • 1 Likes Given
  • 0 Solutions
  • 5 Likes Received

if then statement

by Obsidian | Level 7 in SAS Programming
‎09-26-2018 12:24 PM
‎09-26-2018 12:24 PM
Using SAS 9.4    data raw.breast (where=(DIAG_PRTY_SEQ_NBR =1)); set raw.EDVISITS_BREAST; IF DIAG_DESC = 'pain' then DIAG_DESC2 = 'Pain'; IF DIAG_DESC = 'nausea' then DIAG_DESC2 = 'Nausea';  run;   I am trying to create a new variable and use a wildcard to capture any instance where the word 'pain' is used and group it together into a single bucket 'Pain' category. My code is creating the new variable but is not pulling anything into that column. Any help would be great. Thank you! ... View more

Proc format wildcards

by Obsidian | Level 7 in SAS Programming
‎09-19-2018 11:31 AM
‎09-19-2018 11:31 AM
Using SAS 9.4   I am trying to use the wildcard while writing a format to avoid spelling out each item. Am I using the wildcard incorrectly? Any thoughts? Thank you       I have attached my code as screenshot as well ( I have run at the bottom it is just not captured) PROC FORMAT; VALUE $RACE_DESC 'AMERICAN INDIAN:' = 'AMERICAN INDIAN/ALASKAN NATIVE' 'JAPANESE','FILIPINO','VIETNAMESE','OTHER ASIAN','ASIAN INDIAN:' = 'ASIAN' 'WHITE' = 'CAUCASIAN' 'BLACK' = 'AFRICAN AMERICAN' 'OTHER' = 'OTHER RACE' 'UNKNOWN' = 'UNKNOWN RACE'; VALUE $ETHNICITY_DESC 'MEXICAN','SPANISH:','SOUTH:' = 'HISPANIC/LATINO' 'NON-SPANISH' = 'NON-HISPANIC/LATINO' 'UNKNOWN:' = 'UNKNOWN ETHNICITY'; VALUE $TUMOR_STAGE '0' = 'STAGE 0' 'IA','IB' = 'STAGE I' 'IIA','IIB' = 'STAGE II' 'IIIA','IIIB','IIIC' = 'STAGE III' 'IV' = 'STAGE IV' 'NA','UNK' = 'UNKNOWN/NOT APPLICABLE'; value $PRIMARY_PAYER_DESC 'INSURANCE STATUS UNKNOWN','UNKNOWN 01','UNKNOWN 02' = 'UNKNOWN' 'NOT APPLICABLE' = 'NOT APPLICABLE' 'MEDICAID:' = 'MEDICAID' 'MEDICARE:' = 'MEDICARE' 'INSURANCE, NOS' = 'INSURANCE, NOS' 'MANAGED CARE PROVIDER, HMO, PPO','PRIVATE INSURANCE: FEE-FOR SERVICE' = 'PRIVATE INSURANCE' 'TRICARE' = 'SELF PAY/OTHER'; run;   ... View more

Re: 95% confidence intervals

by Obsidian | Level 7 in Statistical Procedures
‎09-06-2018 01:51 PM
‎09-06-2018 01:51 PM
What if alpha=0.05 does not work I guess should have been my question. I tried to set that and it still report it as a 99% CI ... View more

95% confidence intervals

by Obsidian | Level 7 in Statistical Procedures
‎09-06-2018 01:43 PM
‎09-06-2018 01:43 PM
Using SAS 9.4   I did a proc freq: to return my descriptive and pvalue statistics. When I run it, it returns: SAS Output Statistic DF Value ProbChi-SquareLikelihood Ratio Chi-SquareMantel-Haenszel Chi-SquarePhi CoefficientContingency CoefficientCramer's VWARNING: 100% of the cells have expected counts lessthan 5. Chi-Square may not be a valid test.   SAS Output Statistic DF Value ProbChi-SquareLikelihood Ratio Chi-SquareMantel-Haenszel Chi-SquarePhi CoefficientContingency CoefficientCramer's VWARNING: 100% of the cells have expected counts lessthan 5. Chi-Square may not be a valid test. 336 519.2845 <.0001 336 204.4836 1.0000 1 . .   1.6532     0.8556     0.8266   Fisher's Exact TestTable Probability (P) <.0001 Monte Carlo Estimate for the Exact TestPr <= P99% Lower Conf Limit99% Upper Conf Limit Number of SamplesInitial Seed 0.0338 0.0291 0.0385   10000 30061001 Sample Size = 190 For my confidence intervals, they are default at 95%. Does SAS automatically convert my CIs to 99% if the pvalue is less than that level? If so, is their any way to return it at the 95% CI level as the rest of my results are at the 95% CI level? Thank you       code for my proc freq: proc freq data = RAW.PRESENTS_04SEPT2018 (where=(used_recommendation ne 'N/A')); tables insurance_status_at_testing*hh_inc_med/list missing nocum; title 'Insurance status at testing pvalue'; exact fisher /mc; run; ... View more

Re: error expecting arithmetic operator

by Obsidian | Level 7 in SAS Programming
‎07-26-2018 09:25 AM
‎07-26-2018 09:25 AM
data work.RUCA_class; set work.RUCA_class; length cat_A $35; if RUCA30 = ('1.0','1.1','2.0','2.1','3.0','4.1','5.1','7.1','8.1','10.1') then cat_A = 'Urban Focused'; if RUCA30 = ('4.0','4.2','5.0','5.2','6.0','6.1') then cat_A = 'Large Rural City/Town (micropolitan) focused'; if RUCA30 = ('7.0','7.2','7.3','7.4','8.0','8.2','8.3','8.4','9.0','9.1','9.2') then cat_A = 'Small Rural Town Focused'; if RUCA30 = ('10.0','10.2','10.3','10.4','10.5','10.6') then cat_A = 'Isolated Small Rural Town Focused'; run;     I converted the variable to a character and added the length but I am still getting the same error message. Am I not creating the variable 'cat_A' properly? ... View more

error expecting arithmetic operator

by Obsidian | Level 7 in SAS Programming
‎07-26-2018 08:48 AM
‎07-26-2018 08:48 AM
Hi I am using SAS 9.4 and trying to create a new variable to include the following code   data work.RUCA_class; set raw.raw_ruca18; if RUCA30 = 1.0 1.1 2.0 2.1 3.0 4.1 5.1 7.1 8.1 10.1 then cat_A = 'Urban Focused'; if RUCA30 = 4.0 4.2 5.0 5.2 6.0 6.1 then cat_A = 'Large Rural City/Town (micropolitan) focused'; if RUCA30 = 7.0 7.2 7.3 7.4 8.0 8.2 8.3 8.4 9.0 9.1 9.2 then cat_A = 'Small Rural Town Focused'; if RUCA30 = 10.0 10.2 10.3 10.4 10.5 10.6 then cat_A = 'Isolated Small Rural Town Focused'; run;   When I run this I get an error expecting an arithmetic operator. Any help on why this is not working would be great. Thank you! ... View more

Format KM curve with median survival line

by Obsidian | Level 7 in Graphics Programming
‎04-11-2018 10:36 AM
‎04-11-2018 10:36 AM
Hello,   Using SAS 9.4   Is their a way to add a median survival line to a KM curve? Thanks ... View more

Re: Fisher test with Monte Carlo

by Obsidian | Level 7 in SAS Programming
‎03-29-2018 10:29 AM
‎03-29-2018 10:29 AM
Is their a way to write that into my sas format code so that I can name the missing values? Thank you ... View more

Re: Fisher test with Monte Carlo

by Obsidian | Level 7 in SAS Programming
‎03-29-2018 10:02 AM
‎03-29-2018 10:02 AM
I am using 'other'  to code for missing data. Would it be more effective to use '.' to code for the missing data? ... View more

Fisher test with Monte Carlo

by Obsidian | Level 7 in SAS Programming
‎03-29-2018 08:02 AM
‎03-29-2018 08:02 AM
Using SAS 9.4   Hello,   I have formatted a variable race proc format; value $Race 'C' = 'Caucasian' 'AA' = 'African American' other = 'Unknown/Other'; run;   and this works for some tests, (eg) proc freq data = mylib.a (where=(Used_recommendation = 'Yes')); tables  Race /chisq list missing nocum; format  Race $Race.; title Table 1. ‘Demographics’; run;   However my format does not work when I run a fisher exact test with monte carlo estimates (eg) proc freq data = mylib.a; tables Used_recommendation*Race; format Race $Race.; exact fisher /mc; run;   It comes up with my Caucasian and African American groups but neglects the other/unknown category. Am I doing something wrong? Is their a better way to write my code so that it would work? Thank you ... View more

Combing muliple proc freq tables into one table

by Obsidian | Level 7 in SAS Programming
‎03-16-2018 12:00 PM
‎03-16-2018 12:00 PM
SAS 9.4 I am running multiple demographics from a proc freq, how do I combine them so that they are in one table and not multiple tables? Thanks   proc tabulate data = mylib.a; tables Age_Group Race Gender Ethnicity Smoking_status nocum; format Age_Group Age_Group. Race $Race. Gender $Gender. Ethnicity $Ethnicity.; run;   Also, a couple of the variables have blank/missing data from a cell, is their a way to remove the row with the missing data so that I do not have a row with a blank label and a frequency and percent beside it? Thank you ... View more

Re: changing character to a number

by Obsidian | Level 7 in SAS Programming
‎03-13-2018 02:01 PM
‎03-13-2018 02:01 PM
proc import OUT=mylib.a DATAFILE= DBMS=xlsx REPLACE; SHEET= 'sheet3'; GETNAMES=YES; RUN;   This is my import statement.   the variable is second_tx_start_date, what would an input function look like to convert from character to number? ... View more

changing character to a number

by Obsidian | Level 7 in SAS Programming
‎03-13-2018 01:53 PM
‎03-13-2018 01:53 PM
Using SAS 9.4   How do I change an imported date that should be in date format to date format? SAS imported it as a character.  Thanks     ... View more

Pvalue and formatting

by Obsidian | Level 7 in SAS Programming
‎03-13-2018 08:08 AM
‎03-13-2018 08:08 AM
Hello,   Using SAS 9.4 I have a couple questions about formatting and pvalue that I would like to ask. 1) How do I put a pvalue into a crosstabs tables? 2) Is their a way to remove the cumulative frequency and cumulative percent in the crosstabs (I am using list missing so the frequency and percent are the last 2 columns of the table) and put the pvalue in its place?   proc format;       value $Race       'C'         =     'Caucasian'                               'AA'  =     'African American'                               'A'         =     'Asian'                               'O', 'U'=   'Other/Unknown';   proc freq data = mylib.a (where=(Used_a_recommendation ne 'N/A'));  tables Used_a_recommendation*Race /list missing;       format Used_a_recommendation $Used_a_recommendation. Race $Race.;       title Table 8. Used a Recommendation crosstabs by Race; run;   Thank you! ... View more

Re: remove a variable while formatting

by Obsidian | Level 7 in SAS Programming
‎03-08-2018 10:11 AM
‎03-08-2018 10:11 AM
That worked perfectly. Thank you! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-25-2024 10:29 AM
Likes given to
View All
Likes from
View All
Quick links