DATA Step, Macro, Functions and more

importing RPT files in to SAS

Reply
Frequent Contributor
Posts: 80

importing RPT files in to SAS

Hi, How o import RPT files (single or multiple) in to SAS..? I am doing this for the first time kindly advise. 

Super User
Posts: 10,592

Re: importing RPT files in to SAS

Hm, rpt lets me think of RePorT.

Could you post a sample?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Frequent Contributor
Posts: 80

Re: importing RPT files in to SAS

Posted in reply to KurtBremser

Hi KurtBremser,

 

am afraid, the file has data, when I tried to open it and remove the confidential info, only I can see are garbage symbols.. I dont understand at all. Smiley Happy

 

Many Thanks..

Super User
Posts: 10,592

Re: importing RPT files in to SAS

I guess it's time you start educating people what a TEXT is.

(had to censor myself, because in place of "people" was a string of words you're not supposed to use in the presence of decent ladies and gentlemen)

 

If it ain't readable with the Windows editor, it's not a text.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Frequent Contributor
Posts: 80

Re: importing RPT files in to SAS

Posted in reply to KurtBremser

@KurtBremser I was thinking that the symbols are due to the extension, thought may be we just cannot open the file using windows default (word or pdf or blah blah..). If you have done this before like (improting the RPT in sas) kindly guide me, 

 

You were there in my previous post, regarding excel file formats.. Based on the suggestions, I requested for inputs in other formats like text or CSV, instead I got RPT files..hahha, days could not more frustrated than this.. Smiley Happy

 

Any suggestions are welcome!

 

Thank you

Super User
Posts: 13,942

Re: importing RPT files in to SAS

RPT is not a "standard" file type. I suggest going to the source and asking which program generated it and ask for the data in a plain text format such as CSV as I agree with @KurtBremser that the file sounds like it may not be a simple text file.

Super User
Posts: 24,025

Re: importing RPT files in to SAS

RPT files are from Crystal Reports and are not an open file format. 

Ask a Question
Discussion stats
  • 6 replies
  • 230 views
  • 2 likes
  • 4 in conversation