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?
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;
.
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?
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.
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).
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;
.
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.