About BruceBrad

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;

BruceBrad · ‎05-17-2022

Thanks for the suggestions. I did miss the trailing slash requirement. However, I've fixed that and still have the same error. As I read the documentation, the libname statement does the downloading, I don't need to do it first. But it is a bit confusing. However, when I run the program with macro debugging I see that it is calling the autocall library search path just before the error. If I run the program without my autoexec.sas which sets up my autocall library, it runs without error. (Haven't checked for sensible output yet). So I think there is something wrong with either my autoexec.sas, or there is a bug in the code where it doesn't handle an autocall library properly (not handling the comma in the augmented search path properly). The relevant code in my autoexec.sas is similar to that below. options sasautos=("%sysget(userprofile)\Data\SASMACRO",sasautos);

BruceBrad · ‎05-16-2022

The ETSMACRO appears to be a macro in the SAS/ETS autocall library which is being called by Proc SASEOECD. It has a few %index statements. I can't work out which one is not working. Looks like a call to support is needed.

BruceBrad · ‎05-16-2022

I'm trying to run the following code (from the SAS system documentation). But I'm getting the error below. The only change I've made from the documentation is to put in the reference to "c:\temp" (which is a valid folder on my system). ERROR: Macro function %INDEX has too many arguments. ERROR: The macro ETSMACRO will stop executing. options validvarname=any; data keylist0; length key0 $8; key0='EA17'; output; /* country is euro area; 17 countries */ run; data keylist1; length key1 $8; key1='B1_GA'; output; /* transaction is GDP; output approach */ run; data keylist2; length key2 $2; key2='C'; output; /* measure is current prices */ run; title 'Request GDP for EA_17 in Current Prices'; LIBNAME myLib saseoecd "c:\temp" setid=SNA_TABLE1_SNA93 inset0=keylist0 inset1=keylist1 inset2=keylist2 out=gstart ;

BruceBrad · ‎04-12-2022

Thanks Chris. I've managed to get it to work. Another question: Are these app passwords linked to a particular computer? The dialog for creating them suggests they might be. I have a SAS program which sends an email using the filename email method. I've now put the app password in the program (using pwencode). Sometimes I run this program on computer A, and sometimes on computer B. Do I need to setup different app passwords for each computer?

Online Status	Offline
Date Last Visited	‎07-29-2024 09:04 AM

Re: Editing text with long record length

Re: Editing text with long record length

Editing text with long record length

Re: Reducing disk usage while concatenating and merging

Re: Reducing disk usage while concatenating and merging

Re: Reducing disk usage while concatenating and merging

Reducing disk usage while concatenating and merging

Re: Macro to strip operators from string

Re: Macro to strip operators from string

Re: Macro to strip operators from string

Re: Macro to strip operators from string

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

Re: "Preparing server" message with EG

Re: Suppressing title when using ODS SELECT NONE

Re: Suppressing title when using ODS SELECT NONE

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: "Preparing server" message with EG

Re: Turning ODS results off

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

Re: Error with SASEOECD engine

Re: Error with SASEOECD engine

Error with SASEOECD engine

Re: Gmail and app passwords