topic Re: missing values at the start column in New SAS User

missing values at the start column

archita — Thu, 03 Dec 2020 17:47:46 GMT

I have a csv data which i am importing in sas , the first column of which has ',' only, what should i use to read in as the values are transcending to next column, i have used dsd,dlm,missover.

Re: missing values at the start column

Kurt_Bremser — Thu, 03 Dec 2020 18:06:58 GMT

Please copy/paste the first few lines of the csv file into a window opened with this button:

And post the code you tried into a window opened with the "little running man" button right next to the one indicated.

Re: missing values at the start column

archita — Thu, 03 Dec 2020 18:32:12 GMT

ID NAME STATE WEIGHT AGE
"," SAM WA 67 12
"," TOM TX 90 15
"," GINNY MI 89 16

Re: missing values at the start column

archita — Thu, 03 Dec 2020 18:34:25 GMT

ID NAME STATE WEIGHT AGE
, SAM WA 67 12
, TOM TX 90 15
, GINNY MI 89 16

Re: missing values at the start column

Kurt_Bremser — Thu, 03 Dec 2020 18:43:50 GMT

See this:

data want;
infile datalines firstobs=2 dlm=" " dsd truncover;
input id $ name $ state $ weight age;
drop id;
/* or this */
if id = "," then id = " ";
datalines;
ID NAME STATE WEIGHT AGE
, SAM WA 67 12
, TOM TX 90 15
, GINNY MI 89 16
;

Replace the DATALINES keyword in the INFILE statement with your path to the file, and replace the DATALINES block with a RUN statement.

Re: missing values at the start column

archita — Thu, 03 Dec 2020 18:55:50 GMT

I am not getting the desired output

Re: missing values at the start column

archita — Thu, 03 Dec 2020 18:58:48 GMT

Id,NAME,STATe,WEIGHT,AGE
,WA,67,12
,TOM,TX,90,15
,GINNY,MI,89,16

this is how the data looks ,i want to read in this into sas.

Re: missing values at the start column

Kurt_Bremser — Thu, 03 Dec 2020 19:23:37 GMT

Open your file with a text editor, and copy/paste the content into a code box, as described earlier. Only when I can be half-way sure I see what you really have, will I work on further code.

Re: missing values at the start column

archita — Thu, 03 Dec 2020 19:25:14 GMT

please find the attached file.

Re: missing values at the start column

Kurt_Bremser — Thu, 03 Dec 2020 19:30:45 GMT

data want;
infile '/folders/myfolders/test1.txt' firstobs=2 dlm="," dsd truncover;
input id $ name $ state $ weight age;
run;

proc print data=want;
run;

Result:

Beob.	id	name	state	weight	age
1	 	WA	67	12	.
2	 	TOM	TX	90	15
3	 	GINNY	MI	89	16

The first data line misses a name.

Re: missing values at the start column

Tom — Thu, 03 Dec 2020 19:44:33 GMT

@archita wrote:
ID NAME STATE WEIGHT AGE
"," SAM WA 67 12
"," TOM TX 90 15
"," GINNY MI 89 16

Why did you post this? It does not look anything at all like the file your attached before.

Here is what those lines look like. Notice how I used the Insert Code button on the forum editor to allow me to paste in the text and have it displayed without being interpretted as paragraphs.

Id,NAME,STATe,WEIGHT,AGE
,WA,67,12
,TOM,TX,90,15
,GINNY,MI,89,16

If you don't want to keep the ID variable in your SAS dataset you can use a DROP statement in your data step that reads the text file.

data want;
  infile 'myfile.txt' dsd firstobs=2 truncover;
  input Id $ NAME $ STATe $ WEIGHT AGE;
  drop id;
run;

Re: missing values at the start column

archita — Thu, 03 Dec 2020 19:44:42 GMT

Thank you it is working now.

Re: missing values at the start column

archita — Thu, 03 Dec 2020 19:46:26 GMT

thank you it is working .