I want to position some curvelabels at the end of my time-series lines. I'm trying different combinations of CURVELABELLOC and CURVELABELPOS.
For some reason, it keeps on putting the label for the top series on top of the figure. The first figure is with
OUTSIDE and MAX (same results with AUTO). The second is with INSIDE and MAX. (If I drop the top series, I some of the labels on the top and rotated!).
How can I force it to put all labels down the RHS of the figure?
... View more
Found the problem (I think). Nothing to do with proc import. Later in the program I run this macro which I use to rename the first variable in the file. I guess I need to put a close statement in there somewhere?
%macro FirstVName(data);
%* returns the name of the first variable in a file;
%let dsid = %sysfunc(open(&data,i));
%sysfunc(varname(&dsid,1))
%mend FirstVName;
... View more
I have a program that imports a large number of spreadsheets into data sets. It runs fine the first time. The second time I run it, I get errors because the output data set is being used. Proc datasets also cannot delete the data sets. The code is like the following (inside a macro loop that generates different &seriesid values.
I'm using EG 8.5 (8.5.0.203) (32-bit).
filename _TSss temp; proc http method="get" url="&tableURL" out=_TSss; run; proc import datafile=_TSss out=_TSss_&seriesid dbms=xlsx replace;
range=&seriesid._data;
getnames=no;
run;
... View more
I've been using SAS for many years, but never came across this trap before. Surely it deserves a warning message in the log!
I can see now how the problem arises when I think through how SAS does merges (by retaining variables on the 1 side of a 1:n merge). The solution is to never redefine variables in your data step when merging (if the variable comes from the 1: side of the merge) - even if it might be convenient for doing things like converting cents to $.
data file1;
input id var;
cards;
1 10
2 20
;
data file2;
input id;
cards;
1
1
2
2
2
;
data out1;
merge file1 file2;
by id;
var = var/100; /* this gets calculated as if var were retained for each by value */
run;
proc print;
... View more
I've attached the first few records of the file (Excel can open it). The lrecl option doesn't work because I'm editing the _infile_ variable which has a fixed upper length of 32K.
... View more
I have a CSV file where the first record is very long because of long variable names (about 60k). I want to read the file in, edit the first line (eg replace all occurences of "longword" with "lw"), save the file, then read it in as per a normal CSV file. Because the record length is over 32k, I can't use the _infile_ method. Any suggestions for the best way to do this in SAS? (I'm using 9.4 on windows).
I guess I could use some Windows batch/power script, but would prefer the portability of keeping it in SAS.
... View more
Here is a test program using the single datastep. The output seems correct, but I get lots of information messages about data being overwritten. What's going on here?
%macro hfile(filen);
data h&filen;
retain file &filen;
do id = 1 to 5;
v1 = 1000*file + id;
output;
end;
run;
%mend;
%macro pfile(filen);
data p&filen;
retain file &filen;
do id = 1 to 5;
do person = 1 to 2;
v2 = 100000*file + 100*id + person;
output;
end;
end;
run;
%mend;
%hfile(1);
%pfile(1);
%hfile(2);
%pfile(2);
data merged;
merge h1 h2 p1 p2;
by file id;
run;
... View more
I think this might work. (I've already tried compress, length and program reorganisation).
The IDvars are not all unique, but I think I can see how it would work. The IDvars are the file numbers (file=1 for P1 and H1, =2 for P2 and H2 etc) and case numbers within each file (once each for the H (household) file, and multiple times for the P (person) file). The desired output is one record for each P record, with the H vars attached.
... View more
I have a job which concatenates many large files into two files then merges them. I'm running out of disk space. Can I concatenate and merge in the same data step to remove some of the work files? Would proc sql help, or will it also create large working files. The pseudo code below describes the current structure.
data P;
set P1 P2 ... Pn;
run;
data H;
set H1 H2 ...Hn;
run;
data M;
merge P H;
by IDvars;
run;
[output based on M]
... View more
I think my confusion stems from how %sysfunc works. I was assuming that translate() was interpreted as a normal function, and following its documentation, would require quoted inputs. Is the %sysfunc(translate()) syntax best interpreted as turning translate() into a macro function, with macro-type inputs?
... View more
Thanks. This does what I need. I'm still puzzled by how strings get passed to translate(). Why don't I need to put quote marks around &string, but do need to use %str( ) for the space?
... View more
Yes, I can see that a fully general function would be challenging. My purpose here is that I'm writing simple expressions to do some data checks (generally just adding up checks), and then would like to put all the component variables to the log if the check fails. (I already have code that generates the put statement from a list of variable names separated by spaces). So, can someone help with the quoting needed to get my original example to work?
... View more
Thanks. But I see my example didn't cover all my use needs. In particular, I don't always have spaces between my operators (eg vara+varb). I would like the output to have spaces between the variable names.
... View more
