Recently in the SAS Community Library: SAS' @Sundaresh1 highlights a sometimes overlooked task when applying document embeddings for purposes of similarity-based search. Normalisation of vectors helps obtain relevant matches.
Hi All, my teammates have sas newly installed in pc and got the above message when trying to use it. Any idea what could be the problem? just had sas eg installed but cannot use it, showing error message in the above attached picture. I also pinged it. What could be the problem? what other test can I do to trouble shoot? how to resolve?
... View more
I have a data set with DMRN and date of the visit (DX_Date). I would like to generate the the start and stop time or T1 and T2 based on each visit date. Could you please help me with the code?
Here is how the data look like:
DMRN
DX_DATE
31
09MAY2017
31
30MAY2017
31
06APR2018
31
07FEB2019
33
02JUN2017
33
04DEC2017
33
11JUN2018
This is how I want to outcome be like:
DMRN
T1
T2
31
09MAY2017
30MAY2017
31
30MAY2017
06APR2018
31
06APR2018
07FEB2019
33
02JUN2017
04DEC2017
33
04DEC2017
11JUN2018
... View more
%macro sort (dname, new, svar) ;
proc sort data=&dname out=&new ;
by &svar;
run;
%Mend;
%sort(sashelp.class, demo1,sex);
data _null_;
if cexist("WORK.SORT") then
put "WORK.SORT exists";
else
put "WORK.SORT does not exist";
run;
Hi Experts,
here i am trying macro catolog exist or not but its giving wrong output please check where i did wrong
... View more
Dear SAS community, I am trying to run weighted models for nested data (a panel survey) using PROC GLIMMIX; however, I keep getting an error and a warning (please see the SAS code and log below). I modified the Glimmix code a bit (added points and specified GCONV), but the error and the warning are still the same. When I remove the "obsweight=HCNSWGTR" and use method=laplace, the code runs just fine. Do you have any suggestions on how to address this issue? I have also attached my data. Thanks. PROC GLIMMIX DATA = test1 METHOD=QUAD(FASTQUAD QPOINTS=100) plots=all;
CLASS RAHHIDPN STRATCLUS GENDER(REF='1') RACE_ETH(ref='1') MARITAL(ref='1');
MODEL MOBILITY = BSAGE_C BSAGE_C*BSAGE_C GENDER GENDER*BSAGE_C RACE_ETH RACE_ETH*BSAGE_C RACE_ETH*GENDER
TIME TIME*TIME TIME*BSAGE_C TIME*GENDER TIME*RACE_ETH/solution obsweight=HCNSWGTR ;/**LEVEL 1 VARIABLES**/
RANDOM INTERCEPT /subject=STRATCLUS type=VC ;
RANDOM INTERCEPT /subject=RAHHIDPN(STRATCLUS) type=VC ;
NLOPTIONS GCONV=0.00001;
COVTEST/WALD;
ODS OUTPUT parameterestimates=FIXED1 covparms=RAND1;
RUN; NOTE: PROCEDURE GLIMMIX used (Total process time):
real time 24.92 seconds
cpu time 11.03 seconds
326 PROC GLIMMIX DATA = test1 METHOD=QUAD(FASTQUAD QPOINTS=100) plots=all;
327 CLASS RAHHIDPN STRATCLUS GENDER(REF='1') RACE_ETH(ref='1') MARITAL(ref='1');
328 MODEL MOBILITY = BSAGE_C BSAGE_C*BSAGE_C GENDER GENDER*BSAGE_C RACE_ETH RACE_ETH*BSAGE_C RACE_ETH*GENDER TIME TIME*TIME TIME*BSAGE_C TIME*GENDER TIME*RACE_ETH/solution obsweight=HCNSWGTR ;
330 RANDOM INTERCEPT /subject=STRATCLUS type=VC ;
331 RANDOM INTERCEPT /subject=RAHHIDPN(STRATCLUS) type=VC ;
332 NLOPTIONS GCONV=0.00001;
333 COVTEST/WALD;
334 ODS OUTPUT parameterestimates=FIXED1 covparms=RAND1;
335 RUN;
WARNING: Class levels for RAHHIDPN are not printed because of excessive size.
ERROR: QUANEW Optimization cannot be completed.
WARNING: The initial estimates did not yield a valid objective function.
NOTE: The data set WORK.RAND1 has 3 observations and 4 variables.
WARNING: Output 'parameterestimates' was not created. Make sure that the
output object name, label, or path is spelled correctly. Also,
verify that the appropriate procedure options are used to produce
the requested output object. For example, verify that the NOPRINT
option is not used.
NOTE: PROCEDURE GLIMMIX used (Total process time):
real time 5:39.58
cpu time 2:48.00
... View more