BookmarkSubscribeRSS Feed
Eric_
Calcite | Level 5

Hi all,

I was running thru the demo p108d01.sas based on the Reading text files PDF lesson. The platform is SAS Studio Enterprise Edition, SAS release: 9.04.01M6P11072018 

 

Per page 1-24, when executing the program below using the  option  dlm="," firstobs=2 obs=4; , the lesson indicates the output data should treat the consecutive delimiters as one and go to the next line resulting an in issue. The log indeed indicates this has occured, however, the program issues a program correction automatically to switching the DLM optoin to the DSD option, which is their solution they want you to apply to correct the issue in the following set of instructions. 

 

At the same time the above solution is applied automatically by SAS, it removes a data cleansing step they had you in the previous step by issuing the statement:

if Name="999" then Name=" ";

 

Is SAS not aware that thier software makes these change automatically? Or perhaps is the lesson out of date and my version was subsequent to when this had to be maually done. It makes me questoin the validity of the remaining lesson. Per the log the top portion submitted and the expected error which should result in reading from the next line.

 

Eric__0-1640798358145.png

 Next is SAS making a program modification and executing its updated program code which applies a DSD fix 
(not suppose to happen per the lesson) and removing the data cleanse line leaving the invalid name that the lessons has you fix

Eric__1-1640798597636.png

Here is the lesson plan indicated expected results and fixes that appear unaware of the above occurences

Eric__2-1640798918821.png

 

Thoughts?

 

1 REPLY 1
SylvainTremblay
SAS Employee

Hello,

 

Can you please elaborate on "however, the program issues a program correction automatically to switching the DLM optoin to the DSD option".

Do you mean that in the code you submit you have the DLM option but in the Log you see that the option DSD was executed instead?

Also, would it be possible to share page no2 of your PDF, I would like to see the course code and prepared date for the course notes.

 

Thanks!

Sylvain

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

5 Steps to Your First Analytics Project Using SAS

For SAS newbies, this video is a great way to get started. James Harroun walks through the process using SAS Studio for SAS OnDemand for Academics, but the same steps apply to any analytics project.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 508 views
  • 1 like
  • 2 in conversation