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: 
raheleh22
14 hours ago
  • 29 Posts
  • 22 Likes Given
  • 1 Solutions
  • 1 Likes Received

PROC GLIMMIX not giving AIC after adding random effect

by Obsidian | Level 7 in Statistical Procedures
yesterday
yesterday
Hi,  I've been using Proc Glimmix to predict the effect of several predictor variables on my outcome where the distribution is negative binomial. for the purpose of model comparision when I run the following code I receive the AIC tests: proc glimmix data=modelupdated; class metcat(ref="2") age_new(ref="1") sexnum (ref="2") race(ref="2"); model Rate_12= age_new sexnum race metcat/ dist=nb link=log s; run; However when I add the random effect of counties, I do not receive the AIC in fit stati table in the output.  proc glimmix data=modelupdated1; class metcat(ref="2") age_new(ref="1") sexnum(ref="2") race(ref="2"); model Rate_12 = age_new sexnum race ave_uninsured metcat / dist=nb link=log s; random intercept /type=un subject=fips_all_digit_num ; run;   any thoughts on this and how I can get AIC becuse I need to compare the two different models vs eacg other.  Thank you,    ... View more

Re: PROC SQL LEFT JOIN HAPPEND BUT NO VALUE IS SHOWN

by Obsidian | Level 7 in SAS Programming
2 weeks ago
2 weeks ago
the mutual columns in these two tables are county_name_all and state_name_all and that is why i am doing the join based on these two. I have double checked and they are same in every thing in both excels. i even check and their excel format are same too. but still I have the problem  ... View more

PROC SQL LEFT JOIN HAPPEND BUT NO VALUE IS SHOWN

by Obsidian | Level 7 in SAS Programming
2 weeks ago
1 Like
2 weeks ago
1 Like
Hi,  I am using proc sql left join to merge my two excels on based on two mutual columns they have.  here is the code I use:  proc sql; CREATE TABLE FINALV3 AS SELECT * FROM WNPOP LEFT JOIN pop2012 ON WNPOP.State_Name_All=pop2012.State_Name_All AND WNPOP.County_Name_All=pop2012.County_Name_All; QUIT; while the proc happened and I can see the columns joined and the number of obs are correct, I do not have values in the joined columns. (THERE IS NO ERROR in the LOG ).  any ideas of what is going wrong?    ... View more

Re: if then esle delete no error but still get 0 obs

by Obsidian | Level 7 in SAS Programming
4 weeks ago
4 weeks ago
yes, the esle if statement did work. thank you so much.  ... View more

if then esle delete no error but still get 0 obs

by Obsidian | Level 7 in SAS Programming
4 weeks ago
4 weeks ago
Hi,  I am trying to filter some of my data and create a new dataset. using the following syntax: data YYY; set XXX; if DeathCause_ICD in ("A923", "A9231","A9232","A9239") THEN disease1=1; IF condition_rec_1 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_2 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_3 in ("A923", "A9231","A9232","A9239") then disease1=1; IF condition_rec_4 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_5 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_6 in ("A923", "A9231","A9232","A9239") then disease1=1; IF condition_rec_7 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_8 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_9 in ("A923", "A9231","A9232","A9239") then disease1=1; IF condition_rec_10 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_11 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_12 in ("A923", "A9231","A9232","A9239") then disease1=1; IF condition_rec_13 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_14 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_15 in ("A923", "A9231","A9232","A9239") then disease1=1; IF condition_rec_16 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_17 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_18 in ("A923", "A9231","A9232","A9239") then disease1=1; IF condition_rec_19 in ("A923", "A9231","A9232","A9239") then disease1=1; if condition_rec_20 in ("A923", "A9231","A9232","A9239") then disease1=1; else delete; RUN;   While I am not receinving any error in the log, still my syntax not working and giving me 0 observations.  I have used this syntax multiple times and i canot figure out wher it is going wront. any thoughts appreciated.  ... View more

PROC SQL GROUP BY STATE AND COUNTY FIPS

by Obsidian | Level 7 in SAS Procedures
‎02-15-2024 08:54 PM
‎02-15-2024 08:54 PM
I am working on a nationwide dataset where has my outcome variable at both county and state level. ealier I used PROC SQL  and group by statement to get a total deaths by state and here is my code:  proc sql; create table test1 as select *, count(*) as total_deaths from aggregatedallv1 group by State_Occurrence_FIPS  quit; this gave me a columns as total per State. Now I wonder how to get total per county group by State.  any advice is much appreciated.  ... View more

IF THEN ELSE DELETE SYNTAX

by Obsidian | Level 7 in SAS Programming
‎12-09-2023 10:36 AM
‎12-09-2023 10:36 AM
Hi,  I am trying to filter a huge dataset to locations of interest and here is the syntax I developed. I am not sure why SAS only is filtering my last line and not the whole locations I selected in my IF statements. Any thoughts on this is much appreciated:  data XXX; set YYY; IF GEOID=38001 THEN LOCATION="Adams County"; IF GEOID=38003 THEN LOCATION="Barnes County"; IF GEOID=38005 THEN LOCATION="Benson County"; IF GEOID=38007 THEN LOCATION="Billings County"; IF GEOID=38009 THEN LOCATION="Bottineau County"; IF GEOID=38011 THEN LOCATION="Bowman County"; IF GEOID=38013 THEN LOCATION="Burke County"; IF GEOID=38015 THEN LOCATION="Burleigh County"; IF GEOID=38017 THEN LOCATION="Cass County"; IF GEOID=38019 THEN LOCATION="Cavalier County"; IF GEOID=38021 THEN LOCATION="Dickey County"; IF GEOID=38023 THEN LOCATION="Divide County"; IF GEOID=38025 THEN LOCATION="Dunn County"; IF GEOID=38027 THEN LOCATION="Eddy County"; IF GEOID=38029 THEN LOCATION="Emmons County"; IF GEOID=38031 THEN LOCATION="Foster County"; IF GEOID=38033 THEN LOCATION="Golden Valley County"; IF GEOID=38035 THEN LOCATION="Grand Forks County"; IF GEOID=38037 THEN LOCATION="Grant County"; IF GEOID=38039 THEN LOCATION="Griggs County"; IF GEOID=38041 THEN LOCATION="Hettinger County"; IF GEOID=38043 THEN LOCATION="Kidder County"; IF GEOID=38045 THEN LOCATION="LaMoure County"; IF GEOID=38047 THEN LOCATION="Logan County"; IF GEOID=38049 THEN LOCATION="McHenry County"; IF GEOID=38051 THEN LOCATION="McIntosh County"; IF GEOID=38053 THEN LOCATION="McKenzie County"; IF GEOID=38055 THEN LOCATION="McLean County"; IF GEOID=38057 THEN LOCATION="Mercer County"; IF GEOID=38059 THEN LOCATION="Morton County"; IF GEOID=38061 THEN LOCATION="Mountrail County"; IF GEOID=38063 THEN LOCATION="Nelson County"; IF GEOID=38065 THEN LOCATION="Oliver County"; IF GEOID=38067 THEN LOCATION="Pembina County"; IF GEOID=38069 THEN LOCATION="Pierce County"; IF GEOID=38071 THEN LOCATION="Ramsey County"; IF GEOID=38073 THEN LOCATION="Ransom County"; IF GEOID=38075 THEN LOCATION="Renville County"; IF GEOID=38077 THEN LOCATION="Richland County"; IF GEOID=38079 THEN LOCATION="Rolette County"; IF GEOID=38081 THEN LOCATION="Sargent County"; IF GEOID=38083 THEN LOCATION="Sheridan County"; IF GEOID=38085 THEN LOCATION="Sioux County"; IF GEOID=38087 THEN LOCATION="Slope County"; IF GEOID=38089 THEN LOCATION="Stark County"; IF GEOID=38091 THEN LOCATION="Steele County"; IF GEOID=38093 THEN LOCATION="Stutsman County"; IF GEOID=38095 THEN LOCATION="Towner County"; IF GEOID=38097 THEN LOCATION="Traill County"; IF GEOID=38099 THEN LOCATION="Walsh County"; IF GEOID=38101 THEN LOCATION="Ward County"; IF GEOID=38103 THEN LOCATION="Wells County"; IF GEOID=38105 THEN LOCATION="Williams County"; else delete; run; ... View more

Re: offset interpretation for proc genmode

by Obsidian | Level 7 in Statistical Procedures
‎11-05-2023 06:52 PM
‎11-05-2023 06:52 PM
This is really helpful. I am using COUNTY VARIABLE in my model and that is why I used CLASS statement for COUNTY. infact my X2 is COUNTY. Thanks a lot ... View more

offset interpretation for proc genmode

by Obsidian | Level 7 in Statistical Procedures
‎11-05-2023 10:13 AM
‎11-05-2023 10:13 AM
I have count outcome data across multiple counties ( therefore, different population/ per county). I am considering Poisson Regression with count cases and using term offset being log population. here is my code:  data ZZZZ; SET ZZ; ln = log(POPULATION); RUN; proc genmod data=ZZZZ; class COUNTY (ref='1')/PARAM=REF; WHERE TIME=1 ; model case = X1 X2 / dist=poisson link=log offset=ln; run; I just wanted to make sure my code is considering population adjustment  and how would be the interpretation. I got Estimates, are this estimates rates or it would be interpreted as : one unit increase in X, increase/decrease log cases?  Thanks,  ... View more

SAS Studi procS after importing data into it

by Obsidian | Level 7 in New SAS User
‎09-07-2023 03:33 PM
‎09-07-2023 03:33 PM
I always work with SAS desktop and am not familier with SAS studio. I have imported my excel file per tutorial videos and screen shot is provided. now I have difficulties on how to right my furthur PROCs ( Proc means, print,...). the SAS code provided here after importing data does not let me type further codes.  Also how to use proc import as a second option to import my data rather than uploading my excel data to here . I used Proc Import syntax from my SAS desktop version and it is not reading the data.  proc import datafile='locationxxxxxx' out=hw dbms=xlsx; getnames=yes; proc print data=hw;run; Thanks  ... View more

Re: open excel data in sas using infile statement

by Obsidian | Level 7 in New SAS User
‎08-28-2023 07:58 AM
‎08-28-2023 07:58 AM
I am able to get results with proc import. I was just wondering why infile statement is not working. thanks for your response. ... View more

open excel data in sas using infile statement

by Obsidian | Level 7 in New SAS User
‎08-28-2023 07:20 AM
‎08-28-2023 07:20 AM
Hi,  I am having hard time opening a data using infile statement. here is my code and I do not know why it is giving the error of "0" 0bservations! I know how to do it with proc import but I want to find out why infile statement is not working.  DATA example; INFILE 'Location\example.xlsx' DSD FIRSTOBS=2; /* first obesrvation will be second row*/ INPUT patient encounter smoking weight bloodpressure; RUN; PROC PRINT DATA=example; RUN;   Thanks a lot,  ... View more

SAS or SAS studio for MAC users

by Obsidian | Level 7 in New SAS User
‎08-24-2023 02:58 PM
‎08-24-2023 02:58 PM
Hi,  I am working in a setting where the IT is not familier with SAS software properly. May I know how MAC users can install SAS desktop version 9.4 to their system?  Also, May I know if MAC users can use SAS studio directly or not?  Thanks a lot,    ... View more

Re: upgrade my laptop/ desktop for huge dataset on SAS

by Obsidian | Level 7 in New SAS User
‎07-12-2023 12:16 PM
‎07-12-2023 12:16 PM
Actually, the code runs with no errors, but it is slow and takes time. yes, it is a university environment, but they do not work with SAS and they work with other software therefore they do not have a SAS server.  ... View more

Re: upgrade my laptop/ desktop for huge dataset on SAS

by Obsidian | Level 7 in New SAS User
‎07-12-2023 11:11 AM
‎07-12-2023 11:11 AM
The dataset is almost 3 GiG itself. ( it has >100 million rows). recently I had a "guessing row" in my proc and it took 1 hour to run. I will need to run regression procs later but now I am more in descriptive process and data transformation, and it takes too long.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
14 hours ago
Likes given to
Likes from
View All
Quick links