About BruceBrad

BruceBrad · ‎05-13-2024

Question edited now.

BruceBrad · ‎05-13-2024

I'm trying to strip some operators from a string, leaving behind variable names. I'm using the following code which doesn't work. Is there some quoting needed? %let expression = vara / (varb + varc); %macro stripsym(string); %sysfunc(translate(&string,,+-*/())); %mend stripsym; %put Output: %stripsym(&expression); %put Desired: vara varb varc;

BruceBrad · ‎05-03-2024

Having come across this old thread while researching the same question, I believe there is a solution. The NLEST macro https://support.sas.com/kb/58/775.html

BruceBrad · ‎04-24-2024

I'm not sure this is simple! It means I have to understand the interaction between attrpriority and cycleattrs. Even after reading https://blogs.sas.com/content/iml/2018/06/13/attrpriority-cycleattrs-styleattrs-ods-graphics.html this seems very messy.

BruceBrad · ‎04-24-2024

Great. So, summarising: - Reshape the data to use one series with groups (and use the 9.4m2+ options to control the group colours and patterns). - I guess reshaping the data and using multiple series without groups would also work (but not as elegant). Thanks.

BruceBrad · ‎04-24-2024

Thanks. I see now how to get all lines in the legend. But I need some way to indicate both the series and the group. Eg three different colours (or markers) for the series, and two different patterns for the groups (eg A=solid, B=dotted).

BruceBrad · ‎04-23-2024

Anyone have suggestions for simple ways to present this sort of data: multiple series with groups. The following codes doesn't work, the legend only has information for the groups in the first series. If I can't get both the series and groups in the legend, I'd like to have the series in the legend with a consistent formatting for the groups (eg group B always dotted lines). data temp; input x grp $ s1 s2 s3; cards; 1 A 1 1 1 2 A 2 3 4 3 A 1 2 3 1 B 1.2 1.2 1.2 2 B 2.2 3.2 4.2 3 B 1.2 2.2 3.2 ; run; proc sgplot data=temp; series x=x y=s1 /markers group=grp ; series x=x y=s2 /markers group=grp ; series x=x y=s3 /markers group=grp ; run;

BruceBrad · ‎12-04-2023

Your last description sums it up. I don't know which column the named range will be referring to. I have now sorted out a work-around. A bit clunky, but I can rely on the range being just a single column, and so the imported datafile will only have one variable. Then I can use this code to pull out the name of the variable. %macro FirstVName(data); %* returns the name of the first variable in the file; %let dsid = %sysfunc(open(&data,i)); %sysfunc(varname(&dsid,1)) %mend FirstVName;

BruceBrad · ‎12-03-2023

I want to read a named range of data from an xlsx file with getnames=no. It is a single column of numbers. How do I control the variable name that gets assigned to the data? It seems to be using the column name for the data (eg B if the range is in column B). However, the range is in different columns in different spreadsheets, so I don't know this in advance.

BruceBrad · ‎06-08-2023

Thanks. Very helpful.

BruceBrad · ‎06-08-2023

I have a dataset with observations for each year for each person. Some years are missing. I want to expand the file to have all years for each person (with missing values for the missing years). Can this be done with an SQL statement. The code below doesn't work. data one; input id year var; cards; 1 2001 3 1 2002 5 1 2003 7 2 2002 4 2 2003 6 ; run; data years; input year; cards; 2001 2002 2003 ; run; data desired; input id year var; cards; 1 2001 3 1 2002 5 1 2003 7 2 2001 . 2 2002 4 2 2003 6 ; /* this doesn't add in the missing row */; proc sql; create table comb as select years.year, one.id, one.var from years left join one on one.year = years.year order by id,year ; quit; run;

BruceBrad · ‎02-27-2023

I'll use that for now. Would be nice if there was a way of flagging which variables are constant within personID so I could just keep them - but for now I'll get by with just using the first value of each variable.

BruceBrad · ‎02-27-2023

No. Don't have the code or original datasets. I'm prepared to assume that any variable that is constant within personid comes from the person file. (Even if not, the fact that it is constant within person is useful enough).

BruceBrad · ‎02-27-2023

I'm trying to un-merge a dataset. More specifically, I have a dataset with variables: PersonID EventID (there can be multiple events per person) a number of person-level variables that are constant within personID a number of event-level variables that can vary within personID I would like to end up with a person-level file, with one record per personID, including all the person-level variables. I could do this manually by just selecting on first.personID and keeping the person-level variables. But there are a large number of variables, and it is not obvious which are person and which are event level. Is there an easy way to identify which variables are fixed within personID, and keep only these in the output file. (They are a mix of numeric and character).

BruceBrad · ‎05-17-2022

I've confirmed with SAS support that there is a problem with the treatment of autocall libraries. The workaround is to remove the library reference before running the SASEOECD libname statement with options sasautos=sasautos;

Online Status	Offline
Date Last Visited	‎08-22-2025 08:57 AM

Re: Bug in SGPLOT when using max= in yaxis statement

Re: Bug in SGPLOT when using max= in yaxis statement

Re: Bug in SGPLOT when using max= in yaxis statement

Bug in SGPLOT when using max= in yaxis statement

Re: How to directly edit files in EG

Re: How to directly edit files in EG

Re: How to directly edit files in EG

Re: How to directly edit files in EG

How to directly edit files in EG

Test statement in proc panel

Re: How to directly edit files in EG

Re: SGPlot and Curvelabel positioning

Re: Trap when merging, then redefining variable

Re: Macro to strip operators from string

Re: Proc Import: Can I suppress "NOTE: VARCHAR data type is not suppor...

Re: How to directly edit files in EG

Trap when merging, then redefining variable

Re: linear and non linear combinations of previous estimated

Proc Export: Maintain case of variable names when exporting to Stata

Re: Error with SASEOECD engine

Re: Macro to strip operators from string

Macro to strip operators from string

Re: linear and non linear combinations of previous estimated

Re: Suggestions for SGPlot with groups and multiple series

Re: Suggestions for SGPlot with groups and multiple series

Re: Suggestions for SGPlot with groups and multiple series

Suggestions for SGPlot with groups and multiple series

Re: Proc import for XLSX files, controlling variable name with getname...

Proc import for XLSX files, controlling variable name with getnames=no

Re: Proc SQL: Filling in missing rows

Proc SQL: Filling in missing rows

Re: un-merging a dataset

Re: un-merging a dataset

un-merging a dataset

Re: Error with SASEOECD engine