Sas what is dsd

Search instead for. Did you mean:. All forum topics Previous Next. Go to Solution. DSD and Missover. Posted AM views. Accepted Solutions. Re: DSD and Missover. Posted AM views In reply to swayto. Thank You They are not really related at all. Without the DSD option list input as you are using will treat consecutive delimiters as a single delimiter and the values would be read incorrectly.

The explicit DLM is going to be needed since you apparently have a character other than the comma as the delimiter. Comma is the default delimiter. The default is to use space as the delimiter and to treat multiple delimiters as one. That makes sense when space is the delimiter because you normally use multiple spaces to make the data columns align for when humans view the file.

To treat adjacent delimiters as marking a missing value you need the DSD option. But when you use the DSD option the default delimiter is now going to be a comma instead of space. So to use asterisk instead of comma you need to use the DLM option to override the default delimiter.

Note that the DSD option will also change how quotes are treated. Quotes around values are removed and any delimiter enclosed in quotes is treated as part of the data and not as a delimiter.

Calling all SAS users! We now have even more FREE knowledge journeys. Active Oldest Votes. For example, if text file dog. Improve this answer. Yick Leung Yick Leung 1, 1 1 gold badge 9 9 silver badges 16 16 bronze badges.

Thank you! That's all I wanted to know. Reminds me of those classic lyrics, "All I wanted was a Pepsi! Sheldon Sheldon 1, 1 1 gold badge 15 15 silver badges 28 28 bronze badges. Thanks, this answers the question, as to what the characters DSD refers to. I was looking for a way to memorize this and this helps. DSD delimiter-sensitive data specifies that when data values are enclosed in quotation marks, delimiters within the value are treated as character data. Patrick Moore Patrick Moore Refer reference.

Nagaraj S Nagaraj S Dude, you basically just copied and pasted everything from here: studysas. Hence, your link is incorrect as it doesn't reflect to the correct source where you gained the information. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name.