cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
coolbeans
‎03-20-2025
  • 7 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Finding the missing values for variables

by Fluorite | Level 6 in SAS Programming
‎03-18-2025 09:44 PM
‎03-18-2025 09:44 PM
Hi, I'm trying to create  a missing table in which one of variables have multiple subcategories. I used this code but it only gives me the overall missing count and I want to see how much is missing in each section including the count and percent .  An example of the table I am trying to create is below. Thanks!   proc freq data=work.sleep; tables educ*sleep /missing; run;       sleep hrs    5 hrs  6 hrs high school  count  (%missing) count (%missing) college  count(%missing) count (%missing) graduate  count (%missing) count (%missing)       ... View more

Re: Finding observation difference in two separate datasets

by Fluorite | Level 6 in SAS Programming
‎03-03-2025 11:17 AM
‎03-03-2025 11:17 AM
This worked! Ty so much ! ... View more

Re: Finding observation difference in two separate datasets

by Fluorite | Level 6 in SAS Programming
‎03-03-2025 11:07 AM
‎03-03-2025 11:07 AM
An example of the data would be    DATA exclusions; set original; if CVD = . THN DELETE; RUN;   The original dataset would have this kind of data ; DATA original; input ID BLD STROKE  CVD ;datalines ; 1 A 1 . 2 B 0 1 3 O 0 0 4 A 1 . ; RUN;   The excluded dataset would result in this data ; DATA excluded ; input ID BLD STROKE  CVD ;datalines ; 2 B 0 1 3 O 0 0 ; RUN;   So my goal is to figure out by code the difference in observations which should be 2. ... View more

Re: Finding observation difference in two separate datasets

by Fluorite | Level 6 in SAS Programming
‎03-03-2025 01:50 AM
‎03-03-2025 01:50 AM
Matching observations I guess would just be the unique ID? ... View more

Finding observation difference in two separate datasets

by Fluorite | Level 6 in SAS Programming
‎03-03-2025 01:25 AM
‎03-03-2025 01:25 AM
I have two datasets. My original with 150,000 observations and a second one I made from this dataset with exclusions and has a total of 145,000 observations. I'm trying to figure out how to write a code where I can just subtracts these two datasets to  find the total amount excluded / missing. I know the total excluded is 5,000 from simple math but I'm a bit stuck on how we can do this in a  SAS code.    ... View more

Re: Importing Data from Teams

by Fluorite | Level 6 in SAS Programming
‎02-03-2025 12:17 PM
‎02-03-2025 12:17 PM
So the data I want to use is stored in teams it's not located on my machine. I cannot download the data onto my machine either due other reasons. So, I tried with the single and double quotes and I got the same warning sign after running the code. The file I am trying to retrieve are SAS files mixed with other files like pdfs, that is why I used % include.   This is the warning I got with the double quotes:  WARNING: Apparent symbolic reference WEB not resolved. WARNING: Apparent symbolic reference E not resolved. NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. ERROR 22-322: Syntax error   It is similar to the warning using single quotes.  ... View more

Importing Data from Teams

by Fluorite | Level 6 in SAS Programming
‎02-03-2025 11:46 AM
‎02-03-2025 11:46 AM
Hi,  I am trying to import data using a teams path into my SAS engage. This is the code I am using    filename DATA"C:\DATA\mydata.sas"; proc http url="https://pathtofolder" method="GET" out = DATA; run; %include DATA;   When I try to use this code I get these two warnings:  WARNING: Apparent symbolic reference WEB not resolved. WARNING: Apparent symbolic reference E not resolved. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-20-2025 04:19 AM
Quick links