Hi, I'm stuck with a similar error. I'm trying to import data from a .XSLX. and while I execute the PROC IMPORT I get this error: "ERROR: Server Name is invalid or missing." This file is placed in a shared folder with a path like this: \\file_server_name\folder\subfolder, I'm using SAS Enterprise Guide 7.1 and I guess we are using a UNIX server for the metadata because in the LOG of the import task the INFILE has this path: '/sasendwork/work/SAS_work722C01660016_sas_server_name/#LN00014' I need to import files using code because I have to upload a daily report placed in this shared folder that has a date in the name, something like 'File mm-dd-yyy.xlsx' I tried a lot of things but I guess most of all solutions are intended for SAS 9.1 or later versions. Any help will be very appreciate since we expent a lot of time updating the import task everyday. Regards, -Daniel
... View more
I am always very leery of any inserted summary rows inside a data set. What happens if you run the same summary program later on the same data? Or you run a report procedure like Proc Report that generates summary totals. You have now included the summary into a new summary.
At a very minimum I would add an indicator variable to show that the row is indeed some sort of summary and the other rows aren't with appropriate label for the indicator.
... View more
You would be better off modifying the macros. Add %PUT statements that write messages about what the macro is going: beginning execution, creating a data set, ending execution. That's more reliable, and relatively easy to do.
Otherwise, you face many additional complications such as macros that create a data set each time through a loop, macros that call other macros, and extend that idea: macros that call macros that call macros.
... View more
Hi,
Please don't reopen old posts which have been closed. You have a post here:
https://communities.sas.com/t5/General-SAS-Programming/Date-format-with-the-specific-format-30Apr2016-00-00-00/m-p/285453
About this.
... View more
Hi,
It would be a good idea to start a new topic, posting test data (in the form of a datastep) and what the output should look like. Your logic isn't particularly clear to me, however it should just be a matter of putting an if <> statement around the sp{*} array.
... View more
Your life would be much easier if you normalised your data, i.e. have something like:
S_D RESULT
1 abc
2 def
...
Further processing of the data would be easier, and this task would be a simple merge and one calculation step. With your transposed dataset, you will need to use arrays, and the code thus becomes a bit more complicated - not to mention further coding will be harder. As you have not provided test data (in the form of a datastep) this code is untested:
data want;
merge base other; /* Assumes both are sorted by the id variables */
by <id variables>; /* update this row with the matching variables in each dataset */
array s_d_{4};
array s_f_{4};
array s_d_results{4};
array s_f_results{4};
do i=1 to 4;
s_d_results{i}=(s_d_{i} / n_d) * 100;
s_f_results{i}=(s_f_{i} / n_f) * 100;
end;
run;
Again though, far easier to normalise your data.
... View more
Can you post actual SAs code that replicates the error message? It is unclear if you are talking about the FOOTNOTE statement or the creation of a macro variable named FOOTNOTE or expanding the reference to a macro varaible named FOOTNOTE.
... View more
Hi @vraj1,
I see. You "want to create a new variable" in an existing dataset "for which [you] have var1 as 1 to 20."
Whether you really need a new variable (with redundant information!) depends on what you plan to do with it. Maybe it's sufficient to create a format:
proc format;
value grp
1-10 = 'first'
11-20 = 'last';
run;
You can do many things with your existing VAR1 together with this format. For example, perform a frequency count:
proc freq data=have;
format var1 grp.;
tables var1;
run;
If you really need the new variable, you can still create it using the format:
data want;
set have;
var2=put(var1, grp.);
run;
... View more
Hello, if the last letter in your var variable determines the group then you can get it like this: data have; infile datalines; input var2 $50.; datalines; DRA-04U-A DRA-099Y-B DRd-989-E ; data want; set have; group=scan(var2,-1,"-"); run;
... View more
It is a good idea to post your test data in the form of a datastep:
data have;
var1="kjd-fhf-asd"; output;
var1="dfsf-dfg-dwe"; output;
run;
data want;
set have;
want=catx(' ',substr(scan(var1,2,"-"),1,2),substr(scan(var1,2,"-"),3,1));
run;
... View more
That's fine. How many boxplots have you got? If you use the below method as an example, you could use the bandplot to try to cover up the points. proc sgplot data=sashelp.heart; vbox cholesterol / category=deathcause; run; data heart; set sashelp.heart; lower = 380; upper = 600; run; proc sgplot data=heart; vbox cholesterol / category=deathcause; band x = deathcause upper = upper lower = lower / fillattrs = (color = white); run;
... View more
