BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
thesasuser
Lapis Lazuli | Level 10

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
thesasuser
Lapis Lazuli | Level 10

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;

.  

View solution in original post

5 REPLIES 5
Reeza
Super User

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? 


 

thesasuser
Lapis Lazuli | Level 10
INFORMAT / Format is $50.
andreas_lds
Jade | Level 19

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.

thesasuser
Lapis Lazuli | Level 10

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;

.  

SAS Innovate 2025: Register Now

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!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 5 replies
  • 991 views
  • 0 likes
  • 4 in conversation