Hello,   I have a .tsv file with variables exceeding 32767 characters. I have managed to read these using input statement and varchar(131071) data type and lrecl=262143, but when I try to split the long variables into several pieces using scan, processing ends at character 32767. Is this supposed to be working?     ... View more

Hello,   I have to create a figure equivalent to this one: proc summary data=sashelp.cars noprint nway; var MSRP; class Origin DriveTrain; output out=cars_summary lclm= uclm= mean= /autoname; run; data cars_for_plot; set sashelp.cars cars_summary; run; proc sgpanel data=cars_for_plot; panelby DriveTrain / layout=columnlattice noborder noheader columns=3 skipemptycells sort=ascformat; rowaxis type=log label="MSRP"; colaxis label=" " fitpolicy=rotatealways valuesrotate=vertical discreteorder=formatted; keylegend "ssss" / position=right noborder; vbarparm category=Origin response=MSRP_Mean / group=DriveTrain groupdisplay=cluster grouporder=ascending baseline=10 datalabel datalabelfitpolicy=none name="ssss"; highlow x=Origin high=MSRP_UCLM low=MSRP_LCLM / group=DriveTrain highcap=serif lowcap=serif; scatter x=Origin y=MSRP / group=DriveTrain jitter markerattrs=(symbol=circlefilled size=5) transparency=0.50 clusterwidth=0.7; refline 1e5 / lineattrs=(pattern=shortdash) label="LLOD"; run; I have received a request to improve two visual aspects: move the refline label outside of the plot so that it is only printed once per row: is this possible with sgpanel? move the vbar labels up so that these do not overlap with error bars and the scatter plot: is this possible? Thank you for your input in advance. ... View more

Hello,   I am trying to create a bargraph in which a scatter plot is overlaid with a bar graph. The bar graph is supposed to represent the geometric mean, and the error bars the lower and upper confidence limits of the mean. I used scatter and vbarparm statemens to achieve that, together with a dataset with precomputed values stacked under the raw dataset. Unfortunately, the vbarparm does not seem to like having datalabel together with limitlower and limitupper, I am getting the following error (not sure where German is coming from, other messages are in English):   NOTE: Die Option DATALABEL= wird im Fehlerbalken nicht unterstützt. Das Etikett wird nicht erstellt. This is odd as the documentation indirectly implies that the options are compatible: If you also specify LIMITLOWER or LIMITUPPER, then the limit labels are also shown. Prior to SAS 9.4M5, limit labels are shown when you use DATALABEL or DATALABEL=variable with the limit options. Starting with SAS 9.4M5, limit labels are shown only when you use DATALABEL (without a variable). Here is the example code: proc summary data=sashelp.cars noprint nway; var msrp; class Origin Make; output out=cars_summary mean= uclm= lclm= /autoname; run; data for_plot; set sashelp.cars cars_summary; run; proc sgpanel data=for_plot; panelby Origin /layout=columnlattice; vbarparm category=Make response=MSRP_Mean / datalabel limitlower=MSRP_LCLM limitupper=MSRP_UCLM; scatter x=Make y=MSRP/ jitter; run; Is this supposed to work? If not, how can I overlay the geometric mean values on top of the panel? ... View more

Hello,   I am trying to write a program which will loop over an observation for a varying number of times, depending on the contents of this observation. So something like: data variable_length_loop; set sashelp.cars; if Origin EQ "Asia" then do i = 1, 2; else if Origin EQ "Europe" then do i = 3; Origin_short = substr(Origin, 1, i); output; end; run; I can obviously get it to work by repeating the code block between do and end: data variable_length_loop; set sashelp.cars; if Origin EQ "Asia" then do i = 1, 2; Origin_short = substr(Origin, 1, i); output; end; else if Origin EQ "Europe" then do i = 3; Origin_short = substr(Origin, 1, i); output; end; run; The problem is that this leads to a lot of copypasting with increased complexity of the code and the number of the conditions to cover. Is this possible without resorting to macros? Thank you for your feedback in advance.   ... View more

Hello,   is there a smart way of importing delimited files which have records in columns and variables in rows? Something like: parameter subject1 subject2 subject3 numvar1 1232 24342 3.51 charvar1 afdf bsd cdfsgff numvar2 412123 5324 6.1 Importing columns as variables is possible but as some rows are numeric and some are character, I would need to run a bunch of input statements after import to get the numeric data back to numeric. Thank you for the feedback in advance. ... View more

Hello,   I am having issues getting the filename function and infile statement to work nicely within one data step. The following code results in an error: ERROR: No logical assign for filename PWFILE. rc = filename("pwfile", catx("\", pathname("path"), "Password.txt")); infile pwfile; input password; rc = filename("pwfile"); It is as if there is a timing issue with the fileref not being defined when infile wants to use it. I was able to work it around as follows: password_file = catx("\", pathname("path"), "Password.txt"); infile dummy filevar=password_file; input password; It feels strange to use filevar to read only one file though. Is this behaviour expected? I cannot use filename statement beforehand because the code looks through the folder tree and only defines the fileref when it finds the latest folder. Thank you. ... View more