About Bright

Bright · ‎03-06-2023

Hi, Thanks for the reply. I do not have panel or survey data. It seems proc glm with absorb, proc mixed, and proc genmod work. However, the reported standard errors and hence the significant levels are very different between glm and the other two. How are these processes' standard errors calculated? Thanks!

Bright · ‎03-01-2023

Hi, I am running a regression model with GLM and want to cluster errors at the MSA (Metropolitan Statistical Area) level. Are there any options in GLM that does this? Thanks! My code: proc glm data=data; class Year Health_Plan Gender MSA; model ln_cost= Year Health_Plan Age Gender riskscore MSA / solution; run;

Bright · ‎09-19-2022

I tried the code from @PeterClemmensen and it worked. Thanks both!

Bright · ‎09-19-2022

month_year in dataset DATA1 has format MONYY7. For example MAR2015.

Bright · ‎09-19-2022

Thanks, but I only have month and year (i.e., MAR2015). I do not have the day (i.e., 31MAR2015).

Bright · ‎09-19-2022

The desired output is to get all observations where the date is not March 2015.

Bright · ‎09-19-2022

Hello, I have a variable called month_year in dataset DATA1 with format MONYY7. I am trying to make a subset of this datset based on the variable month_year. My code for getting the observations where month_year is not March 2015 looks like this: data DATA2 (where=(month_year ne 'MAR2015'd)); set DATA1; run; I am getting the error "ERROR: Invalid date/time/datetime constant 'MAR2015'd. ERROR: Syntax error while parsing WHERE clause." Any suggestions? Thanks!

Bright · ‎05-17-2022

Hi, I have a dataset as below: ID Condition A Condition B Condition C Condition D 250 0 0 0 0 250 0 1 0 0 250 1 0 0 0 260 0 0 0 0 260 0 0 0 0 270 1 0 0 0 270 0 1 0 0 270 0 0 0 1 I want an output like the table below: ID Condition A Condition B Condition C Condition D 250 1 1 0 0 260 0 0 0 0 270 1 1 0 1 Thanks!

Bright · ‎03-28-2022

@Tom I imported this date from a CSV file. The original format of data was yymmdd10. which I changed it to DATE9.

Bright · ‎03-28-2022

@Tom Thanks for the explanation. So what can I do to resolve this issue? Thanks!

Bright · ‎03-28-2022

Hello, I have a "date" like 2015-02-22 (format is DATE9.) and I want to have the week number of this date. In this example, the output should be 15W08 (format is WEEKW5.). I am using function week(date) but the output for this example is 60W01, which is incorrect. Any idea of what is going wrong? Thanks!

Bright · ‎06-19-2021

I want 30 days back, excluding the day itself.

Bright · ‎06-19-2021

Thanks Koen, I have a large dataset ...

Bright · ‎06-19-2021

Hello, I have a dataset looks like this: Location Date Number of warnings (N) Number of correct warnings (T) A 06/19/2020 3 2 A 06/29/2020 5 3 A 06/30/2020 1 1 A 07/1/2020 4 3 A 07/05/2020 7 1 A 07/15/2020 2 0 A 07/19/2020 3 1 A …. … … B 05/12/2020 4 4 B 05/24/2020 1 0 B 05/27/2020 3 2 B … … …. For each specific “Date” I want to calculate R=Sum(T)/Sum(N) during the last month. For example, if we consider Location “A” and Date “07/19/2020”, I want to have R=(0+1+3+1+3+2)/(2+7+4+1+5+3). Any help is appreciated! Thanks

Bright · ‎04-17-2021

Hi, I am trying to use proc expand to calculate moving average of for example 3 last observations excluding the current observation. Suppose the data is like this: ID Price 1 10 2 0 3 20 4 50 Using this code proc expand data=have out=want method=none; convert price=price_avg / TRANSFORMOUT=(movave 3); run; I get ID Price Price_avg 1 10 10 2 0 5 3 20 10 4 70 30 Now, consider observation 4, I want the moving average does not consider the current observation. So the Price-avg should be (20+0+10)/3=10. Is there any way to do that directly in the proc expand? Thanks

Online Status	Offline
Date Last Visited	‎03-30-2023 02:47 PM

Re: Cluster errors in Proc GLM

Cluster errors in Proc GLM

Re: Month-Year in if/where Statement

Re: Month-Year in if/where Statement

Re: Month-Year in if/where Statement

Re: Month-Year in if/where Statement

Month-Year in if/where Statement

Combining multiple rows to a single row

Re: Date to week

Re: Date to week

Re: Cluster errors in Proc GLM

Re: Cluster errors in Proc GLM

Re: Defining a variable within a date interval

Re: Defining a variable within a date interval

Re: Defining a variable within a date interval

Re: Cluster errors in Proc GLM

Cluster errors in Proc GLM

Re: Month-Year in if/where Statement

Re: Month-Year in if/where Statement

Re: Month-Year in if/where Statement

Re: Month-Year in if/where Statement

Month-Year in if/where Statement

Combining multiple rows to a single row

Re: Date to week

Re: Date to week

Date to week

Re: Defining a variable within a date interval

Re: Defining a variable within a date interval

Defining a variable within a date interval

Moving average with proc expand excluding the current observation