topic Re: ERROR 22-322: Expecting a name. in SAS Programming

ERROR 22-322: Expecting a name.

ssv — Sun, 14 Jan 2018 20:46:08 GMT

Re: ERROR 22-322: Expecting a name.

Tom — Thu, 09 Nov 2017 00:40:42 GMT

If you use a FORMAT like 20. in your INPUT statement

@43 Job_Title @ 20.

then SAS expects a variable name to precede the format.

Did you mean to read JOB_TITLE as a character variable? So perhaps you wanted.

68 @43 Job_Title $20.

Re: ERROR 22-322: Expecting a name.

ssv — Thu, 09 Nov 2017 03:34:46 GMT

Thank you so much Tom... I appreciate your help. By mistake i inserted @ instead of $.

Got the result now.

Thank you for your response. Have a Good one.

Re: ERROR 22-322: Expecting a name.

vipendra — Sat, 26 Jan 2019 08:01:51 GMT

Hi Tom,

Getting same error and tried your suggestion but still hut resolved. Please help me out.

Code to import the file:

data get_US_Company_Dataset;
infile 'C:\Users\HP\Desktop\Jigsaw_Acedemy\US_Company_Dataset.csv' dlm=',' dsd missover firstobs=1 lrecl=20;
input $company_name_id $10 $company_name year_founded $city $state $country zip_code $company_type $date_of_audit;
proc print;
run;

also not getting the output.

Regards

VIpendra

+919106739515

Re: ERROR 22-322: Expecting a name.

ErikLund_Jensen — Sat, 26 Jan 2019 08:31:35 GMT

Hi vipendra

You forgot a period after the character format. I often forget i too.

Re: ERROR 22-322: Expecting a name.

vipendra — Sat, 26 Jan 2019 14:46:08 GMT

Thanks for correcting me @ErikLund_Jensen

Still some of error is throwing.

I want to connect with you personally to learn something from you.

Please mail me @ vipendratripathi6@gmail.com or whatsapp me @+919806980858.

Regards

Vipendra

Re: ERROR 22-322: Expecting a name.

Tom — Sat, 26 Jan 2019 15:06:20 GMT

@vipendra wrote:

Hi Tom,

Getting same error and tried your suggestion but still hut resolved. Please help me out.

Code to import the file:

data get_US_Company_Dataset;
infile 'C:\Users\HP\Desktop\Jigsaw_Acedemy\US_Company_Dataset.csv' dlm=',' dsd missover firstobs=1 lrecl=20;
input $company_name_id $10 $company_name year_founded $city $state $country zip_code $company_type $date_of_audit;
proc print;
run;

also not getting the output.

Regards

VIpendra

...

You have way too many variables for the lines of data to only be 20 bytes long. Remove the LRECL= option on the INFILE statement.

You have an extra $ in front of the variable COMPANY_NAME_ID. Also why should that variable be only the single character in column 10 of the input data line?

You will have much better success if you first define the variables and then just list them in the INPUT statement. That way your INPUT statement does not need any formats or dollar signs. For example just add a LENGTH statement and define which variables are numeric (length of 8 to store the full 8 byte floating point numbers that SAS uses for all numbers) and which are character (maximum length in bytes).

data get_US_Company_Dataset;
  infile 'C:\Users\HP\Desktop\Jigsaw_Acedemy\US_Company_Dataset.csv' dlm=',' dsd TRUNCOVER firstobs=1 ;
  length company_name_id $10 company_name $40 year_founded 8 
    city $30 state $15 country $20 zip_code $10 
    company_type $20 date_of_audit $10
  ;
  input company_name_id company_name year_founded city state country 
      zip_code company_type date_of_audit
  ;
run;

Re: ERROR 22-322: Expecting a name.

vipendra — Sun, 27 Jan 2019 13:15:43 GMT

Thanks Tom.

It works.

Reagrds
Vipendra