ERROR 22-322: Expecting a name.

[Tom]

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.

[ssv]

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.

[vipendra]

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

[ErikLund_Jensen]

Hi vipendra

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

[vipendra]

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

[Tom]

---

@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;

[vipendra]

Thanks Tom.

It works.

Reagrds
Vipendra