SAS Visual Analytics Tips & Tricks Series: Working with URL links
Recent Library Articles
Recently in the SAS Community Library: In a video tutorial, SAS' @KalleM share three use cases that reveal how URL links can be used and created in SAS Visual Analytics.
Have you received a promotional email that for some reason did not render properly? Some content was missing? But you were still able to view the content of the email thanks to a “view on web” link that you selected to alternatively view the email content on a web browser? I’ve had to do this myself a few times. There is a feature available in SAS Customer Intelligence 360 that is very easy to set up and use to provide this alternative viewing. Some organizations have a policy to always provide this email feature as a backup for the occasion where their email recipients have an issue with rendering the email using whatever email application or device they are using at the time.
... View more
Hello,
I have tried two different uncompress command and based on the log file, it seems two work. But I am unable to read the .dat file from work.
how to solve that issue.
%let path=/dwh_actuariat/sasdata/Data_Retention/sas2002/be;
filename oscmd pipe "uncompress -c &path./bel.prod0110.se8030ac.m525.dat.Z > &path./bel.prod0110.se8030ac.m525.dat 2>&1";
data _null_;
infile oscmd;
input;
put _infile_;
run;
%let work=%sysfunc(pathname(work));
%put &=work;
filename oscmd pipe "uncompress -c &path./bel.prod0110.se8030ac.m525.dat.Z > &work./bel.prod0110.se8030ac.m525.dat 2>&1";
data _null_;
infile oscmd;
input;
put _infile_;
run;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML 28 29 %let path=/dwh_actuariat/sasdata/Data_Retention/sas2002/be; 30 filename oscmd pipe "uncompress -c &path./bel.prod0110.se8030ac.m525.dat.Z > &path./bel.prod0110.se8030ac.m525.dat 2>&1"; 31 32 data _null_; 33 infile oscmd; 34 input; 35 put _infile_; 36 run;
NOTE: The infile OSCMD is: Pipe command="uncompress -c /dwh_actuariat/sasdata/Data_Retention/sas2002/be/bel.prod0110.se8030ac.m525.dat.Z > /dwh_actuariat/sasdata/Data_Retention/sas2002/be/bel.prod0110.se8030ac.m525.dat 2>&1"
NOTE: 0 records were read from the infile OSCMD. NOTE: DATA statement used (Total process time): real time 1.48 seconds cpu time 0.00 seconds
37 38 %let work=%sysfunc(pathname(work)); 39 %put &=work; WORK=/saswork2/ua_bicoe/SAS_work715900039C52_stha8p08j/SAS_work0FAD00039C52_stha8p08j 40 filename oscmd pipe "uncompress -c &path./bel.prod0110.se8030ac.m525.dat.Z > &work./bel.prod0110.se8030ac.m525.dat 2>&1"; 41 42 data _null_; 43 infile oscmd; 44 input; 2 The SAS System 10:52 Thursday, September 26, 2024
45 put _infile_; 46 run;
NOTE: The infile OSCMD is: Pipe command="uncompress -c /dwh_actuariat/sasdata/Data_Retention/sas2002/be/bel.prod0110.se8030ac.m525.dat.Z > /saswork2/ua_bicoe/SAS_work715900039C52_stha8p08j/SAS_work0FAD00039C52_stha8p08j/bel.prod0110.se8030ac.m525.dat 2>&1"
NOTE: 0 records were read from the infile OSCMD. NOTE: DATA statement used (Total process time): real time 1.42 seconds cpu time 0.00 seconds
But I am unable to import a .dat file in sas
PROC IMPORT DATAFILE = "&work./bel.prod0110.se8030ac.m525.dat" OUT = np DBMS = DLM REPLACE; DELIMITER=" "; RUN;
... View more
I am trying to delete a file and it had created a copy of itself in my library and my data. I am unable to delete it because it says "INVALID PHYSICAL NAME"
... View more
Hi every one, I am a new SAS user and trying to calculate RR of binary outcome using log Poisson distribution. But my model didn't converge even after specifying the convergence option as follow; Proc format; value WDP_Terttile 0='T1' 1='T2' 2='T3' ; Proc genmod descending data = Biomark.bloodprofile30 ; class WDP_Terttile muspgen income21cat rcig21_c rrrchalc21_c reduc21_c TVHrPerW CBMI21c codea; model TAG_status30=WDP_Terttile muspgen age21ffq income21cat rcig21_c rrrchalc21_c reduc21_c TVHrPerW CBMI21c LEnergy_kC/dist = poisson link=log lrci type3 converge=0.000000001; repeated subject = codea/ type = unstr; estimate 'T2 vs T1' WDP_Terttile -1 1 0 0/exp; estimate 'T3 vs T1' WDP_Terttile -1 0 1 0/exp; estimate 'Female vs Male' muspgen -1 1 /exp; estimate 'Age at 21' age21ffq 1 /exp; estimate 'Middle vs High' income21cat -1 1 0 /exp; estimate 'Low vs High' income21cat -1 0 1 /exp; estimate 'smokers vs None' rcig21_c -1 1 /exp; estimate 'moderate vs light' rrrchalc21_c -1 1 0 /exp; estimate 'heavy vs light' rrrchalc21_c -1 0 1 /exp; estimate 'Comp Highsch vs Post sec' reduc21_c -1 1 0 /exp; estimate 'Inc Highsch vs Post sec' reduc21_c -1 0 1 /exp; estimate '2-4h vs < 2h' TVHrPerW -1 1 0 /exp; estimate '> 4h vs < 2h' TVHrPerW -1 0 1 /exp; estimate 'overweight vs Normal' CBMI21c -1 1 0 /exp; estimate 'Obese vs Normal' CBMI21c -1 0 1 /exp; estimate 'Energy' LEnergy_kC 1/exp; format WDP_Terttile WDP_Terttile.; run; Is there some one who could help me with this, please? I thank you in advance for your concern and time,
... View more
Hello, Please could someone help me to carry out PROC MIXED analysis of a crossover study in On Demand? I am looking to assess treatment effects from a crossover study using a linear mixed model, with change-from-baseline (Δ) for each 4-wk dietary intervention (calculated by subtracting: wk 0 from wk 4 values and; wk 8 from wk 12 values) as the dependent variable, adjusted for fixed effects of baseline values of the assessed variable, period, sequence, treatment, age, gender and BMI. The attached files worked fine with the University edition of the software, but I no longer have access to this software. I am getting error messages, such as 'ERROR: Variable RESPONSE not found.' Thanks in advance for your help. Oons
... View more