topic Re: Informats in SAS Programming

Informats

GAUTAMDVN — Sun, 17 Jun 2018 16:20:24 GMT

In the raw Crime stats data file, change the delimiter from comma to space and then import the file into SAS (be careful about embedded space in the city name!)

Re: Informats

Kurt_Bremser — Sun, 17 Jun 2018 16:36:12 GMT

Please show your code and the log from it, if you get errors.

Re: Informats

Reeza — Sun, 17 Jun 2018 18:04:45 GMT

What’s your question? That reads like a homework or test question - so show your work so far.

@GAUTAMDVN wrote:

In the raw Crime stats data file, change the delimiter from comma to space and then import the file into SAS (be careful about embedded space in the city name!)

Re: Informats

GAUTAMDVN — Sun, 17 Jun 2018 18:23:56 GMT

Below is the code of mine:

DATA _NULL_ ;
INFILE CRIME DSD;
INPUT	City : $18.
		Population
		Crime_index 
		Total_crime_index  
		MANM 
		Forcible_rape
		Robbery
		Aggravated_assault
		Burglary
		Larceny_theft
		Motor_vehicle_theft
		Arson ;
FILE  'LEARN.CRIME_STATS.TXT' ;
RUN ;

and below is the error I'm getting

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT.

Re: Informats

Reeza — Sun, 17 Jun 2018 18:58:28 GMT

Your infile statement is incorrect.

It should be of the form:

infile 'path to file including extension' dlm=' ' truncover;

Your file reference comes after so try and move it up and see if that works.

@GAUTAMDVN wrote:

Below is the code of mine:
DATA _NULL_ ;
INFILE CRIME DSD;
INPUT	City : $18.
		Population
		Crime_index 
		Total_crime_index  
		MANM 
		Forcible_rape
		Robbery
		Aggravated_assault
		Burglary
		Larceny_theft
		Motor_vehicle_theft
		Arson ;
FILE  'LEARN.CRIME_STATS.TXT' ;
RUN ;
and below is the error I'm getting

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT.

Re: Informats

GAUTAMDVN — Sun, 17 Jun 2018 19:31:13 GMT

Hi, thanks for helping but no luck SAS log window showing the same error.

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT.

Re: Informats

Reeza — Sun, 17 Jun 2018 19:45:46 GMT

Post your code and log again then.

@GAUTAMDVN wrote:

Hi, thanks for helping but no luck SAS log window showing the same error.

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT.

Re: Informats

Kurt_Bremser — Sun, 17 Jun 2018 19:47:25 GMT

@GAUTAMDVN wrote:

Hi, thanks for helping but no luck SAS log window showing the same error.

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT.

When you do not specify an absolute path, SAS will look for the file in the current working directory. You have to specify a fully qualified path name starting at root.

Re: Informats

error_prone — Sun, 17 Jun 2018 19:47:55 GMT

@GAUTAMDVN wrote:
Hi, thanks for helping but no luck SAS log window showing the same error.

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT.

Then the path you provided is still not correct. Without seeing the code you submitted, i can just guess what went wrong.

Re: Informats

Reeza — Sun, 17 Jun 2018 19:49:10 GMT

Or compare your code to the one used in your other question. That one seems to reference the file correctly to read it in, use the same approach here.

Re: Informats

Tom — Sun, 17 Jun 2018 19:56:37 GMT

Why do you have FILE statement without any PUT statements?

Re: Informats

Tom — Sun, 17 Jun 2018 19:58:30 GMT

@GAUTAMDVN wrote:

In the raw Crime stats data file, change the delimiter from comma to space and then import the file into SAS (be careful about embedded space in the city name!)

Sounds like they want a two step process.

1) change the delimiter from comma to space

2) import the file into SAS

I assume the mean to use the output of the first task as the input to the second.

Re: Informats

Kurt_Bremser — Tue, 19 Jun 2018 06:01:23 GMT

@GAUTAMDVN wrote:

Below is the code of mine:
DATA _NULL_ ;
INFILE CRIME DSD;
INPUT	City : $18.
		Population
		Crime_index 
		Total_crime_index  
		MANM 
		Forcible_rape
		Robbery
		Aggravated_assault
		Burglary
		Larceny_theft
		Motor_vehicle_theft
		Arson ;
FILE  'LEARN.CRIME_STATS.TXT' ;
RUN ;
and below is the error I'm getting

ERROR: Insufficient authorization to access /opt/sasinside/SASConfig/Lev1/SASApp/LEARN.CRIME_STATS.TXT.

This whole step serves no purpose. It reads some data from an external file, but does not out that anywhere.

Since you have no put statement to write data to the external file named in the file statement, that statement is useless.

If you want to read data from an external file into a dataset, you have to name that dataset in the data statement.

So you should test this:

data want;
infile crime dsd;
input
  City : $18.
  Population
  Crime_index 
  Total_crime_index  
  MANM 
  Forcible_rape
  Robbery
  Aggravated_assault
  Burglary
  Larceny_theft
  Motor_vehicle_theft
  Arson
;
run;

and post the log from that.