topic Re: Creating files based on Filename in SAS Procedures

Creating files based on Filename

renjithr — Sat, 21 Jul 2012 01:31:39 GMT

Hi,

I have a requirement based on store branches I have to create .csv files on to a drive.

I used Filename FTP to create .csv files on the drive,but the problem is certain branches does have empty files,in that case i do not want to create output files on the drive for that branch.

How can I achieve this?Please share your thoughts.

Re: Creating files based on Filename

Patrick — Sat, 21 Jul 2012 03:24:14 GMT

You could test if there is data before you execute the filename FTP. May be you should post your code so we can suggest some changes to it.

Re: Creating files based on Filename

Ksharp — Mon, 23 Jul 2012 02:45:01 GMT

Yes. I can firstly check whether there are some obs in a dataset by using DICTIONARY.TABLES.

Ksharp

Re: Creating files based on Filename

renjithr — Mon, 23 Jul 2012 15:41:49 GMT

Below is the code I am using:

%MACRO MCASPLT(MCA1,FNME1,F1);

DATA _NULL_;

SET DATAOT1.NBARI;

%LET TEXT_FLG=N;

IF MCA = "&MCA1" THEN DO;

%LET TEXT_FLG=Y;

%PUT &TEXT_FLG;

FILE &FNME1 DSD DLM=',';

PUT MCA MRN1 ADMDT DISDT

;

END;

%IF &TEXT_FLG = Y %THEN %DO;

%LET OUT_LRECL=8000;

%LET CD=ISM\LG\NCAL\TEST;

%LET HLQO=HPS2.Y3012.XAAA.&F1..TXTOUT;

%LET OUT_NAME=XAAA.&F1;

FILENAME NCHS01 "&HLQO" DISP=SHR;

FILENAME NCHS FTP

"&OUT_NAME"

&HOST_PORT_USER_PASS

CD = "&CD"

LRECL = &OUT_LRECL

;

RUN;

DATA _NULL_;

INFILE NCHS01 SHAREBUFFERS;

FILE NCHS;

INPUT;

PUT _INFILE_;

RUN;

% END;

RUN;

%MEND;

%MCASPLT(ANTCH,DATAO02,ANTI);

%MCASPLT(FOLM,DATAO03,FOLS);

ENDSAS;

In the MCA value FOLM is not in my input file,but the ftp statement is creating an empty file in my ftp location.I dont want FTP an empty file.Please help.

Re: Creating files based on Filename

Astounding — Mon, 23 Jul 2012 18:00:06 GMT

I don't know if this will solve everything, but it might.

The most obvious flaw in your program is trying to use a DATA step IF/THEN to control whether or not %LET executes. %LET always executes. If you examine your log, you will see that %PUT &TEXT_FLG; always writes Y. To change that, change the second %LET statement to read:

CALL SYMPUT('TEXT_FLG', 'Y');

Move the final RUN statement earlier, just before testing for %IF &TEXT_FLG=Y. That forces the DATA step to run before you check the value of &TEXT_FLG. FILENAME statements are not part of a DATA step, anyway.

Also, move the %PUT statement to the very end of the macro. If you leave it in its current location, it will write the value of &TEXT_FLG BEFORE the DATA step executes.

Good luck.

Re: Creating files based on Filename

Tom — Mon, 23 Jul 2012 18:03:23 GMT

First reverse the order of your INPUT and your FILE statements in the DATA step and see if it helps. Perhaps if SAS stops on an empty input file before getting to the FILE statement it might not send anything to FTP.

Can you get the FTP to work using FTP engine in the FILE statement in the DATA _NULL_ instead using the FILENAME statement.

That might make it more likely to skip writing the file.

Do you really want the SHAREBUFFERS options on your INFILE statement as you are writing to a different output file? Not sure this makes any difference for this problem.

Re: Creating files based on Filename

Ksharp — Tue, 24 Jul 2012 02:29:14 GMT

It looks like you are querying some obs rely on a condition . Here is an example . You need to vary it to suit your taste.

%MACRO MCASPLT(sex,FNME1,F1);
proc sql;
create table temp as
 select * from sashelp.class 
  where sex="&sex" ;
quit;


%if &sqlobs ne 0 %then %do;
 proc print ;run;%end;

%MEND;

%mcasplt(F,FNME1,F1)

Ksharp