About kmardinian

kmardinian · ‎05-21-2021

Hi, thank you both for your help! What would be the better way of reading in the csv file, instead of the proc import statement?

kmardinian · ‎05-21-2021

Hi, I have an excel dataset with character variables in the format below: 2001 2001-01 25 2 None of them represent dates, but VAR2 is being automatically turned into a date when I import it into SAS. I am just using a proc import statement and trying to convert VAR2 back into its character format with the input statement, but it is not working. The SAS Output looks like this: SAS OUTPUT: VAR1 VAR2 VAR3 VAR4 2001 01FEB01:00:00:00 25 2 filename PR "&path.&filein"; PROC IMPORT OUT=work_&i DATAFILE= "PR" DBMS=csv REPLACE; GETNAMES=no; RUN; data want_&i; set work_&i; _VAR2=input(VAR2,best.); run; Any help would be much appreciated! Thank you!

kmardinian · ‎12-19-2020

Thank you so much, I definitely missed that! Works perfectly now!

kmardinian · ‎12-18-2020

I have this below macro that runs fine for when xrow=1 to 99, but as soon as I put in anything over 100 it keeps generating this error that I don't understand. ERROR: Invalid value for width specified - width out of range NOTE: At least one W.D format was too small for the number to be printed. The decimal may be shifted by the "BEST" format. I looked up some helpful articles that say it may be a format issue, but I am not sure what format I would need to allow it to read > 100 and all the ones I have tried have not worked. Any help is much appreciated!! Thank you! %Macro MYC(xdata,xrow); proc sql noprint; select filter,biomarks, group, exclude, number, title, strip("TAB"||strip(put(ID,z2.))||"A") as tab, strip("Table "||strip(number)||": "||strip(title)) as ftabtitle, strip(tranwrd(title,'Endpoints – ',' ')) as stabtitle into: xfilters, :xbiomark, :xgroup, :xexclude, :xtabnum, :xtabtitle, :xtab, :xftabtitle, :xstabtitle from input.data where ID = &xrow; quit; %mend MYC; %MYC(input.data_new,100);

kmardinian · ‎10-27-2020

Hi Steve, Thank you, that is a better idea. (Given a sample size of 60, what is the number of adverse events you would have to observe to be 95% confident that the true value was 0.333 with 80% power.) How would you set that up in proc power?

kmardinian · ‎10-22-2020

Thank you, that makes sense! But is 0.333 really the probability of the event occurring? I thought it was just the proportion of subjects that experienced the event.

kmardinian · ‎10-21-2020

Hi, I have a power calculation question. If I have an initial study that has 6 subjects and a follow-up study with 60 subjects. Can I find the probability of any of the 60 subjects experiencing an Adverse event, if >=33% of the 6 subjects develops an Adverse event. I was going to try to use PROC prower for this, but was unsure where to start. Thank you!

kmardinian · ‎10-16-2020

Thanks Steve for all your help! I was able to get all the necessary information I needed!

kmardinian · ‎10-15-2020

I appreciate you walking me through this, just a couple more things that I'm still a bit confused about. When you set up your meandiff=0.2 to 2.4 by 0.2, is 0.2 your standard deviation that you are choosing to use in this K*stddev formula? meandiff = 0.2 to 2.4 by 0.2 Do I even still need the groupstddevs to show that 2 groups are half a standard deviation apart, 1 standard deviation apart, 0.5 standard deviations apart?

kmardinian · ‎10-15-2020

Hi Steve, Thank you, that's a really good idea! I didn't think to estimate the mean difference with an 80% power level first, to see what the minimum difference could be! Unfortunately SAS won't let me run that code without the STDDEV statement: ERROR: The STDDEV option is required for TEST=DIFF Do you think this is something I should assume as well and estimate a value for it?

kmardinian · ‎10-14-2020

Hi, I want to run a power analysis using Proc Power to determine my power for a project. I have a sample size of 32 and want to know the difference in power if I use randomization ratios of 1:2 or 1:3 (placebo vs. treatment) The issue is I do not have any reference point for how different my two groups will be, so I can't populate MEANDIFF in the Proc Power statement. So instead I wanted to use standard deviations, if the 2 groups are half a standard deviation apart, 1 standard deviation apart, 0.5 standard deviations apart. Does that seem feasible, or is there a better approach? This below proc power doesn't run because I need GROUPMEANS or MEANDIFF, which I don't have... proc power; twosamplemeans test=diff groupstddevs = 1| 2 ntotal = 32 power = . groupweights=(3,1); ods output output=output; run;

kmardinian · ‎12-16-2019

Thank you!! This is exactly what I needed!

kmardinian · ‎12-16-2019

Hi, I have a dataset where I have subject ID and site ID as two separate variables and I would like to count the unique subject IDs for each site id. subject site 10021 644 10021 644 10256 644 10256 644 56985 733 56985 733 45698 733 12659 733 And I would like the output dataset to look like this: site count 644 2 733 3 Any help is much appreciated! Thank you!

kmardinian · ‎10-17-2019

data WORK.ALL; infile datalines dsd truncover; input Subject:$8. Visit:$15. Image:$8. Site:$15. Area:$7.; datalines; 1102 Visit1 233B 14 NA 1102 Visit2 435A 14 NA 1103 Visit1 463A 14 NA 1103 Visit1 345B 14 NA 1104 Visit1 345A 14 COL 1104 Visit1 345B 14 NA 1106 Visit1 567A 14 IL 1106 Visit1 866A 14 COL 1107 Visit1 461A 14 IL 1107 Visit2 356A 14 NA ;;;; NOTE: There were 10 observations read from the data set WORK.ALL. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds I think I over complicated this in everyone's mind. I only want to assign LOCATION based on the AREA variable. So for Subject 1102, the first AREA is "NA", so this would be Location=1. Then the same subject has another record where the AREA is still NA, so this would still be Location=1 (because they are the same area, therefore same location) For Subject 1107, they contain two different AREAS (IL and NA), I would want the first AREA to be assigned Location=1 and the second AREA to be Location=2, because they are different. I have already sorted based on SUBJECT and VISIT, so the AREA variable is already in the order that I want it, now I just need to assign Location 1 and 2, so I can differentiate the Image IDs later. Does that make more sense?

kmardinian · ‎10-17-2019

The problem with that is if a SUBJECT has two Visit 1 records and two different AREAS, a COL and a IL, then it assigns them both Location=1. And I would like the second AREA, regardless of Visit to be assigned Location=2

Online Status	Offline
Date Last Visited	‎05-27-2021 02:24 PM

Re: SAS changing my character variable to dates from Excel

SAS changing my character variable to dates from Excel

Re: ERROR: Invalid value for width specified - width out of range

ERROR: Invalid value for width specified - width out of range

Re: PROC POWER Calculation

Re: PROC POWER Calculation

PROC POWER Calculation

Re: Proc Power without Reference MEANDIFF

Re: Proc Power without Reference MEANDIFF

Re: Proc Power without Reference MEANDIFF

Re: SAS/ACCESS and MySQL error

Re: NOTE: Character values have been converted to numeric values

Re: ERROR: Import cancelled. The dataset INPUT.X is being used and can...

Re: SAS/ACCESS and MySQL error

Re: If then statement involving two different dataset and two differen...

Re: SAS changing my character variable to dates from Excel

SAS changing my character variable to dates from Excel

Re: ERROR: Invalid value for width specified - width out of range

ERROR: Invalid value for width specified - width out of range

Re: PROC POWER Calculation

Re: PROC POWER Calculation

PROC POWER Calculation

Re: Proc Power without Reference MEANDIFF

Re: Proc Power without Reference MEANDIFF

Re: Proc Power without Reference MEANDIFF

Proc Power without Reference MEANDIFF

Re: Counting unique records based on two variables

Counting unique records based on two variables

Re: PROC SQL Group by multiple variables to order another variable

Re: PROC SQL Group by multiple variables to order another variable