When we create table reports, most of the time we encounter a missing category or a missing treatment in our data.To handle missing categories or groups efficiently, we can use format and means with options completetypes and preloadfmt. Using these options help us to display missing values with zeros and display a missing treatment or group in the table output. ... View more

Please try to use the mixed=yes option to avoid the issue   PROC IMPORT OUT= mydata DATAFILE= "J:\users\nsouli\Debugging.xls" DBMS=EXCEL REPLACE; SHEET="'SAS$'"; GETNAMES=YES; MIXED=yes; RUN; ... View more

Could you please let me know how you want to use it in a macro variable, so i can help you ... View more

in that case please try the below code   data want; set have; need=prxchange('s/(.*sbsas)(.*\/)(.*sas)/$2/oi',-1,str); run; ... View more

The perl regular expression works on the basis of meta characters which recognizes the patterns like digits, letters, special characters, so here we are using the dot which means any character including the special character * which means recognize the any character including the special character any number of times sbsas is the word with which you want to end the pattern () is group, to recognize a particular group pattern so here we have 3 groups s/ - substitution $2 - keep the second group -1 - recognize the pattern as it occurs 1 or more o- retain the pattern to all records i - ignore case ... View more

try the below code   CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 WHEN conditionN THEN resultN ELSE result END as variable_name ca se when ENTITY_ID_SF in ('1000','1111') and SEGMENT='NL' then (sum(GR_INPUT)/(sum(PREM_RES_GR)/3)) when ENTITY_ID_SF in ('1000','1111') and SEGMENT='PL' then (sum(GR_INPUT)/(sum(PREM_RES_GR)/3)) else . end as variable_name     ... View more

Alternatively with perl regular expression you can try below code   data want; set have; need=prxchange('s/(.*sbsas)(.*)(sui_q.*)/$2/oi',-1,str); run; ... View more

Could you please share the code you used for this plot ... View more

Alternatively in a single data step you can try below code   data want; do until(last.subjid); set a; by subjid; if cd='XY8' then flag='Y'; end; do until(last.subjid); set a; by subjid; output; end; run;     ... View more

You may try   data want; set a; if cd='XY8' then sort=0 ; else sort=1; run; proc sort data=want; by subjid sort; run; data want2; set want; by subjid sort; retain flag; if first.subjid then flag=' '; if cd='XY8' then flag='Y'; run; ... View more