Hello,   I trying to use if and else if condition to define macro variables varname and varname2 but I am unable to check their value. Does someone can help me with that issue.   data _null_; set inforcelisting5; call execute (compbl(cat( "Libname dssource ", engine,'"',path,'";', '%nrstr(%macro lookuptbl;)', '%nrstr(%if %varexist(',strip(fname),',police) %then %do; %let varname=police;%end;)', '%nrstr(%else %if %varexist(',strip(fname),',agreement_nbr) %then %do; %let varname=agreement_nbr;%end;)', '%nrstr(%else %if ',strip(cie),' eq be %then %do; %let varname2=datechea;%end;)', '%nrstr(%mend lookuptbl;)', '%nrstr(%lookuptbl;)', '%nrstr(%put &=varname &=varname2;)', "Libname dssource clear;" ))); run; partial log file:   NOTE: CALL EXECUTE generated line. 1 + Libname dssource base"/dwh_actuariat/sasdata/sas2002/be/habi/bel.prod1000.sah1stat.dec2002.data/ "; NOTE: Libref DSSOURCE was successfully assigned as follows: Engine: BASE Physical Name: /dwh_actuariat/sasdata/sas2002/be/habi/bel.prod1000.sah1stat.dec2002.data/ 1 + %macro lookuptbl;%if %varexist(polices,police) %then %do; %let varname=police;%end;%else %if %varexist(polices,agreement_nbr) %then %do; %let 2 The SAS System 13:22 Thursday, September 19, 2024 2 + varname=agreement_nbr;%end;%else %if be eq be %then %do; %let varname2=datechea;%end;%mend lookuptbl;%lookuptbl;%put &=varname &=varname2;Libname dssource clear; WARNING: Apparent symbolic reference VARNAME not resolved. WARNING: Apparent symbolic reference VARNAME2 not resolved. varname varname2 NOTE: Libref DSSOURCE has been deassigned. ... View more

Hi All,   I am trying to assign -ve numeric value to a macro variable in SAS symput statement but getting error below. data one; infile datalines; input ID value ; datalines; -1 1234 -2 4567 -3 7890 -4 4321 ; run; data two; set one; call symput ( ID,value); run; ERROR: Symbolic variable name -1 must begin with a letter or underscore. Is there a way we can use -ve values without getting any error   Thanks  Kajal ... View more

Hello,   I'm encountering inconsistencies in results between Type 3 Tests of Fixed Effects and pairwise comparisons when using proc mixed.   My dataset consists of 5 subjects, each measured at 3 different time points. There are 15 observations in total.   I'm fitting a linear mixed-effects model to examine mean value differences among three groups. The Type 3 Test indicates a significant difference among at least one pair of groups (P-value = 0.0028), but none of the pairwise comparisons show significance (their p-values are 0.2096, 0.7895, and 0.8126). This discrepancy is puzzling to me.   For the variance-covariance structure, I've chosen the UN over CS and TOEP based on assumptions and AIC, but this inconsistency is specific to UN only and not observed with CS or TOEP.   Below is my SAS code. Any insights into this issue would be greatly appreciated!   proc mixed data=data plots=residualpanel; class id group; model outcome = group / s cl residual; repeated group / subject=id type=UN r rcorr; lsmeans group / cl diff; run;   Thank you!! ... View more

Hi everyone, Please I need help to address integrating SAS into PHP.   I'm trying to integrate SAS code into PHP that can deal with data manipulation using data step, proc sql, it will also use macro, etc. We have the code completed in SAS already, the code also make a macro call to another macro, it calculates Overall Concordance Correlation coeficient based on Barnhart equation, using %include. How can I integrate this existing programs into PHP(We are building an application using PHP). Thank You.  ... View more

Hello everyone, Thank you so much for all the help so far. I have a new challenge where I need to write a SAS code for below scenario   I have 1 master dataset as below IDNUM date 1             2401 2            2402 3            2403 4            2404 5            2405   and below are other datasets for providing other info. dataset_2401 IDNUM RANK 1           12 2          13 3          14 4          15 5           16   dataset_2402 IDNUM RANK 1             21 2            22 3            23 4            24 5 25 dataset_2403 IDNUM RANK 1             31 2            32 3            33 4            34 5            35 dataset_2404 IDNUM RANK 1             41 2            42 3            43 4            45 5            46 dataset_2405 IDNUM RANK 1             51 2            52 3            53 4            55 5            56   For IDNUM=1 I need to take rank from dataset_2401 for IDNUM=2 I need to take rank from dataset_2402 and so on and the new variable as after_rank basically rank from the table having suffix of date from master dataset and want to append all results in one table.   Can I please get the code in terms of Macro in SAS language.  Final dataset result IDNUM after_rank 1                 12 2                22 3                33 4                45 5                56   Regards kajal ... View more