BookmarkSubscribeRSS Feed
Calcite | Level 5 Qsz
Calcite | Level 5

Hello, I'm trying to write the following SAS commands for the attached data. Any help will be appreciated. 

Calcite | Level 5 Qsz
Calcite | Level 5

Not well enough but it was helpful

Super User

Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software.


Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.


In short, XLSX is not a SAS data set.


Instructions here: will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Calcite | Level 5 Qsz
Calcite | Level 5

attached is the data sheet for the question I asked. 

Diamond | Level 26

It's also true that many users won't download Microsoft Word documents because they are a security risk. In fact, some people will not download any Microsoft Office documents for the same reason, and you ought to avoid using them as a method of providing data or provided SAS log or SAS output.

Paige Miller



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!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 4 in conversation