topic Re: Need help with writting out a file to a dataset in SAS Programming

Need help with writting out a file to a dataset

saslovethemost — Fri, 25 Aug 2017 17:24:11 GMT

I am having a weird issue with the space in place of zeros for a varaible when I write out to a mf dataset. I get a variable and its value calling a IMS db in a data step, I am using same variable in another data step and the same varaible when I write out to a mainframe dataset is changing to a space.

Following is the sas code i used..

data have;,,
  infile intxn;
  input
    @001 txns_rec $238.
    @001 srvcr    $6.
    @007 lnno     $9.
...
...
...
   @161 slrname  $30.
...
...
run;

I am getting couple of variables (groupno & lnany) from IMS db like below

***************************************************************;
*  Read XXXXX segment using GU call                          *;
***************************************************************;

 data want;
   set have;
   length SSA1 $60.;

   database="&dbname";
   callfunc='GU  ';
   SSA1='XXXXXX(XXX0010F ='||lnno||')';

   input
    @001 lnno      $9.
    @041 groupno   $7.
    @073 lnany     pd4.6
    ;

   put '--- LNNO#  ---> ' lnno;
   put '--- GROUP# ---> ' groupno;
   put '--- ANY1#  ---> ' lnany;

   if statcode not in ( '  ', 'GE' ) then do;
     put '--- error ---> ' _all_;
     abort return 1111;
   end;
 run;

I am getting the values like below

--- LNNO#  ---> 180878298
--- GROUP# ---> F193076
--- ANY1#  ---> 0.05125

I am writitng these out to a dataset like below

*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>;
*   Write out warning file                                      ;
*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>;

data _null_;
  set want;
  file wartxn;
       put @001 srvcr    $6.
           @007 lnno     $9.
....
....
....
           @161 groupno  $7.
....
....
....
           @339 lnany    S370FZDT10.9
....
....
....       @374 slrname  $30.
           ;
run;

Follwoing is the output file values (in wartxn)

groupno value in a output dataset(wartxn):

----+----7--
************
F193 760310W

The above value @161 pos, between F193 and 76 there is a space. it supposed to be F193076 for 
groupno as I printed that value right after IMS db call.

The lenght of output file(wartxn) that I am writting out to in a jcl is different(403) than the input file(238) because I am adding some variables at the end to the file. The interesting thing is when I write the groupno anywhere beyond 238, I do not see this problem.

I really apprecite your time, thanks in advance.

Neal.

Re: Need help with writting out a file to a dataset

ballardw — Fri, 25 Aug 2017 17:37:34 GMT

And it may help to post text output in a codebox using the {i} instead of the run icon.

Since you are writing to specified columns I would very carefully double check that you do not accidently have something that is writing to the wrong column such as

put
           @161 groupno  $7.
....
           @164 othervar $1.  /*<where maybe 264 was intended*/
....
           @339 lnany    S370FZDT10.9
....
....
....       @374 slrname  $30.

Re: Need help with writting out a file to a dataset

saslovethemost — Fri, 25 Aug 2017 18:38:59 GMT

Right, good to check and i did check, I do not have anything for column @164.

Re: Need help with writting out a file to a dataset

saslovethemost — Mon, 28 Aug 2017 11:57:00 GMT

Do anyone come across this kind of an issue? please let me know, i really appreciat your time.

Thanks,

Neal.

Re: Need help with writting out a file to a dataset

art297 — Mon, 28 Aug 2017 14:23:48 GMT

It would help if you post your entire output statement. That would be the best way for others to spot potential overwrites.

Art, CEO, AnalystFinder.com

Re: Need help with writting out a file to a dataset

ballardw — Mon, 28 Aug 2017 15:41:45 GMT

And an example data set that shows the same behavior. Dummy data is fine to protect any sensitive information as long as the code and the data replicate the problemn.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Re: Need help with writting out a file to a dataset

saslovethemost — Mon, 28 Aug 2017 15:52:25 GMT

My apologies.. I thought zero is converting to spaces..but each character at 165 position is converting to space.I checked every where in my code if any is moving to @165 position. Dont know why..

The actual values are like the following...

Re: Need help with writting out a file to a dataset

saslovethemost — Mon, 28 Aug 2017 16:27:01 GMT

Art, please find the attached SAS output. I really appreciate your help, thanks.

Re: Need help with writting out a file to a dataset

saslovethemost — Mon, 28 Aug 2017 17:25:57 GMT

I got it, instead of $165, it should be $165. what a bummer!

Re: Need help with writting out a file to a dataset

art297 — Mon, 28 Aug 2017 17:49:18 GMT

Yes, that would do it. However, you've got additional problems as none of the following appear to be in the data you are trying to export:

 151                    @349 ppnltyof $1.
 152                    @350 intbrng  pd6.2
 153                    @356 nintbrng pd6.2
 154                    @362 crtmt    pd6.2
 155                    @368 bic      pd6.2
 156                    @374 slrname  $29.

Art, CEO, AnalystFinder.com

Re: Need help with writting out a file to a dataset

saslovethemost — Mon, 28 Aug 2017 20:09:22 GMT

Thank you Art, I took care of this.

Neal.