topic Re: trying to import excel sheet in New SAS User

trying to import excel sheet

aanan1417 — Tue, 05 Apr 2022 06:35:09 GMT

trying to import excel sheet that contain 19 variable .but when i import this excel sheet only two column were export out of 19

Re: trying to import excel sheet

andreas_lds — Tue, 05 Apr 2022 06:41:31 GMT

Please post code and log, so that we the what's happening actually.

Trying to import excel file

aanan1417 — Tue, 05 Apr 2022 12:30:03 GMT

Hi Sir,

i m trying to import excel file that consist of 20 variable and 6400000.

but the issue is few observation are blank due to this i am getting data only 2400000

Re: Trying to import excel file

Ksharp — Tue, 05 Apr 2022 13:15:36 GMT

That is impossible. Excel only can have one million obs .
Are you talking about CSV ?
Post your sas code. some expert like @Tom would give you some advice .

Re: Trying to import excel file

andreas_lds — Tue, 05 Apr 2022 13:44:15 GMT

I have merged your posts, it seems as if they are about the same problem.

As requested earlier: post code + log, so that we see, what you are doing.

Trying to import csv file that have blank observation in between

aanan1417 — Tue, 05 Apr 2022 14:32:59 GMT

Hi Sir,

i m trying to import csv file that consist of 20 variable and 6400000 observation.

but the issue is few observation are blank due to this i am getting data only 2400000

Re: Trying to import csv file that have blank observation in between

ballardw — Tue, 05 Apr 2022 14:53:09 GMT

Show your code.

Show the log.

CSV files are read with a data step generated by Proc Import and the actual content of the data can be critical.

Re: Trying to import csv file that have blank observation in between

Kurt_Bremser — Tue, 05 Apr 2022 16:12:13 GMT

You have been asked REPEATEDLY to post your code and log. How should we help you when you ignore our requests?

Re: Trying to import csv file that have blank observation in between

Tom — Tue, 05 Apr 2022 16:51:18 GMT

@aanan1417 wrote:

Hi Sir,

i m trying to import csv file that consist of 20 variable and 6400000 observation.

but the issue is few observation are blank due to this i am getting data only 2400000

What code did you run? Here is how to structure a data step to read a delimited file (such as a CSV file).

data want;
  infile "filename" dsd firstobs=2 truncover ;
  input var1-var20;
run;

The DSD option tells it to properly handle empty values and quoted values. The TRUNCOVER option tells it to properly handle lines with fewer than 20 values. The FIRSTOBS=2 option tells it to skip the header row, remove if your file does not have a header row.

Adjust the INPUT statement to match the variable names and types needed for your file. The syntax shown will work if all of the variable are numeric.