topic Re: writing observations to an external file in SAS Programming

writing observations to an external file

jfaruqui — Tue, 23 Oct 2018 17:56:03 GMT

guys ...

stuck on a small basic problem ..

need to write to a file but using values from subsequent observations ..

the attached image explains the issue .. please help with code to replace "????????" part ..

thanks

Re: writing observations to an external file

PeterClemmensen — Tue, 23 Oct 2018 17:58:19 GMT

So the window is what you want the txt file to look like, correct?

Can you post the code here so we can provide a code answer?

Re: writing observations to an external file

jfaruqui — Tue, 23 Oct 2018 18:02:12 GMT

sure ...

data _null_;
infile datalines;
input ID Name$ 6-13 Month$ Amount;
file '/folders/myfolders/Donations.txt' print;
PUT
'Hi' name
//'Your donation(s) are as follows:'
// ???????;
put _page_;

cards;
1001 Jenny JAN 300
1001 JUL 550
1001 DEC 275
1002 George AUG 100
1003 Frank FEB 375
1003 NOV 460
;

Re: writing observations to an external file

PeterClemmensen — Tue, 23 Oct 2018 18:04:41 GMT

Is this what your actual data looks like? This is probably not the data you want to work with?

data test;
input ID Name$ Month$ Amount;
cards;
1001 Jenny JAN 300
1001 JUL 550
1001 DEC 275
1002 George AUG 100
1003 Frank FEB 375
1003 NOV 460
;

I'm guessing your data looks more like this?

data test;
input ID Name$ Month$ Amount;
infile datalines dlm=',' dsd;
cards;
1001,Jenny,JAN,300
1001,,JUL,550
1001,,DEC,275
1002,George,AUG,100
1003,Frank,FEB,375
1003,,NOV,460
;

Re: writing observations to an external file

jfaruqui — Tue, 23 Oct 2018 18:07:13 GMT

looks more like this ... copy/paste is screwing up the spacing

i wouldn't mind making a dataset with this data and then using the dataset to generate the txt files either ... so we can use the BY statement (in case first. and last. needs to be used)

----x----1----x----2----x----3
1001 Jenny JAN 300
1001 JUL 550
1001 DEC 275
1002 George AUG 100
1003 Frank FEB 375
1003 NOV 460
;

Re: writing observations to an external file

jfaruqui — Tue, 23 Oct 2018 18:09:15 GMT

that works too bro ... its not the data entry that is tripping me up .. its what to write in the PUT statement that allows me to create reports for the 3 users with their donation months and amounts ..

Re: writing observations to an external file

PeterClemmensen — Tue, 23 Oct 2018 18:14:58 GMT

Something like this?

data test;
input ID Name$ Month$ Amount;
infile datalines dlm=',' dsd;
cards;
1001,Jenny,JAN,300
1001,,JUL,550
1001,,DEC,275
1002,George,AUG,100
1003,Frank,FEB,375
1003,,NOV,460
;

data _null_;
   set test;
   by ID;
   file 'Yourpath\Donations.txt';
   if first.ID then put "Hi " Name
   / "Your donation(s) are as follows"
   / Month Amount dollar10.2;
   if not first.ID then put Month Amount dollar10.2;
run;

Re: writing observations to an external file

Shmuel — Tue, 23 Oct 2018 18:18:01 GMT

Next time post your code within the man-icon window.

Replace the '????...?' with:

month $3.  amount 7.2 /

but you still need to recognize a start of a new name, so your code need be -

Suppose you read your input into sas dataset named 'have':

data _null_;
  set  have;
         file .... /* your code */
         if not missing(name) then 
            put 'Hi ' name // 'Your do.....: '    /* your text */
                / month $3.  amount dollar7.2 ;
        else   put / mont $3.  amount dollar7.2;
run;

Re: writing observations to an external file

jfaruqui — Tue, 23 Oct 2018 18:27:46 GMT

thanks all !!!

I love this site and these boards !!