FILENAME mkdir pipe "mkdir d:\newfolder"; data _null_; input mkdir; put _infile_; run; LOG: 56719 FILENAME mkdir pipe "mkdir d:\newfolder"; ERROR: Insufficient authorization to access PIPE. ERROR: Error in the FILENAME statement. 56720 data _null_; 56721 input mkdir; 56722 put _infile_; 56723 run; ERROR: No DATALINES or INFILE statement. ERROR: The _INFILE_ variable has been referenced, but no DATALINES or INFILE statement was found. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Message was edited by: Filipvdr ... View more

%let Other_base300 = ; proc sql noprint; select Distinct ent_name into: Other_base300 separated by ' ' from base_table_shift where upcase(facility)=upcase("&facility") and upcase(ToolArea) not in ('WMCE','OVEN','LITHO','ISE'); quit; %put Other Tools: &Other_base300; proc report data = spc_final nowd split='#'; columns Month User UserArea ExPmProcedures ('- ISE -' &ISE_base300) ('- LITHO -' &Litho_base300) ( '- OVEN -' &Oven_base300) %IF "&Wmce_base300" NE "" %THEN ('- WMCE -' &Wmce_base300); %IF "&Other_base300" NE "" %THEN ('- OTHER-' &Other_base300); ; label &label_base; define month /order=data group 'M#o#n#t#h' ; define User/ order=data Group 'U#s#e#r' ; define UserArea / /*format=$User2UArea.*/ Order=data 'U#s#e#r#-#A#r#e#a'; define ExPmProcedures/ analysis sum 'E#x#-#P#m#P#r#o#c'; break after Month / summarize ul; where upcase(facility)=upcase("&facility"); run; NOTE: Line generated by the macro variable "OTHER_BASE300". 28390 300MM_DICER MAGNUM RAIDER_2 RECUP SCRUBBER --- 22 -------- 202 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 202-322: The option or parameter is not recognized and will be ignored. It has to domething with the tool starting with a number 300MDICER. Any help? ... View more

data _null_; rc = stpsrv_header('Content-type','image/jpeg'); rc = stpsrv_header('Content-disposition','attachment; filename=temp.jpeg'); run; %global pictureNr; *%let pictureNr = 3596; libname VARS '/imec/other/osp/vars'; %let Link; data varspics; set Vars.W_status_vars; where pictureNr = &pictureNr; call symput("Link",PictureLink); run; %stpbegin; %put &Link; %stpend; when i run it in my browser it says open or save temp.jpeg, but when i open or save it i don't see my image? ... View more

%Macro EDC(Type,id); data out_table; set RF300L3.edc_thick; where col_ins_id = &id; run; %mend; %macro Html; ods listing close; ods html file="/imec/other/imecweb/osp/sp/files/HTML.html" data _null_; set all_append_and_edc_and_vars; if type = 'THICK' then call execute('%EDC(THICK,col_ins_id)'); proc print data=out_table;run; run; ods html close; %mend; %Html; the problem is the id i have to pass Message was edited by: Filipvdr Message was edited by: Filipvdr ... View more

Is it possible? Do you have an example? ... View more

data _null_; format LastDayOfMonth date.; LastDayOfMonth = intnx('month',today(),1)-1; call symput ('LastDayOfMonth',LastDayOfMonth); run; %put &lastdayofmonth; (THIS IS A NUMBER) %macro updateL3; %if today() eq &lastdayofmonth %then %do; ... %end; %mend; %updateL3; ERROR: Required operator not found in expression: today() eq %eval(&lastdayofmonth) ERROR: The macro UPDATEL3 will stop executing. ... View more

Hello, I have a date like this: 20110503 09:58:47.65 (String format $48). How do I make this a Sas DateTime? ( the .65 can be dropped at the end ) Thanks! Message was edited by: Filipvdr ... View more