Hi everyone,    I am trying using proc calis with path statement to depict one very simple SEM with two latent factors (X and Y) which each has 6 indicators, and  X predicts Y with the following code.    proc calis ; path T1_X -> x1-x6, T1_y -> y1-y6, T1_x -> T1_y; fitindex noindextype on(only)=[chisq df cfi BENTLERNNFI rmsea srmsr bentlercfi probchi]; run;     However, I found that the degree of freedom for SAS is 51, which is not the same when I use the AMOS and Mplus (df = 53).   But the esimate is almost the same with the Mplus.    Why the df is not the same?   ... View more

I have wirte a macro to important all xlsx in "C:\SASMACRO\data\F2+Blank\" and read them and merged in a dataset called "a."   However, I have problems is that the file dataset with one variable (filenames), which cannot read the blank.   So, if a xlsx data called "data 01", then it cannot read.    Can some one help me to improve the problems that I can important xlsx file with blank in its name.    Thx.      %macro merge(); proc sql noprint;select count(filenames) INTO :myn from File; %do i=1 %to &myn; proc import out=datafile&i datafile="&&file&i" dbms=xlsx /*any data type*/replace; run; %end; data a; set %do j=1 %to &myn; datafile&j %end; ; run; %mend merge; filename lib pipe 'dir "C:\SASMACRO\data\F2+Blank\*.xlsx" /b'; data file; length filenames $ 40; infile lib truncover; input filenames : $; filenames="C:\SASMACRO\data\F2+Blank\"||filenames; run; data _NULL_; set file; call symputx('file'||put(_n_,1.),filenames,'G'); run; options sasautos=work; %merge() /*data would be merged in a*/ ... View more

If i have a program whose pathway is "C:\SASMACRO\WISC4.sas"   How could I automaticly load it in sas everytime I start to use SAS. ... View more

hi every one,   I am try to write a k-means algorithm in one dimension data in sas macro.        First step, I trying to randomly sample three object from 1 to 13 and name them as k1, k2, and k3.   second step, I want to calculate each the difference between my variable and k1 to t3 to decide which one belongs to which cluster.   However, i cannot calcuate the macro variable in sas.    the following is my code.    data t; INPUT x; cards; 1 2 3 4 5 6 7 8 9 10 11 12 13 ; %macro a(data,k,var); proc surveyselect data=&data noprint METHOD=srs SEED=0 OUT=t1 SAMPSIZE=&k; RUN; data t1; set t1; n=_N_; run; %do i = 1 %to &k; proc sql noprint;select x INTO :k&i from t1 where n=&i; data t; set t; y&i=x-k&i; run; %end; %mend a; %a(data=t,k=3,var=x);   I found that I have successfully create the three sas macro variable k1 to k3 and test them using  %put &k1.   However, how could I write the calcuation in sas macro.    there is a problem in "y&i=x-k&i;".   sas cannot read k&i as macro variable.    how could I resovle this?   thx   ... View more

Hi, every body.    I have wrote a SAS macro to import multiple data with dat format, but the variable and position have a little differnece.    The data is separeted by each year and has three kind of format.   So, I created a macro variable according to the "year" and the input statement changed with different year.   The following code is my syntax, however, i found that something wrong.    The data imported to my computer is correct one, but the input statement is all the ways according to the first one, which is between 1996 and 2003.   please correct my syntax and help me out.     %macro a(star,myvar); %do i = &star %to &myvar;     %if  1996 <= &i <=2003  %then %do;  filename total ( "F:\CD\R201_CD&i..DAT" "F:\CD\R202_CD&i..DAT" "F:\CD\R203_CD&i..DAT" "F:\CD\R204_CD&i..DAT" "F:\CD\R205_CD&i..DAT" "F:\CD\R206_CD&i..DAT" "F:\CD\R207_CD&i..DAT" "F:\CD\R208_CD&i..DAT" "F:\CD\R209_CD&i..DAT" "F:\CD\R210_CD&i..DAT" "F:\CD\R211_CD&i..DAT" ); data CD&i; infile total; INPUT FEE_YM $ 1-6 APPL_TYPE $ 7-7 HOSP_ID $ 8-41 APPL_DATE $ 42-49 CASE_TYPE $ 50-51 SEQ_NO  52-57 CURE_ITEM_NO1 $ 58-59 CURE_ITEM_NO2 $ 60-61 CURE_ITEM_NO3 $ 62-63 CURE_ITEM_NO4 $ 64-65 FUNC_TYPE $ 66-67 FUNC_DATE $ 68-75 TREAT_END_DAT $ 76-83 ID_BIRTHDAY $ 84-91 ID $ 92-123 CARD_SEQ_NO $ 124-125 GAVE_KIND $ 127-127 PART_NO $ 128-130 ACODE_ICD9_1 $ 131-135 ACODE_ICD9_2 $ 136-140 ACODE_ICD9_3 $ 141-145 ICD_OP_CODE $ 146-149 DRUG_DAY  150-151 MED_TYPE $ 152-152 PRSN_ID $ 153-184 PHAR_ID $ 185-216 DRUG_AMT  217-224 TREAT_AMT  225-232 TREAT_CODE $ 233-244 DIAG_AMT  245-252 DSVC_NO $ 253-264 DSVC_AMT  265-272 BY_PASS_CODE $ 273-274 T_AMT  275-282 PART_AMT  283-290 T_APPL_AMT  291-298 ID_SEX $ 299-299 ; RUN; %End; %else %if  2004 <= &i <=2011  %then %do; filename total ( "F:\CD\R201_CD&i..DAT" "F:\CD\R202_CD&i..DAT" "F:\CD\R203_CD&i..DAT" "F:\CD\R204_CD&i..DAT" "F:\CD\R205_CD&i..DAT" "F:\CD\R206_CD&i..DAT" "F:\CD\R207_CD&i..DAT" "F:\CD\R208_CD&i..DAT" "F:\CD\R209_CD&i..DAT" "F:\CD\R210_CD&i..DAT" "F:\CD\R211_CD&i..DAT" ); data CD&i; infile total; INPUT FEE_YM $ 1-6 APPL_TYPE $ 7-7 HOSP_ID $ 8-41 APPL_DATE $ 42-49 CASE_TYPE $ 50-51 SEQ_NO  52-57 CURE_ITEM_NO1 $ 58-59 CURE_ITEM_NO2 $ 60-61 CURE_ITEM_NO3 $ 62-63 CURE_ITEM_NO4 $ 64-65 FUNC_TYPE $ 66-67 FUNC_DATE $ 68-75 TREAT_END_DATE $ 76-83 ID_BIRTHDAY $ 84-91 ID $ 92-123 CARD_SEQ_NO $ 124-127 GAVE_KIND $ 128-128 PART_NO $ 129-131 ACODE_ICD9_1 $ 132-136 ACODE_ICD9_2 $ 137-141 ACODE_ICD9_3 $ 142-146 ICD_OP_CODE $ 147-150 DRUG_DAY  151-152 MED_TYPE $ 153-153 PRSN_ID $ 154-185 PHAR_ID $ 186-217 DRUG_AMT  218-225 TREAT_AMT  226-233 TREAT_CODE $ 234-245 DIAG_AMT  246-253 DSVC_NO $ 254-265 DSVC_AMT  266-273 BY_PASS_CODE $ 274-275 T_AMT  276-283 PART_AMT  284-291 T_APPL_AMT  292-299 ID_SEX $ 300-300;  RUN; %End; %else %if  2012 <= &i %then %do;  filename total ( "F:\CD\R201_CD&i..DAT" "F:\CD\R202_CD&i..DAT" "F:\CD\R203_CD&i..DAT" "F:\CD\R204_CD&i..DAT" "F:\CD\R205_CD&i..DAT" "F:\CD\R206_CD&i..DAT" "F:\CD\R207_CD&i..DAT" "F:\CD\R208_CD&i..DAT" "F:\CD\R209_CD&i..DAT" "F:\CD\R210_CD&i..DAT" "F:\CD\R211_CD&i..DAT" ); data CD&i; infile total; INPUT FEE_YM $ 1-6 APPL_TYPE $ 7-7 HOSP_ID $ 8-41 APPL_DATE $ 42-49 CASE_TYPE $ 50-51 SEQ_NO  52-57 CURE_ITEM_NO1 $ 58-59 CURE_ITEM_NO2 $ 60-61 CURE_ITEM_NO3 $ 62-63 CURE_ITEM_NO4 $ 64-65 FUNC_TYPE $ 66-67 FUNC_DATE $ 68-75 TREAT_END_DATE $ 76-83 ID_BIRTHDAY $ 84-91 ID $ 92-123 CARD_SEQ_NO $ 124-127 GAVE_KIND $ 128-128 PART_NO $ 129-131 ACODE_ICD9_1 $ 132-146 ACODE_ICD9_2 $ 147-161 ACODE_ICD9_3 $ 162-176 ICD_OP_CODE $ 177-191 DRUG_DAY  192-193 MED_TYPE $ 194-194 PRSN_ID $ 195-226 PHAR_ID $ 227-258 DRUG_AMT  259-266 TREAT_AMT  267-274 TREAT_CODE $ 275-286 DIAG_AMT  287-294 DSVC_NO $ 295-306 DSVC_AMT  307-314 CASE_PAY_CODE $ 315-316 T_AMT  317-324 PART_AMT  325-332 T_APPL_AMT  333-340 ID_SEX $ 341-341 TRAN_IN_HOSP_ID $ 342-375 PAT_TRAN_OUT $ 376-376 APPL_CAUSE_MARK $ 377-377  ; RUN; %end; %End;  %mend a; %a(2011,2012); ... View more

Hi everyone,    If I have a data like this.    data t;INPUT id dis;cards; 1 0 1 1 2 0 3 1 3 0 ;   There is a duplicate when ID = 1 and 3.    I want to remove them but keep the dis status is 1.    I can do to by sorting the data by ID and descending the variable of dis. Then I can use the proc sort with nodupkey statement to keep the first id in the data set.    However, I want to learn how to do it by Proc SQL.    I try use the following syntax.    proc sql; select distinct ID, dis from t HAVING dis=1; quit;   But, it turns out that the observation 2 is not included because its dis status= 0.    Further, how to do that when there are more complex relationships and more variables?   For example, if there are two rule.    data t;INPUT id dis exp;cards; 1 0 1 1 1 2 2 0 3 3 1 4 3 0 5 ;   I want to pic up the distinct ID when Dis stautus = 1 and Exp status = 2,3,4.    Can anyone tell me how to do?   thx.    ... View more

When we are talk about confouders in statistics, we usually say that the distribution of confounders is not equal in Expousre and Disease and the confounders also correlate with disease and expousre.   It is very easy to simulate confounder's effect in continuous variable and test it by regression by creating a random varaible on confouder and multiply it with plus one error term to get the x and y.    Now, the correlation between X and Y is due to confounder.    However, I am confused when I try to simulate in binary variable.    can everyone shows me how to do it in E, D, and Confounder all are binary variables.      ... View more

Hi everyone,    If i have a data which is the following   data t;INPUT x; cards; 1 2 1 2 3 1 2 ;    This data set is merged from each person.    So, its id should be 1 1 2 2 2 3 3.   How could I get the the id I want? I have tried use the if first statement, but I failed.    Please tell me the easiest way to do it.    ... View more

Hi, every one.   Recently, I am trying to select some sample using PROC SURVEYSELECT procedure.     I want to give the sequence the obeservtion, for example, the I have 5 observation, 1 to 5.   the sequecne for sampling without replacement may be is 3 5 4 1 2.    but, everytime the sas only give me the output data which has been sorted.   so, i only can have a data set is 1 to 5.    I check the statement, the sort statement also does not provide the function I asked.    if there is a easy way to get the results I want? ... View more