topic Re: Data cleaning: delete all the wrong format login ids in SAS Programming

Data cleaning: delete all the wrong format login ids

yichentian226 — Sat, 05 Dec 2020 00:36:42 GMT

Hi! As you can see I am seeing some weird format logins in the dataset. I am trying to delete them but couldn't really find out a way. Eg: login=12963 . I can't find out a way to delete the records when they're made up by pure numbers. I tried to proc sort the numbers but this didn't work, SAS is not showing me those records who are made up by numbers at the first rows. Any help is appreciated! Thanks!

Re: Data cleaning: delete all the wrong format login ids

ChrisNZ — Sat, 05 Dec 2020 07:52:08 GMT

> I am seeing some weird format logins

Why are they weird?

> I can't find out a way to delete the records when they're made up by pure numbers.

Try this: if compress(VAR,,'d')=' ' then delete;

> I can't find out a way to delete the records when they're made up by pure numbers.

Try this: if compress(VAR,' ','d') then delete;

> SAS is not showing me those records who are made up by numbers at the first row

What does this mean?

@yichentian226 wrote:

Re: Data cleaning: delete all the wrong format login ids

ballardw — Sat, 05 Dec 2020 09:32:36 GMT

Please run Proc Contents on your SAS data set and tell use what the variable name is, the variable type and the format assigned.

The PICTURE you show appears to come from a spreadsheet. One of the truly obnoxious thing about spreadsheets is that certain types of files when opened with spreadsheet software will pick and chose some values to display as a different format.

So what you seeing may not be the value that was in SAS.