New board topics in SAS Support Communities

concatenate two macro variables with "/" between them

Ronein — Tue, 30 Apr 2024 11:23:25 GMT

Hello

I want to concatenate two macro variables with "/" between them.

I get error 49


%let customer_ID=9872622;
%let branch_Id=987;
%let customer_branch=%sysfunc(cat(&customer_ID.,"/",&branch_Id.));/***9872622/987*****/
%put &customer_branch;

Format proc report to output dates in excel using ods excel

Kia_B — Tue, 30 Apr 2024 12:56:04 GMT

I am attempting to output an excel (xlsx) file using ods excel from a proc output. My variables are in date9. format in the SAS data set, but when they output to excel they are in a text format.

This is my code:

ods excel file="\\xxxmyfilelocation\Events_%sysfunc(date(),yymmddd10.).xlsx" style=forNESUG options (FLOW='Tables');

ods excel options (zoom='80' sheet_name='Tracker');

proc report data=tracker nowd split= "_" style(column)=[JUST=LEFT VJUST=TOP FONT=(Calibri, 11pt, NORMAL) BORDERSTYLE=SOLID BORDERCOLOR=black]

style(header)=[BACKGROUNDCOLOR=light grey FONT=(Calibri, 11pt, BOLD) JUST=CENTER VJUST=TOP BORDERSTYLE=SOLID BORDERCOLOR=black];

column Initial_Code_Date Initial_Attribution_Date Initial_SO_Coverage Date_of_AE_status_Evaluated Initial_Rep_event_became_SAE Type_of_SAE Final_attribution Study_RX_held Treatment_rechallenged Treatment_Permanently_Discontinu Status_AE SO_FU_Log_Comments AF_summary_comments Final_MedDRA_code Final_MedDRA_LLT FINAL_Code_Date Final_Attribution_Date FU_SO_Coverage Initial_site_email_archived_ Final_site_email_archived_ Completed_pharma_reporting_ Closed SO_closed_AE Close_Date Teaching_example Tracker_run_date;

define Initial_Code_Date/'Initial Code Date' style={background=lightyellow color=black};

define Initial_Attribution_Date/'Initial Attribution Date' style={background=lightyellow color=black};

define FINAL_Code_Date/'Final Code Date' style={background=lightyellow color=black};

define Final_Attribution_Date/'Final Attribution Date' style={background=lightyellow color=black};

define SO_Log_Comments/'SO Log Comments' style(column) = [just=left cellwidth=3in background=lightyellow color=black] style(header)=Header{background=lightyellow color=black};

define SO_FU_Log_Comments/'SO FU Log Comments' style(column) = [just=left cellwidth=3in background=lightyellow color=black] style(header)=Header{background=lightyellow color=black};

define Reas_NonReportable_AE/'Reas NonReportable AE' style(column) = [just=left cellwidth=0.5in background=lightyellow color=black] style(header)=Header{background=lightyellow color=black};

define Teaching_example/'Teaching example' style={background=lightyellow color=black};

define Closed/'Closed' style={background=lightyellow color=black};

define SO_closed_AE/'SO closed AE' style={background=lightyellow color=black};

define Close_Date/style={background=lightyellow color=black};

options missing=" ";

format Initial_Code_Date date11. Initial_Attribution_Date date11. Final_Code_Date date11. Final_Attribution_Date date11. Close_Date date11.;

run;

I think the issue is my define statement, because the last block of code which exports to a different sheet in the excel workbook exports the date correctly and there is no define statement.

proc report data=sites nowd split= "_" style(column)=[BACKGROUNDCOLOR=white JUST=LEFT VJUST=TOP FONT=(Calibri, 11pt, NORMAL) BORDERSTYLE=SOLID BORDERCOLOR=black]
style(header)=[BACKGROUNDCOLOR=light grey FONT=(Calibri, 11pt, BOLD) JUST=CENTER VJUST=TOP BORDERSTYLE=SOLID BORDERCOLOR=black];
column SiteNo Name Status Country Status_Date Note;
format Status_Date date11.;
run;

Any suggestions?

Can we prevent publishing intelligent decision with the same name if publishers are different users?

Mayt — Tue, 30 Apr 2024 10:57:15 GMT

Hi guys!

I use SAS viya and my environment has many users. I want to publish a decision, and want it to be replaced if the published name is the same as my old published decision. I know we can press "Replace item with the same name"

But can we prevent publishing if another user want to publish it with the same name like mine?

Thank you in advance!

How to import SPSS file with SAS OnDemand for Academics

ElsayedamrBasma — Tue, 30 Apr 2024 13:36:22 GMT

I am new to SAS OnDemand
please can anyone help me to know how to import SPSS file from my hard-disk to SAS library to work on it.

Editing slice labels in a donut chart so that they don't overlap

ElGent99 — Tue, 30 Apr 2024 09:23:09 GMT

Hi everyone,

I need to visualise some survey data using a donut chart in PROC GCHART. Because some adjacent pie slices are very small, their percentages and labels overlap. See below (chart generated using sample data):

Is there a way to display the slice percentage on the same line as the slice label instead of after a line break? If yes, can someone provide me with a snippet of code that achieves this? I don't think it's possible within PROC GCHART, but I've heard PROC TEMPLATE or the graphics editor might help (I'm a novice so I can't figure out either). I'm using SAS 8.3.

Alternative solutions I've considered and discarded:

Reordering slices so that small segments are not together: can't do that because of the nature of the data (Likert scale).
Experimenting with ARROW/INSIDE/NONE/OUTSIDE and ANGLE: already done, labels still overlap in the original data.
Using PROC SGPIE instead: not available in the version of SAS that my organisation uses.

Here's the sample data I used to generate the chart:

data survey;
input name $ q1 & $100.;
datalines;
John Very positive
Cathy Very positive
Phil Very positive
Jason Very positive
Darryl Very positive
Gary Very positive
Courtney Very positive
Andrea Very positive
Dave Very positive
Andy Very positive
Will Very positive
Zach Very positive
Isla Very positive
Florence Very positive
Henry Very positive
Mo Very positive
Evie Very Positive
Nigel Positive
Linda Positive
Anna Positive
Luke Positive
Arlo Positive
Archie Positive
Wendy Positive
Meghan Positive
Jack Positive
Lucy Positive
Theo Positive
Dylan Positive
Grace Positive
Stella Positive
Eva Positive
Nora Positive
Camilla Positive
Violet Positive
Jude Positive
Harry Positive
Louis Neither positive nor negative
Joe Neither positive nor negative
Leo Neither positive nor negative
Janet Neither positive nor negative
Debbie Neither positive nor negative
Alex Neither positive nor negative
Daniel Neither positive nor negative
Nina Neither positive nor negative
Gabe Neither positive nor negative
Oliver Neither positive nor negative
Anthony Neither positive nor negative
Chris Neither positive nor negative
Evan Neither positive nor negative
Adam Neither positive nor negative
Max Neither positive nor negative
Sophia Negative
Mia Negative
Abigail Negative
Caroline Negative
Shane Negative
Chloe Negative
Clint Negative
Lizzie Negative
Sarah Negative
Nick Negative
Amelia Negative
Ava Negative
Hazel Negative
Ivy Negative
Olive Negative
Rose Negative
George Negative
Arthur Negative
Ben Negative
Finn Negative
Elliot Negative
Sam Negative
Josh Negative
Kai Negative
Jacob Negative
Hugo Negative
Mason Negative
Mike Negative
Liam Negative
Vanessa Very negative
Fred Prefer not to say
;

proc ttest pvalue

HitmonTran — Tue, 30 Apr 2024 07:06:04 GMT

Hello,

I don't have a deep knowledge on statistics. Can someone please confirm if I did this correctly to obtain the P-value for Mean different from 0 (t-test, 2-sided)??

proc ttest data=base_post side=2 ;
by trt01pn; 
var cat3;
ods output TTests=pval;  **pvalue;
run;

Thank you!

Creating a single bar chart from multiple variables

NeilH — Mon, 29 Apr 2024 20:32:40 GMT

Hello - I know questions like mine have been asked before, but I wasn't able to find an answer that I could adapt to my situation. I would like to create a single bar chart with individual bars for several variables in my dataset, where the values for each variable are either 0 or 1 for each record in the dataset.

I created a series of binary (0/1) variables from questions on a survey where respondents could select one more options (e.g. bn_option1, bn_option2, ...) . Now I'd like to create bar charts for the % of '1's for each option (binary variable) of the corresponding question. One bar chart per question with as many bars as there were originally options. Thanks.

Processing Time on Macro Variables Resolved within a Macro Function vs a Data-Step Function

sjb1 — Mon, 29 Apr 2024 20:21:44 GMT

I am wondering if there are any rules about how SAS handles constants and if having the macro language resolve macro variables before they reach the data-step can improve processing time.

Take the following toy example. (I know there are more efficient ways to achieve the same outcome in the code below, this is purely for illustrative purposes.)

%macro macro_vs_datastep();

	%let macro_date = 01JAN1980;
	%let quarters_to_process = 10;

	data data_step;
		set sashelp.gnp;
		%do h = 1 %to &quarters_to_process;
			if intnx("QUARTER", Date, 0, "E") = intnx("QUARTER", "&macro_date"d, &h, "E") then output;
		%end;
	run;

	data macro;
		set sashelp.gnp;

		%do h = 1 %to &quarters_to_process;
			if intnx("QUARTER", Date, 0, "E") = %sysfunc(intnx(QUARTER, "&macro_date"d, &h, E)) then output;
		%end;
	run;

%mend;

%macro_vs_datastep();

My intuition is that that resolving the macro variables 'macro_date' and 'h' inside of %sysfunc() should reduce I/O time as in the 2nd data-step, as SAS only has to resolve intnx() with each loop of 'h'. Compare that to the first data-step where intnx() must be resolved with each loop of 'h' along with each record in the dataset.

Are there any rules-of-thumb around best practices in these sorts of situations?

Calculating Cohen's d from multiply imputed data

statshuevo — Mon, 29 Apr 2024 19:30:01 GMT

Hi everyone, apologies if this has been asked but I couldn't find an answer for my specific question. I wanted to get confirmation that what I am doing is appropriate. I have 20 imputed datasets. The grouping variable (2 groups) is called "condition". To compute pooled means across the imputed datasets I used the estimate statement in PROC MIXED for each level of condition:

ODS TRACE ON;
ODS OUTPUT SolutionF=solutionf Estimates =est3;

PROC MIXED data=data noclprint covtest method=ml;

class tid pid condition (ref='0');

model totalscore=condition/solution ddfm=bw;

random intercept/sub=tid type=un;

estimate "Intercept: 0" intercept 1 condition 0 1;
estimate "Intercept: 1" intercept 1 condition 1 0 ;
estimate "Intercept: 1-0" intercept 0 condition 1 -1 ;

store out=model;

by _Imputation_;

run;

proc mianalyze data=est3;

modeleffects Estimate;

stderr stderr;

run;

For example, let's say this procedure gave me pooled estimates (means) of 8 for condition=0 and 7 for condition=1.

Then I calculated pooled SD using proc ttest and mianalyze:

proc ttest data=data;
class condition;
var totalscore;
by _Imputation_;
ods output statistics=ttest_ds
run;
proc sort data=ttest_ds;
by class _Imputation_;
run;

/*The dataset ttest_ds has Class variables of 0 and 1 (for the groups) and "Diff (1-2)" Pooled and Satterthwaite. It also has columns for StdDev and StdErr by Imputation for the two classes.*/

data subset;
set ttest_ds;
where Class='0'; /*switch to 1 for condition=1*/
run;
proc mianalyze data=subset;
by class;
modeleffects stddev;
stderr stderr;
run;

This gave me pooled SDs of, for example, 5.8 for condition=0 and 5.6 for condition=1.

Then I calculated Cohen's d:

data cd;
mean_diff_rand1 = 8 - 7; /* pooled means for conditions = 0 and 1*/
pooled_std_dev_rand1 = sqrt((5.8**2 + 5.6**2) / 2); /* pooled SDs for conditions = 0 and 1 */
d_rand1 = mean_diff_rand1 / pooled_std_dev_rand1;
run;
proc print data=cd; /*printing result*/
run;

I hope this is enough information. Thank you kindly in advance!

SAS Viya 4 POC on AWS- Reverting changes / restoring backup

thesasuser — Mon, 29 Apr 2024 18:14:06 GMT

Hello
While exploring the SAS Viya POC on AWS, I was looking for ways to revert the configuration (in Environment manager using kubectl) to a previous days backup. Something like restoring the metadata server back to a previous state in SAS 9.x.
I read the following three well written, scholarly references, which must be very handy and useful to the the knowledgeable.
https://documentation.sas.com/doc/en/sasadmincdc/v_045/calbr/p0cw7yuvwc83znn1igjc16zah2se.htm

https://documentation.sas.com/doc/en/sasadmincdc/v_045/calbr/n1607whucnyc02n1eo6tbvl1tzcs.htm

I got lost lost and move to other priorities.
Wondering if that is something possible? If yes how?

Severe penalty for using MFILE?

peterprec — Mon, 29 Apr 2024 18:04:06 GMT

I’ve noticed that when enabling the MFILE option, which is very handy in many situations ranging from debugging to producing production-ready programs, program execution time is severely impacted. Much more than the simple I/O operation of writing the MPRINT statements already being written to the program log would suggest. Depending on the complexity and amount of macro code to be resolved, this may cause the execution to take 5-7 times longer. And to be precise, I am only referring to adding the MFILE option on top of the MPRINT. I’ve coded a simple example in which the performance within SODA is ~2.5 times slower. I’ve noticed this behavior in the past, in local DM, SAS server, SAS EG, etc. applications., in Windows environments etc. It seems like a global issue with the MFILE implementation.

To investigate, I’ve also played around with the FILENAME statement (in which the MPRINT fileref is set) but it seems to have little impact.

Here is a snip of the proc print and means output

@Sas technical support? Anyone has any ideas?

The code used to test:

%macro test;
    %do i=1 %to 250;

        data t&i.;
            %do j=1 %to 100;

                do k&j.=1 to 5;
                    output;
                end;
            %end;
        run;

    %end;

    %do i=1 %to 250;

        data t&i.;
            %do j=1 %to 100;

                do k&j.=1 to 5;
                    output;
                end;
            %end;
        run;

    %end;
%mend;

%macro wmfile;
    filename mprint temp;
    options mprint mfile;
    %test;
    options nomfile;
%mend;

%macro womfile;
    options mprint nomfile;
    %test;
%mend;

data bench;
    length onbench $200;

    do run=1 to 3;
        do onbench='%wmfile', '%womfile';
            start=time();
            rc=dosubl(onbench);
            end=time();
            mark=end-start;
            output;
        end;
    end;
run;

proc print data=bench;
run;

proc means data=bench;
    class onbench;
    var mark;
run;

20 year SAS user, but first post here. Thanks for your time.

ERROR in using NLPNRA and PROC IML for MLE of custom function

roystriker77r — Mon, 29 Apr 2024 17:42:04 GMT

Dear community,

I am trying to follow Rick Wicklin's example of using NLPNRA with PROC IML for maximum likelihood estimation. Unfortunately, I am encountering an error with NLPNRA.

I am trying to use this script to find the MLE of a two parameter, two variable custome probability mass function:

/*Define Density Function*/

data multivariate_data;
call streaminit(5);
%let theta1 = 5;
%Let theta2 = 3;
	array Xi[2];
    do i = 1 to 1000;
        do j=1 to 2;
        Xi[j]= rand('Bernoulli',.5);
        end;
  	N=exp(&theta1*(Xi[1]+Xi[2])+&theta2*Xi[1]*Xi[2]); /*numerator of density function*/
  	D=(1+2*exp(&theta1)+exp(2*&theta1+&theta2)); /*denominator of density function*/
  	P=N/D;
        output;
        
    end;
    drop i j;
run;

proc print data= multivariate_data;
var P;
RUN;


proc iml;
use multivariate_data;
read all var {"Xi1","Xi2"} into x;
close multivariate_data;
/* write the log-likelihood function the distribution of interest */
start LogLik(param) global (x);
   theta1 = param[1];
   theta2 = param[2];
   n = nrow(x);
   return ( theta1*(sum(Xi1)+sum(Xi2)) + theta2*sum(Xi1)*sum(Xi2)-n*log(1+2*exp(theta1)+exp(2*theta1+theta2)) );
finish LogLik;



p = {2 4};/* initial guess for solution */
con = {., .}; /* Upper bounds for parameters (if any) */
optn = {1,  /* find max of function       */
        3}; /* print a lot of output      */
call nlpnra(rc,xres,"LogLik",p,optn,con);

However, after running this code I receive an error code following the nlpnra call that says error in argument BLC. After reviewing the documentation I thought that
BLC was an option argument so I am confused as to why I am receiving this error. Anyt help would be much appreciated.
Thanks!

SAS Log ERROR

Teja2309 — Mon, 29 Apr 2024 17:17:41 GMT

I have this below error when I am trying to import and open a sas7bdat dataset in work library

ERROR: YZR malfunction: file RAW1.AE_SAE.DATA trashed or YZR code bug.

Can you please let me know if anyone have solution?

Filter dataset by for March 2024

Justin9 — Mon, 29 Apr 2024 16:31:00 GMT

Hi,

I have a dataset called test_dataset and want to only keep accounts where the c_EFF_DT variable is in March 2024 (so in example below, only the account with 02MAR2024 would remain). My code below isn't filtering correctly, so can someone help me to correct it please?

data test_output;
set test_dataset;
where "01Mar2024"d <= c_EFF_DT <= "31Mar2024"d;
run;

SAS User details from Metadata

Nivas88 — Mon, 29 Apr 2024 16:18:19 GMT

Hello,

I do have lot of users defined in my SMC environment and I need a report to be generated in an excel (or) sas dataset with the below details

Username:

Description:

Job Title:

Group:

Groups:

Roles:

Authentication Domain:

UserId:

I dont want to perform copy paste activities. Do we have any SAS code to retrieve these details from metadata? Please let me know.

THanks

PROC GMAP

epi_econ_code — Mon, 29 Apr 2024 14:48:42 GMT

Hi everyone,
I am trying to create a map using the gmap procedure. I was able to successfully create the map as shown in the attached images. However, the block option allows us to create a 3-D map and the journal I want to publish this in does not accept 3-D graphs. How can I show the counts of the facilities that is shown using the block option in a 2-D format? Basically, how can I incorporate the information coming from two response variables in a choropleth map?Help to change this block into a 2-D map

Create a table of nmiss

AHSU12 — Mon, 29 Apr 2024 14:39:06 GMT

I have a dataset of 8025 participants. I created a composite variable of five items and now I want to create a table of nmiss for each 5 items . That is, the distribution in the sample of 8,025 participants who across these 5 items have 0 missing items, those with 1 missing item, etc, all the way to those with missing values on all 5 items. However, I could only create a count of missing for each item as shown in below. Any help would be highly appreciated. TIA.

please see the code below.

Access fit line coefficients

sc5 — Mon, 29 Apr 2024 14:29:44 GMT

Hi,

Is there a way I can access the coefficients of a linear fit through a scatter plot and use it in calculations displayed in a report?

E.g. I have 2 scatter plots, both controlled by a set of List controls. Every time I change the list selection, the data displayed and the fit lines on both plots change.

is there any way to display a table with the difference between the calculated y-values from both fit lines at certain x-values?

This table would dynamically update every time the list control selection changes, and it would be displayed on the main report page.

Essentially, are the intercept, slope and R-square stored anywhere as objects I can reference? Like can I create a parameter as @chartobject.slope or something?

I can see them when I maximise the chart object, but I don't see a way to display them dynamically updating as part of the main report page.

In Excel this is easy with pivot tables. Slicers control charts connected to the pivot tables, and formulas =intercept(<y_col>,,x_col>), =slope(<y_col>,,x_col>) capture the trendline dynamically in cells anywhere I want.

I don't want to have to export a regression / run code / refresh the report / etc., the aim is just to do some quick interactive analysis in the report as we slice data on-the-fly.

Thank you!

How to put the files listing into a sas dataset

alepage — Mon, 29 Apr 2024 13:55:23 GMT

Hello I am using the following command to get the listing of the S3 bucket. it goes into the log file.

How to put it into a SAS dataset?

%let s3bucketpath=s3://***-pr-brz-datareten-edp-nprod;

filename oscmd pipe "aws s3 ls ""&s3bucketpath."" ";

Kickstart innovation with SAS Viya Workbench

BeStibolt — Mon, 29 Apr 2024 13:42:01 GMT

By Christian Christensen, Principal Pre-Sales Technical Architect, Customer Advisory Technology Northern Europe

In my everyday work, I often encounter many situations in which technology plays an important part. When ideas ignite any innovation, the idea is in a crucial phase. So, getting started in the shortest amount of time is super important to keep ideas at the forefront of your mind. This is one of the reasons why I think SAS Viya Workbench is a great leap forward for the SAS Platform. Getting started with Data and AI heavily depends on integration, easy initiation, and self-service options.

You might ask – "What is SAS Viya Workbench?" – So, let's recap:

"SAS Viya Workbench is a collaborative environment designed for data scientists and analysts to work with data, perform analytics, and develop models. It provides an integrated platform for data preparation, exploration, analysis, and visualization, as well as tools for building and deploying machine learning models.

SAS Workbench offers a user-friendly interface that allows users to perform tasks like data cleaning, transformation, statistical analysis, and machine learning modeling without writing extensive code. It includes features for version control, sharing work with team members, and collaborating on projects.

Overall, SAS Workbench aims to streamline the data science workflow, making it easier for users to derive insights from data and build predictive models efficiently."

Link to more information about Viya Workbench.

My top 3 favorite advantages of SAS Workbench are for sure these:

SAS Workbench is ready to use all the time…It's online Software As A Service and is ready to log in when needed.
SAS Workbench focuses on openness – So you can select your favorite editor and code language – Use Visual Studio as an editor. SAS, R or Python? You decide… Find more on GitHub.
SAS Workbench has all the new modern capabilities – ready for your idea. AI by Machine Learning, Generative AI, Deep Learning, Neural Networks, Image –imagine what we can do on f.x. Images of cancer.

I foresee a great future with the new technologies – now even easier and more accessible than ever, and I hope you agree.

Link to more information about Viya Workbench.