I dont believe you can use a column directly for input. But you could make a macro that would take and input and run a ttest for each value in the input.
... View more
That would be more simple.
data have;
input id1 id2 date : date9. value;
format date date9.;
cards;
7899 11774 31MAR2010 10
7899 11774 30APR2010 20
7899 11774 30JUN2010 40
7899 11774 31AUG2010 60
8110 45987 31DEC2010 100
;
%let n=10;
proc summary data=have ;
by id1 id2;
var date;
output out=temp min=;
run;
data temp1;
set temp;
output;
do i=1 to %eval(&n-1);
date=intnx('month',date,1,'e');output;
end;
drop i _: ;
run;
data want;
merge temp1(in=ina) have;
by id1 id2 date;
retain new_value;
if first.id2 then call missing(new_value);
if not missing(value) then new_value=value;
if ina;
run;
... View more
There is a paper that you might find useful : Automate in a Dash with SAS: Time saving techniques for building quality improvement dashboards. Starts by capturing all file names from a folder and getting the latest named file. Hope it helps
... View more
SAS provides NLS-capable format equivalents for the standard formats:
%let date=31MAR2019;
options locale=sv_SE;
data _null_;
date_var="&date."d;
format date_var date9.;
month_name=put(date_var, nldatemn10.);
call symputx('month_name',month_name);
run;
%put &month_name;
Log excerpt:
35 %put &month_name;
mars
Documentation (Maxim 1!) is found at
documentation.sas.com
SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation
National Language Support (NLS)
Formats for NLS
... View more
@rhapsody wrote:
I wanna open the Excel file "January_Alex..xlsx". I'm using the following code
%let name=Alex;
x '"C:\Folder\January_&name..xlsx" ';
But the problem is that SAS doesn't understand that "&name" is a macrovariable. I get the error message "Windows cannot find 'C:\Folder\January_&name..xlsx'. Make sure you typed the name correctly, and then try again"
Any ideas how to fix it?
SAS will not resolve macro references inside of single quotes. Use double quotes. If you want to include double quotes in the string passed to DOS/Windows then double the embedded quotes;
"""C:\Folder\January_&name..xlsx"""
Or let the QUOTE() function do it for you.
%let cmd="C:\Folder\January_&name..xlsx";
x %sysfunc(quote(&cmd));
... View more
proc sql;
create table want as
select a.*,size,Code1,Code2,Code3, Code4
from product(where=(type='Medium')) a inner join (select *,"Medium" as Type from medium)b
on a.type=b.type
order by a.id,b.size;
quit;
... View more
Well, I would advise that that is not the best layout, going the other way would be more beneficial, i.e. having 81 records and 2 columns. Far easier to work with. Anyways something like - and note that this is not tested as you have not provided test data in the form of a datastep.
data want (drop=i);
set have end=last;
array final{81} 8;
retain final:;
array theta{9};
if _n_=1 then mult=0;
do i=1 to 9;
final{(mult*9)+i}=theta{i};
end;
if last then output;
run;
... View more
