topic Re: CSV infile for strings long then 8 in SAS Data Management

CSV infile for strings long then 8

underarmnat — Sun, 13 May 2018 23:16:21 GMT

Morning all,

I am trying to read in a csv dataset with first and middle name and then a last name,and I know it trucates at 8 letters, but from reading forums I can't crack the code that imports the variables in their full format.

My current code (excluding length attempts is)

data namesofromanemperors_csv;

infile "/home/natelucaswelling0/romans/romanemperors.csv" firstobs=2 dlm=',' missover;

input studyno firstplusmiddle $ surname $;

run;

I have then tryed variations, but this results in variables being not included if they don't have 25 letters...

data namesofromanemperors_csv;

infile "/home/natelucaswelling0/romans/romanemperors.csv" firstobs=2 dlm=',' missover;

input studyno firstplusmiddle $25. surname $15.;

run;

Thanks in advance for advice

Re: CSV infile for strings long then 8

novinosrin — Sun, 13 May 2018 23:34:48 GMT

I think you are missing colon format modifier like this

data namesofromanemperors_csv;

infile "/home/natelucaswelling0/romans/romanemperors.csv" firstobs=2 dlm=',' missover;

input studyno firstplusmiddle : $25. surname : $15.;

run;

or show us an example of couple of datalines samples please

Re: CSV infile for strings long then 8

underarmnat — Mon, 14 May 2018 00:15:38 GMT

That worked perfect,

Thanks!

Re: CSV infile for strings long then 8

Andygray — Mon, 14 May 2018 00:21:02 GMT

@underarmnat If your question has been answered, you could mark as answered and close the thread

Re: CSV infile for strings long then 8

Andygray — Mon, 14 May 2018 00:55:33 GMT

Not mine. You should have marked whomsoever who gave you the solution. lol