I think that your solution is quite neat, although the NWKDOM function may give an alternative. And to use functions with macro programming, you have to use the %sysfunc macro function. Regards, Linus ... View more

In order to use first. syntax, you must use a BY statement in your data step: BY code; The =1 is unnecessary, it is implied TRUE. And I don't believe you can use FIRST. together with WHERE (since WHERE does not aware of what is going on in the data step, IF is). /Linus ... View more

If you can describe more in detail what end result you want, maybe we could give suggestions for other approaches that haven't thought of. Some sample input and input data could help. /Linus ... View more

This implies that either hasn't the software been properly installed, or you don't have the required license, SAS/STAT i believe. I suggest that you contact your SAS software administrator at your site, or SAS Technical support. /Linus ... View more

If you mean a html form, you can view this thread: http://support.sas.com/forums/thread.jspa?messageID=14996㪔 To do this, a license that gives you access to a SAS Stored stord process server is required, or SAS/IntrNet software. And of course there is plenty of documentation and samples on SAS support site. /Linus ... View more

title %sysfunc(putn(&Monitor_Date,WEEKDATE29.)); /Linus ... View more

Well, you already know the names of the variables, so just output them as character strings: %let dataout=myfile.csv; %let varNames=Age,Sex,Height; data _null_; call symput('varNames2',translate("&VARNAMES"," ",",")); run; data _NULL_; set sashelp.class; file "~/&dataout" DLM=',' LRECL=2000 ; if _n_ = 1 then put "&VARNAMES"; put &VARNAMES2; run; /Linus ... View more

I think you're missing the point here. Since SAS logic says that everything except the value of 0 resolves to TRUE, your OR 3 will always be TRUE, and therefore it will never go to your last ELSE statment, that will assign according to higher values than 2. So again, if you want your program to work, simply change your if statment to group in(2,3). /Linus ... View more

I did a small test on SASHELP.class, and it works for me: proc copy in=sashelp out=work; select class; run; proc sort data=class; by age; format age z11.; run; proc print; run; Obs Name Sex Age Height Weight 1 Joyce F 00000000011 51.3 50.5 2 Thomas M 00000000011 57.5 85.0 3 James M 00000000012 57.3 83.0 4 Jane F 00000000012 59.8 84.5 ... Please attach full log and partial output from your example. /Linus ... View more

I think this is a quite clear issue for SAS tech support to answer. /Linus ... View more

This can be done in a number of ways. One is to read your data into three variables, then checking if your second variable contains any digits (using ANYDIGIT function), if so move the contents to the third variable. /Linus ... View more

If you want to use SQL, here's on solution: 26 proc sql; 27 select id, name, str1, str2, salary, date 28 from salary 29 group by id 30 having date = max(date); NOTE: The query requires remerging summary statistics back with the original data. 31 quit; As you see, this creates one summary query that is merged with original query, so this might be the best method if your data is huge. Other methods could involve two subsequent PROC SORT, the second one using NODUPKEY on your id column. /Linus ... View more

The easiest is to use SQL with a sub-query or an inner join: Proc SQL; create table schaudit as select * from sch where schcode in (select schcodes from sch_lookUpTable) ; create table schaudit as select sch.* from sch inner join sch_lookUpTable on sch.schcode eq sch_lookUpTable.schcode ; quit; /Linus ... View more

I ran your code in DMS SAS mode, and didn't get the NOTE, even if my search path does not match. If you attach the full log maybe there is a clue... One more straightforward solution is to use the DCREATE function. /Linus ... View more

Yes, you can merge as many tables as you like in the same data step, as long as you merge on a common BY variable (unlike SQL, where you can join tables on different columns). /Linus ... View more