Приветствую всех,
Когда я подключил Click House в Sas, я обнаружил эту ошибку. ОШИБКА: Исходный оператор SQL содержит UDF, который не передается в базу данных. Выполнение SQL остановлено.
Помогите пожалуйста, как решить эту проблему, прилагаю запрос
процедура SQL; подключиться с помощью клика; создать таблицу work.DEP TO GOLD_OR_CLICK как выбрать | от соединения до щелчка (выберите event_id, имя события, метку времени события, хеш идентификатора пользователя, продукт, выбранный продукт, канал из событий aws, где aws _events.event_name awsevents.event timestamp >= Today ()-30) ярлык пополнения учетной записи нажмите' отключение от щелчка; покидать;
... View more
I recently started using the TableN macro and I wanted to say thank you to @JeffMeyers for providing such a useful macro! I was able to produce Table 1 for TM_group (which is a binary variable with values 0,1). However, I would now like to create Table 1 for subgroups based on the ADRD_group variable (which is also 0,1). The documentation for the macro indicates the COLBY option can do exactly what I'm looking for, and provides an example output table with Gender and Arm. However, I can't find good example syntax of how to add the COLBY option to the code. I've tried a few variations, but I keep getting errors. Below is my latest version.
%tablen(
data=have;
,by=TM_group
.colby=ADRD_group
,var=DEM_AGE DEM_SEX
,type=2 2
,outdoc=C:\Users\r\Desktop\TM vs MA ADRD Table 1(&version.).rtf
);
... View more
Is it possible to use SAS for annotating the CRF(case report form in Clinical Trials) ? If so, please assist on how to do it? Looking forward to your response. Thanks In advance
... View more
Dear All, I am quite a new user using SAS software. Please give me some suggestion base on the scenario below: 1. I have time series data for almost 2 years, which records the date and the amount of money that earn daily but in this case user record the data only weekdays (data for sat and sun is empty). 2. Base on the data i have, i try to identified, include dummy variables, estimate and got the satisfied model to do forecasting. This also include the cosscorr pamarameter. 3. However, when i try to run forecasting by using proc arima data=data ; identify var=money crosscorr=(Monday Tuesday Thursday Friday ); estimate input=(Monday Tuesday Thursday Friday ) p= (0) (21) q= (1) (0); forecast lead=30 interval=day id=date out=results; run; i got an error "The value for option LEAD= has been reduced to 0." and the results that i got is generate only for the trained variable. The lead forecasting is not generate for me. I am not sure the forecast syntax is working with my data struture or not. Please feel free to leave some comments on this or please share some ideas how can i solve this issue. Regards, santisouk
... View more