Hi.  I want a statement where:  if idnumber ne 2 or idnumber ne 5 then delete; but this statement is not giving me either. I do not want an and statement as I only need one of them to be true to keep them (if it is not 2 or 5 then it is deleted).  Any suggestion on what I'm doing wrong?    ... View more

Due to an unusual specification, I need to make a connection between SAS VIYA4 and MS Power BI. I have found solutions to create this type of connection between SAS 9.4 Unfortunately, on the forum and on the Internet I do not see any valuable materials on this type of connection from the VIYA system. An additional complication is that the connection must be made by downloading data from IN-Memory tables, but if this is impossible I would like to get any connection. In summary, the in-memory tables sas VIYA4 is the source of the data and Power BI analyzes it. I was wondering if it is possible to use SAS OLPA SERVER for this, to integrate the data contained in SAS VIYA with MS Power BI. Moreover, OLAP SERVER is a desktop tool. I do not hide the fact that ideally there would be an alternative tool running in an on premise solution on the browser side. I am aware of the differences between VIYA and SAS 9.4, and how this idea sounds. The question is do you have any ideas on how to get around any associated inconvenience?   ... View more

I am currently analyzing the impact of an intervention on medication numbers using difference-in-difference analysis, but I have encountered several challenges.   Following the SAS support instructions, I conducted the difference-in-difference analysis. However, I noticed a discrepancy between my results and SAS's example (Usage Note 61830: Estimating the difference in differences of means).   In the example, the value of 'Mean Estimate' in 'Contrast Estimate Results' is identical to the 'Estimate' in 'Least Squares Means Estimate'. However, in my case, these values were different. I suspect this could be due to my use of the negative binomial distribution with a log link, resulting in exponential values. Consequently, I am unsure whether to rely on the 'Mean Estimate' in 'Contrast Estimate Results' or the 'Estimate' in 'Least Squares Means Estimate', and how to interpret the results."   Contrast Estimate Results Label Mean Estimate Mean Confidence Limits L'Beta Estimate Standard Error diff in diff 1.51 1.49 0.41 0.0051   a*b Least Squares Means a b Estimate Standard Error z value Pr > |z| 1 1 0.77 0.00434 178.19 <.0001 1 0 0.03 0.00508 6.5 <.0001 0 1 0.72 0.00408 177.71 <.0001 0 0 0.40 0.00426 93.11 <.0001   Least Squares Means Estimate Effect Label Estimation Standard Error z value Pr > |z| time*hospitalize diff in diff 0.41 0.00509 81.01 <.0001 ... View more

Hello everyone, I am trying to select alternate columns from my dataset, starting from column number 1 and including every nth alternate column after that. For example, I want to select columns 1, 3, 5, 7, and so on up to column n. Is there a way to make this selection without having to manually specify the column names? Here are my column headers: FINAL_STATUS_01MAY24, FINAL_STATUS_02MAY24, and so on... I would appreciate any help or advice. Thank you! ... View more

Hi every one; I am using proc genmod to calculate the mean change in blood pressure from baseline to the first follow-up in association with tertiles of Health Eating Index score. I am using the following code for this purpose: proc genmod data=BP_long order=internal; class HEI_Tertile time var1 var1 var3/ref=first; model ChangeBP=time HEI_Tertile var1 var1 var3 var4 var5 /type3 lrci; repeated subject=codea/type=exch corrw; run; However, I am having unexpected results for the mean changes, where high consumers of healthy diet in the top tertile had more increased BP. I am not sure whether this is related to the coding here or transposing of the data to a long foramt. I used the following for transposing and then renamed;   proc sort; by Id; run; proc transpose data=BP_wide out=BP_long; var BP1-BP2; by id; run;  *Renaming the transposed variable; data BP_long; set BP_long (rename=(col1=ChangeBP)); If _Name_ = 'BP1' then Time= 1; Else if _Name_= 'BP2' then Time=2; Drop _Name_ _label_; run;   Thank you so much in advance.   ... View more