DLM And DSD Infile Option In SAS

In this session, we will discuss the infile options, DLM & DSD in SAS. The DLM option can be used to specify the delimiter that separates the variables in your raw data file.
The DSD option specifies that when data values are enclosed in quotation marks, delimiters within the value are treated as character data. When you specify DSD, SAS treats two consecutive delimiters as a missing value and removes quotation marks from character values.
#sasprogramming #sasprogrammingtutorial #sas #analyticsschool #basesas #dataanalysis #analytics

[@rudrakarki1]

Awesome knowledge shared perfectly..Thanks for making such videos.

[@analyticsschool]

Thnaks Rudra

[@analyticsschool]

Hi Kiran, I checked the video its working fine... please check your speakers

[@deepakkannan7409]

Good video, but it would have been between if you had explained the exact reason for the particular output i.e. In the last example you showed when only DSD is used we are getting improper output, but it would be nice to know why that particular output came. I.e why the output has only "Dona", and rest is not being printed.

[@Progressivethoughts]

Awesome explanation ...please upload a video for PDV vector as well with example

[@analyticsschool]

Will upload the video as soon as I will complete the series on how to read the raw data in SAS.... Please wait for some more time

[@analyticsschool]

Hi Ankit, I have uploaded the video on PDV. Let me know if it helps you.

[@dashnibedita8256]

Very nicely explained. But what if the data has something like 'india,;state,;pincode,,;1234,;'

[@tillupasha786]

Hi sir I want to learn how to write the programme in sas using specification

[@analyticsschool]

Hi Amzad, you can send an email with details at analyticschool@gmail. I will try to send the necessary learning material

[@Progressivethoughts]

if we have two delimiter in one data file then ?

[@analyticsschool]

You can add multiple delimiters in DLM options