topic Re: Need a report from a file with description. in SAS Programming

Need a report from a file with description.

Best — Sat, 29 Sep 2018 11:49:34 GMT

i write SAS code in IBM mainframe, i have to make out a report from the input file which is generally in Gov00 version.

this file has multiple contributions (in dollars) of the participant. like contribution type A , contribution type , contribution type c, i have to write a code through which i can pull out the detials of each contribution, like how many contribution is of type A and then their basic details like name , SSN, contribution type.

just give you the layout of the file

Please guide me on this.

infile a

input @001 SSN :09.

@013 Date :YYYYMMDD10

@26 Contribution A :15.

@42 contribtuion B ;15.

@56 contribution c :15

output

SSN	Date	Contribution A	ContribuionB	ContributionC
1.43E+08	9/3/2018	17.6	13.2	16.3
3.57E+08	9/3/2018		13.5	14.6
1.23E+08	9/3/2018	14.5		17.2
4.59E+08	9/3/2018
1.37E+08	9/3/2018	11.1	12.3
7.86E+08	9/3/2018			15.5

any help and guidance would be highly appreciable.

Re: Need a report from a file with description.

Astounding — Sat, 29 Sep 2018 12:58:34 GMT

A few ideas to consider ...

First, don't use tools that you don't understand. I would bet real money that you don't know what a colon means. (In fact, I would bet that you understand very little of the INPUT statement and should take some time to try to understand how to read in a variable.)

Second, SSN should be a character field, not a numeric field. You are never going to add SSNs together or find the mean value of SSN. It represents a category, and thus should be character.

Third, variable names cannot contain spaces (unless you introduce complications to the program that make it clumsy to work with). So Contribution A is illegal, but Contribution_A would be perfectly fine.

Fourth, pay attention to the details. If Contribution_A starts at column 26 and occupies 15 characters, Contribution B should begin at column 41, not column 42.

Here is a rewritten INPUT statement to illustrate:

input @001 SSN $ 09.

@013 Date YYYYMMDD10.

@26 Contribution_A 15.

@41 contribtuion_B 15.

@56 contribution_c 15.

;

format date yymmdd10.;

Re: Need a report from a file with description.

Best — Sat, 29 Sep 2018 14:42:11 GMT

Thanks for correcting me, can you now tell me how I can get the desired results,please?

Re: Need a report from a file with description.

Best — Sat, 29 Sep 2018 14:43:29 GMT

Also please help me understand what colon means

Re: Need a report from a file with description.

VDD — Sat, 29 Sep 2018 16:38:16 GMT

A colon concept

http://www2.sas.com/proceedings/sugi26/p073-26.pdf

I find that if I do a search on things like SAS colon concept googol retrieve links such as the above link. This was the first returned ULR in my list that googol fetched for me.

the same searching concept also assist me when I need to finding out about how to use SAS proc sql or SAS proc transpose. I find that including SAS to start my search retrieves ULRs related to SAS and helps exclude other programing languages in the first set of search results.

Re: Need a report from a file with description.

Best — Sat, 29 Sep 2018 17:33:57 GMT

Can someone help me with the code so that I get the required report?

Re: Need a report from a file with description.

Astounding — Sat, 29 Sep 2018 22:51:09 GMT

What is the required report? Do you really want to report SSNs in scientific notation?

Do you know how to run a basic PROC PRINT?

Since you want to shift the decimal point in the numbers, here's a small change to the earlier suggestion:

input @001 SSN $ 09.

@013 Date YYYYMMDD10.

@26 Contribution_A 15.1

@41 contribtuion_B 15.1

@56 contribution_c 15.1

;

format date yymmdd10.;

But how are you expecting to accomplish your objective, when you don't know how to read in data and you don't know how to produce any type of a report and you don't even tell us what the report is supposed to look like?

Re: Need a report from a file with description.

VDD — Sun, 30 Sep 2018 00:36:41 GMT

RE 15386516, Urgent: Can I make a suggestion if those are real SSN's in your sample you better remove those numbers due to HIPAA rules.

First of all you don't share SSN's even in examples. You must protect confidential information.

https://www.hhs.gov/hipaa/for-professionals/privacy/laws-regulations/index.html

HHS and your employer may be in jeopardy if you are sharing those data information. HHS fronds on such action.

Second if you on a IBM mainframe working with GOV files you should have already know the above rules.

Third if you don't know those rules you should have already signed a none disclosure agreement with your employer before you could have started working with GOV files.

Fourth of all, help those coming behind you by know what you were hired for, if your statements are true.

Know your data. Know your obligation related to those data. Know how to mask and provide others knowledge that those SSN's are not true and have been masked or replaced to represent your needs and are not true SSN's.

Sharing of data, rules, forms, GOV.

Re: Need a report from a file with description.

Best — Sun, 30 Sep 2018 02:33:43 GMT

First of all from Gov I mean GDG version and this is the dummy data

Re: Need a report from a file with description.

Best — Sun, 30 Sep 2018 03:28:49 GMT

No I don’t want the report in scientific notation , it is just ssn while copying from excel may be it looks like in not the right format.

What I want a report which has all the details of the ssn along with contributions and date

Re: Need a report from a file with description.

Kurt_Bremser — Sun, 30 Sep 2018 10:10:21 GMT

@Best wrote:
No I don’t want the report in scientific notation , it is just ssn while copying from excel

That's where your problem starts. The Excel file format is utter crap for data interchange.

It forces SAS to make guesses about the data structure, depending on the contained data. Since it's quite hard to tell Excel that a 9-digit string is a string and not a number, you end up with faulty attributes in your dataset.

I'm actually surprised that someone working on a mainframe uses such files at all.

Have the data sent to you in a usable format (csv or fixed-width colums), and read that with a data step.

Also see Maxims 22, 27, 31.

Re: Need a report from a file with description.

Best — Sun, 30 Sep 2018 12:54:16 GMT

I have attached the input file which has got fixed attributes, it has been attached in the txt format, please see the attachment and how the output should look like I have also mentioned that, please suggest the code.

Re: Need a report from a file with description.

Best — Sun, 30 Sep 2018 12:55:41 GMT

We received the data in fixed formats

Re: Need a report from a file with description.

Kurt_Bremser — Mon, 01 Oct 2018 07:51:10 GMT

Taking the text from your posted file, I ran this code:

data want;
input
  @01 ssn $9.
  @13 date yymmdd8.
  @26 contribution_a 15.
  @41 contribution_b 15.
  @56 contribution_c 15.
;
format
  date yymmddd10.
  contribution_a
  contribution_b
  contribution_c
    15.
;
datalines;
1425637560002018091200000000000000000176000000000000132000000000000163000000000000000000000000000000000000000000000000000
3568921370002018091200000000000000000000000000000000135000000000000146000000000000000000000000000000000000000000000000000
1234578900002018091200000000000000000145000000000000000000000000000172000000000000000000000000000000000000000000000000000
4587961230002018091200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
1369785230002018091200000011100000000111000000000000123000000000000000000000000000000000000000000000000000000000000000000
7856391230002018091200000000000000000000000000000000000000000000000155000000000000000000000000000000000000000000000000000
;
run;

character informat for ssn
yymmdd8. informat for date (length 10 will cause data errors)
proper position for contribution_b
proper SAS names (no blanks)
display formats for the date and contribution_ variables

Re: Need a report from a file with description.

Best — Wed, 03 Oct 2018 10:59:07 GMT

Can anyone help me on this?

Re: Need a report from a file with description.

Kurt_Bremser — Wed, 03 Oct 2018 11:06:00 GMT

@Best wrote:
Can anyone help me on this?

You already received working code from me. Did you try it?

Re: Need a report from a file with description.

Best — Thu, 04 Oct 2018 05:10:22 GMT

Anyone has the solution of this problem

Re: Need a report from a file with description.

Kurt_Bremser — Thu, 04 Oct 2018 05:38:30 GMT

Since you refuse to give use answers to our questions, how should we help you?

@Best wrote:
Anyone has the solution of this problem

Re: Need a report from a file with description.

Best — Thu, 04 Oct 2018 06:31:03 GMT

Please let me know the code so that we can get the desired output

Re: Need a report from a file with description.

Kurt_Bremser — Thu, 04 Oct 2018 06:36:31 GMT

@Best wrote:
Please let me know the code so that we can get the desired output

Read my post from Monday.