Hello,   I have 4 variables (sex, age, education, country) from two different sources. I would like to create a table to compare the distribution of education level (3 categories) by age and sex for every country. My initial plan was to simply merge the output of proc freq using list option, such as:   proc freq data=data1; table sex*cntry*grage*edu/list nofreq nopercent nocol; run;   proc freq data=data2; table sex*cntry*grage*edu/list nofreq nopercent nocol; run;   Howewer, it seems that it is no possible to have percents in the output when we use /list, because only the frenquency appears. When I remove /list, I have like 50 tables. What should I do?   Thank you. ... View more

Hello, I know it is possible to estimate relative risks from a binomial logistic regression using proc genmod, as explained there: http://www.ats.ucla.edu/stat/sas/faq/relative_risk.htm   Is it also possible to do something similar for a multinomial logit regression?   Thank you ... View more

Hello, I have 30 CSV files into a folder (P:\mydirectory). I would like to import them at once into SAS. I listed them into a csv file(listfiles .csv), which has this format:   Name_list FileA.csv FileB.csv etc.   So I tried this: proc import datafile="P:\mydirectory\listfiles.csv" out=work.listcsv dbms=csv replace; getnames=yes; run; proc sql; select name_list into :name separated by '*' from work.listcsv; %let count2 = 30; quit; %macro import; %do i = 1 %to 30; %let j = %scan(&name,&i,*); proc import out = &j datafile="P:\mydirectory\&j"; dbms=csv replace; getnames = yes; run; %end; %import;   And nothing happens. Can you please help me to find why? ... View more

Hello, I have a bunch of datasets labels a1y b2y c3y.   I would like to concatenate them into a single one, which would have a variable indicating the name of the original dataset. It's probably easy, but I didn't find how.   Thank you ... View more

Hello, I've perform a mixed logit model with proc MDC. For some of the random coefficients set in the model, I get negative standard deviation. How is it possible? I cannot show you the codes and output because I work in a secure lab, but the problem seems to be the same as the one presented here: http://compgroups.net/comp.soft-sys.sas/mixed-logit-proc-mdc/643485   Thanks   ... View more

Hello, I have a dataset1 that looks like this : NOIND ALT NO_DWEL CHOICE X1 X2 1 1 842 1 1 1 1 2 773 0 1 1 1 3 5543 0 1 1 2 1 76 1 0 1 2 2 6087 0 0 1 2 3 8228 0 0 1 3 1 737 1 1 0 3 2 7339 0 1 0 3 3 3006 0 1 0   And a dataset2 that looks like this: NO_DWEL X1 X2 1 1 0 2 0 0 3 1 1 4 1 0 …       I want to perform a conditional merging only when CHOICE=0, so the value of X1 and X2 of the dataset1 will be replaced by those of the dataset2 for lines when CHOICE=0 and will be keep as it is when CHOICE=1. The solution I find is probably not the best one and become complicated for further works… I rename variables of dataset2, perform a normal merge and then replace variables in the new dataset with IF THEN DO. Can someone please help me to find a more efficient way to do this? ... View more