topic Re: Importing variable with long charecter data in SAS Programming

Importing variable with long charecter data

thesasuser — Fri, 20 Jul 2018 03:48:32 GMT

In the windows machine the files owned by deleted users show a long set of characters foor user name. It will be like

O:S-1-2-3-10 integer grp- 10 ineger grp- 10 integer grp- 3 to 5 integers

( in the posted message the colon appears as an image/ smiley )

When the text /csv file having these values is imported, it becomes three dots (...)

Is there a way to import them so that they appear as they are?

Re: Importing variable with long charecter data

Reeza — Fri, 20 Jul 2018 03:48:51 GMT

Three dots usually means not shown. How are you importing your data and how are you checking it. Make sure the formats are correct.

@thesasuser wrote:

In the windows machine the files owned by deleted users show a long set of characters foor user name. It will be like

O:S-1-2-3-10 integer grp- 10 ineger grp- 10 integer grp- 3 to 5 integers

( in the posted message the colon appears as an image)

When the text /csv file having these values is imported, it becomes three dots (...)

Is there a way to import them so that they appear as they are?

Re: Importing variable with long charecter data

thesasuser — Fri, 20 Jul 2018 03:50:46 GMT

INFORMAT / Format is $50.

Re: Importing variable with long charecter data

andreas_lds — Fri, 20 Jul 2018 04:57:50 GMT

Why is an (output-) format attached to the variable? If a format is attached to a char variable only the number of chars named in the format is shown. So: remove it.

Re: Importing variable with long charecter data

Kurt_Bremser — Fri, 20 Jul 2018 07:03:39 GMT

To avoid conversion of smileys etc, use the {i} button for posting such items.

And show your code (see my footnotes for hints about posting code).

Re: Importing variable with long charecter data

thesasuser — Sun, 29 Jul 2018 02:38:29 GMT

Thanks You all for the response.

I solved this using a code like this. Inserted a length statement.

data work.temp2;
length long_value $ 100;
input long_value $;
datalines;
O:S.1.5.1234567890-1234567890-1234567890-123456
O:S.1.5-1234567890-1234567890-1234567890-345671
O:S.1.5-1234567890-1234567890-1234567890-1234
O:S.1.5-1234567890-1234567890-1234567890-123433
O:S.1.5-1234567890-1234567890-1234567890-123491
;
run;