Hi, I have a dataset I am working with., I have one variable of interest were the subjects answer, Yes or no " in this case the subject could only answer exposure to radon' based on their perception only once.   I have the proportions of yes and the proportion of no's. I want to know how many no's can I include for further analysis. Should I use Proc Power one sample means or two sample means?   Thanks for your help in advance ... View more

Hi, all I am working with a dataset of a clinical trial study., I want to compare the difference if any between the waist size by gender on the placebo group., I tried to use proc univariate but as expected this does not work with categorical data any help will be appreciated.   Record waist_cm group Gender a1 90 Experimental Female a2 60 Experimental Female a3 55 Experimental Female a4 52 Experimental Female a5 59 Placebo Female a6 80 Placebo Female a7 74 Placebo Male a8 66 Placebo Male a9 72 Placebo Male a10 80 Placebo Male a11 . Placebo Male ... View more

Hi, I am trying to count categorical variables on the following dataset., I need to count how many players have normal performance on the south team by month., This is an 8,000 observations dataset. Player performance Team                          month 1 High north                             3 2 normal south                            7 3 low north                             5 4 High north                            9 6 normal south                           - 7 low north                           - 8 High north ... View more

Hi, I am working with a dataset that collected some body measurements., I would like to duplicate the observation on the same row to do a pre-treatment and post-treatment analysis. For example, having 1.2 again for record one. This a large dataset and doing this by hand or if-then statements is near to impossible.    record measure A 1 1.2 1 . 2 1.3 2 1.3 3 . 3 . ... View more

Hi, I am trying to run the following macro, but sas is unable to determine the column. How can  I fix this issue? Thanks..   %MACRO catreport(opts,Derivation=, Mutation=); PROC FREQ DATA = datasets.cats;     TABLES &Derivation/&opts;     TITLE "Cat Breeds by &Derivation"; RUN; PROC PRINT DATA = datasets.cats;     WHERE &Derivation = "&Mutation";     TITLE "Cat Breeds with &Derivation = &Mutation"; RUN; %MEND catreport; options SYMBOLGEN MPRINT MLOGIC; %catreport(Derivation=Origin, Mutation=Thailand)   --------------------------------- log   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 2 TITLE; 3 FOOTNOTE; 4 OPTIONS LOCALE=en_US DFLANG=LOCALE; 5 DATA _NULL_; 6 RUN; 7 OPTIONS VALIDVARNAME=V7; 8 OPTIONS VALIDMEMNAME=COMPAT; 9 FILENAME _HTMLOUT TEMP; 10 FILENAME _RTFOUT TEMP ENCODING='UTF-8'; 11 FILENAME _PDFOUT TEMP; 12 FILENAME _GSFNAME TEMP; 13 FILENAME _DATAOUT TEMP; 14 %LET SYSCC=0; 15 %LET _CLIENTAPP='SAS Studio'; 16 %LET _CLIENTAPPABREV=Studio; 17 %LET _CLIENTAPPVERSION=3.71; 18 %LET _CLIENTVERSION=3.71; 19 %LET _CLIENTMODE=basic; 20 %LET _SASSERVERNAME=%BQUOTE(localhost); 21 %LET _SASHOSTNAME=%BQUOTE(localhost); 22 %LET _SASPROGRAMFILEHOST=%BQUOTE(localhost); 23 %LET _CLIENTUSERID=%BQUOTE(sasdemo); 24 %LET _CLIENTUSERNAME=%BQUOTE(sasdemo); 25 %LET CLIENTMACHINE=%BQUOTE(10.0.2.2); 26 %LET _CLIENTMACHINE=%BQUOTE(10.0.2.2); 27 %let SASWORKLOCATION="%sysfunc(getoption(work))/"; 28 FILENAME _CWD '.'; 29 DATA _NULL_; 30 CALL SYMPUT('_SASWORKINGDIR',PATHNAME('_CWD')); 31 RUN; 32 FILENAME _CWD; 33 34 %LET _SASPROGRAMFILE = %NRQUOTE(%NRSTR()); 35 %LET _BASEURL = %BQUOTE(http://localhost:10080/SASStudio/); 36 %LET _EXECENV=SASStudio; 37 DATA _NULL_; 38 CALL SYMPUT("GRAPHINIT",""); 39 CALL SYMPUT("GRAPHTERM",""); 40 RC=TSLVL('SASXGOPT','N'); 41 _ERROR_=0; 42 IF (RC^=' ') THEN DO; 43 CALL SYMPUT("GRAPHINIT","GOPTIONS RESET=ALL GSFNAME=_GSFNAME;"); 44 CALL SYMPUT("GRAPHTERM","GOPTIONS NOACCESSIBLE;"); 45 END; 46 RUN; 47 DATA _NULL_; 48 RC=SYSPROD("PRODNUM002"); 49 IF (RC^=1) THEN DO; 50 CALL SYMPUT("GRAPHINIT",""); 51 CALL SYMPUT("GRAPHTERM",""); 52 END; 53 RUN; 54 %LET _DATAOUT_MIME_TYPE=; 55 %LET _DATAOUT_NAME=; 56 %LET _DATAOUT_TABLE=; 57 %LET _DATAOUT_URL=; 58 %SYMDEL _DATAOUT_MIME_TYPE _DATAOUT_NAME _DATAOUT_URL _DATAOUT_TABLE; 59 %LET _SASWS_ = %BQUOTE(/folders/myfolders); 60 %LET _SASWSTEMP_=%BQUOTE(/folders/myfolders/.sasstudio/.images/635d5dc7-3903-42a7-a99d-5c827d541333); 61 ODS LISTING CLOSE; 62 ODS AUTONAVIGATE OFF; 63 ODS GRAPHICS ON; 64 ODS HTML5 (ID=WEB) DEVICE=PNG GPATH="&_SASWSTEMP_" ENCODING=utf8 FILE=_HTMLOUT (TITLE='Results: Program 1') 64 ! STYLE=Htmlblue OPTIONS(BITMAP_MODE='INLINE' OUTLINE='ON' SVG_MODE='INLINE' 64 ! CSS_PREFIX='.ods_635d5dc7-3903-42a7-a99d-5c827d541333' BODY_ID='div_635d5dc7-3903-42a7-a99d-5c827d541333' ); 65 ODS RTF (ID=WEB) STYLE=Rtf FILE=_RTFOUT sasdate; 66 ODS PDF (ID=WEB) STYLE=Pearl FILE=_PDFOUT; 67 &GRAPHINIT; 68 OPTIONS FIRSTOBS=1; 69 OPTIONS OBS=MAX; 70 OPTIONS DTRESET DATE NUMBER NOTES; 71 OPTIONS NOTES STIMER SOURCE NOSYNTAXCHECK; 72 73 %MACRO catreport(opts,Derivation=, Mutation=); 74 PROC FREQ DATA = datasets.cats; 75 TABLES &Derivation/&opts; 76 TITLE 'Cat Breeds by &Derivation'; 77 RUN; 78 79 PROC PRINT DATA = datasets.cats; 80 WHERE &Derivation = "&Mutation"; 81 TITLE "Cat Breeds with &Derivation = &Mutation"; 82 RUN; 83 %MEND catreport; 84 options SYMBOLGEN MPRINT MLOGIC; 85 %catreport(Derivation=Origin, Mutation=Thailand) 86 87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 88 ODS HTML CLOSE; 89 &GRAPHTERM; ;*';*";*/;RUN;QUIT; 90 QUIT;RUN; 91 ODS HTML5 (ID=WEB) CLOSE; 92 93 ODS RTF (ID=WEB) CLOSE; 94 ODS PDF (ID=WEB) CLOSE; 95 FILENAME _GSFNAME; 96 DATA _NULL_; 97 RUN; 98 OPTIONS VALIDMEMNAME=COMPAT; 99 OPTIONS NOTES STIMER SOURCE SYNTAXCHECK; 100   ... View more

Hi, everybody, I have this dataset with 12 variables I am trying to calculate the CCI index for the variables. I am using this code but I am getting twice the variables without changing yes or no to its proper numeric value per condition. The code is the following. Also attached is the original csv file. data risk; set datasets.riskdata; if diagnosis= 'TYPE1_DM' then diagnosis='y'; if diagnosis='TYPE2_DM' THEN DIAGNOSIS='n'; if diagnosis= 'PXECTMY' then diagnosis='n'; if los<0 then los=.; array a{10} diagnosis dialysis lipiddis cbv_ds pvd neuropthy respprob cancrpre cbypass mi; do i=1 to 10; if A{i}=' ' then a{i}=.; if a{i}= 999 then a{i}=.; if a{i}= u then a{i}=.; if a{i}= 9 then a{i}=.; drop i; end; array b{10} diagnosis dialysis lipiddis cbv_ds pvd neuropthy respprob cancrpre cbypass mi; array c{10} (2,3,2,1,1,1,1,3,1,2 ); do i=1 to 10; if (B{i})='y' then CCI = CCI + B(c{i}); if (B{i})= 'n' then B(c{i})=0; else if (B{i})='.' then CCI+B(c{i})=0; drop i; end; run;   and this is the error message  NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 81:18 82:19 83:17 84:17 91:21 NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 82:4 84:4 90:32 92:29 NOTE: Variable u is uninitialized. NOTE: Invalid numeric data, 'y' , at line 82 column 4. NOTE: Invalid numeric data, 'y' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 90 column 32. Case_ID=641 DIAGNOSIS=y LOS=13 Dialysis=Y LipidDis=N CbV_DS=N PVD=N Neuropthy=Y RespProb=N CancrPre=N CBYPASS=N MI=N i=11 u= c1=2 c2=3 c3=2 c4=1 c5=1 c6=1 c7=1 c8=3 c9=1 c10=2 CCI=. _ERROR_=1 _N_=1 NOTE: Invalid numeric data, 'y' , at line 82 column 4. NOTE: Invalid numeric data, 'y' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 90 column 32. Case_ID=1173 DIAGNOSIS=y LOS=7 Dialysis=Y LipidDis=Y CbV_DS=N PVD=N Neuropthy=Y RespProb=Y CancrPre=N CBYPASS=N MI=N i=11 u= c1=2 c2=3 c3=2 c4=1 c5=1 c6=1 c7=1 c8=3 c9=1 c10=2 CCI=. _ERROR_=1 _N_=2 NOTE: Invalid numeric data, 'y' , at line 82 column 4. NOTE: Invalid numeric data, 'y' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 82 column 4. NOTE: Invalid numeric data, 'Y' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'N' , at line 82 column 4. NOTE: Invalid numeric data, 'N' , at line 84 column 4. NOTE: Invalid numeric data, 'Y' , at line 90 column 32. Case_ID=1234 DIAGNOSIS=y LOS=8 Dialysis=Y LipidDis=N CbV_DS=N PVD=N Neuropthy=Y RespProb=N CancrPre=N CBYPASS=N MI=N i=11 u= c1=2 c2=3 c3=2 c4=1 c5=1 c6=1 c7=1 c8=3 c9=1 c10=2 CCI=. _ERROR_=1 _N_=3 ... View more

Hi, I have a database with character observations ( y and n) I want to assign them values to calculate the comorbidity index. The code I am using is the following with no result.   data hw2;  set datasets.riskdata;  array a {5} cbypass cbv_ds respprob neuropthy pvd;  do i=1 to 5;  if a{i}= y then a{i}=1;  end;  run;   NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 84:17 NOTE: Variable y is uninitialized. NOTE: There were 830 observations read from the data set DATASETS.RISKDATA. NOTE: The data set WORK.HW2 has 830 observations and 14 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds   Also I am trying to use arrays to erase missing values with this code but is also not working.     data hw2; set datasets.riskdata; if diagnosis= 'TYPE1_DM' then diagnosis='2'; if diagnosis='TYPE2_DM' THEN DIAGNOSIS='0'; if diagnosis= 'PXECTMY'  then diagnosis='0'; IF los<0 then los=.; array a{9} diagnosis dialysis cbypass cbv_ds respprob neuropthy mi pvd lipiddis; do i=1 to 9; if a{i}= ' ' then a{i}=delete; end; run; ... View more

Hi, I am trying to calculate power for a hypothetical cohort study, I have run in multiple times this code but I still receive the same error 180-322.   Thanks in advance!   groupweights=(1 9)/*Divide ntotal 9 to 1 between the groups => n2=9*n1, where n1 = exposed sample size & n2 = unexposed sample size*/ ntotal=120000 /*120,000 total participants in the study*/ power=.; /*Calculate power*/   OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc groupweights=(1|9)/*Divide ntotal 9 to 1 between the groups => n2=9*n1, where n1 = exposed sample size & n2 = 73 ! unexposed sample size*/ ERROR: Procedure GROUPWEIGHTS not found. 74 ntotal=120000 /*120,000 total participants in the study*/ 75 power=.; /*Calculate power*/ 76 77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; ... View more