About KathyKiraly

KathyKiraly · ‎01-02-2025

Hi Verena, Please send email to elearn@sas.com and let us know which instructions you are following. For example, SAS OnDemand for Academics. We will do our best to assist you. Kathy

KathyKiraly · ‎06-26-2024

Thank you for this great series!

KathyKiraly · ‎06-17-2024

Great info. Thanks for this series!

KathyKiraly · ‎09-21-2023

You can contact SAS Technical Support here: https://support.sas.com/en/technical-support.html.

KathyKiraly · ‎04-12-2023

Within SAS Viya for Learners software, go to Help and Support [?] at the bottom of the screen. Then select FAQs. Bullet 9 details the access rules. The Educator access contains teaching resources.

KathyKiraly · ‎04-10-2023

Hello, Please contact us at curriculumconsulting@sas.com and we will do our best to assist you. We would like to see your complete SAS log after you run the cre8data.sas program to see all notes, warnings, and messages.

KathyKiraly · ‎12-06-2022

It appears that your variable BirthGender stores 1 and 2, not Male and Female as per this partial of your SAS log. FamilyEverHadCancer2=1 Age=-9 BirthGender=2 WorkFulltime=2 Occupation_Employed=2 Could it be that your code should read as follows? if BirthGender=1 then sex='Male'; else if BirthGender=2 then sex='Female;

KathyKiraly · ‎09-21-2022

Hi, When using SAS Enterprise Guide for the SAS Programming 1 e-Learning, you must create an Autoexec file that creates your data each time you start a new SAS session. Please send email to curriculumconsulting@sas.com so we can better assist you.

KathyKiraly · ‎07-20-2022

PROC SETINIT displays the products your company or school has licensed. PROC PRODUCT_STATUS displays the products that are installed. proc product_status; run; You must have SAS/ACCESS Interface to PC Files in SAS release 9.4 M2 or higher to use the XLSX engine.

KathyKiraly · ‎10-19-2021

Many of you expressed interest in the Data Cleaning Techniques course. It is now on the schedule Tuesday-Friday, 11-14JAN2022 in the Live Web classroom! Join Mark Jordan as he discusses how to work with missing/invalid data values, compare two data sets with and without a common ID variable, work with and manipulate dates, use integrity constraints and audit trails to surface data errors, and much more. Click here for the course link and to register. Click here to see if you qualify for any training discounts.

KathyKiraly · ‎02-08-2021

The LIKE operator accepts the % wildcard, but the CONTAINS does not. where Main_Problem contains 'T0%' means you are specifically looking for the character string T0% in the value. This would return T0%, AT0%, LT0%2g, etc. where Main_Program like 'T0%' means you are looking for all values that start with T0 with zero or more characters following. This would return T0A, T032, T0ALL, etc.

KathyKiraly · ‎02-05-2021

The value for the MSGLEVEL system option is the letter I, not the number one. options msglevel=i;

KathyKiraly · ‎01-19-2021

You are using the wrong folder path in your %LET statement. The s:/workshop path is just an example. Your screen shot indicates you are using SAS OnDemand for Academics. You must change the s:/workshop location to match the folder path for your EPG194/data folder. That is the location for all the course data. The surest and easiest way to find the fully-qualified path name is to right-click the EPG194/data folder and select Properties. You will see your folder path in the Location field. For SAS OnDemand, the folder path should be: %let path=/home/your-userid/EPG194/data; and your LIBNAME should be libname pg1 "&path";. Your PROC IMPORT should then have datafile="&path/storm.xlsx". If you still have trouble, please send an email to curriculumconsulting@sas.com

KathyKiraly · ‎10-14-2020

This code will return 13, which is in file1, but not file2. data file1; input prsnid $ ; datalines; 11 12 13 14 ; run; data file2; input prsnid $ gracedate yymmdd10.; datalines; 11 2020-12-31 12 2020-12-31 14 2020-01-01 ; run; proc sql; select prsnid from file1 except select prsnid from file2 ; quit;

KathyKiraly · ‎10-14-2020

If I understand your question, you can use the EXCEPT operator in PROC SQL. It will display values of a variable that are present in the first data set, but not in the second data set. Here is some code to test. data one; input num; cards; 1 2 3 4 ; run; data two; input num; cards; 1 2 6 7 ; run; proc sql; select num from one except select num from two ; quit; The final result will display 3 and 4.

Online Status	Offline
Date Last Visited	‎07-18-2025 12:45 PM

Re: SAS® Programming 1: Essentials - can't open zip file

Re: Unveiling the Latest Upgrades: SAS Visual Analytics Empowers the A...

Re: Unveiling the Latest Upgrades: SAS Visual Analytics Empowers the A...

Re: Error: engine XLSX cannot be found

Re: Will SAS Viya for Learners expires?

Re: US Census data analysis using SAS

Re: recoding a variable

Re: Can't find file storm_summary.sas7bdat

Re: Error: engine XLSX cannot be found

Data Cleaning Techniques is scheduled!

Unveiling the Latest Upgrades: SAS Visual Analytics Empowers the Acade...

Unveiling the Latest Upgrades: SAS Visual Analytics Empowers the Acade...

Re: Error: engine XLSX cannot be found

Re: recoding a variable

Data Cleaning Techniques is scheduled!

Re: MSGLEVEL=I

Re: How to report values of a variable from a dataset that are not pre...

Re: SAS® Programming 1: Essentials - can't open zip file

Re: Unveiling the Latest Upgrades: SAS Visual Analytics Empowers the A...

Re: Unveiling the Latest Upgrades: SAS Visual Analytics Empowers the A...

Re: Error: engine XLSX cannot be found

Re: Will SAS Viya for Learners expires?

Re: US Census data analysis using SAS

Re: recoding a variable

Re: Can't find file storm_summary.sas7bdat

Re: Error: engine XLSX cannot be found

Data Cleaning Techniques is scheduled!

Re: Like vs contains using where statement to identify obs - different...

Re: MSGLEVEL=I

Re: Missing Excel 'storm' data file in p101d01.sas on SAS studio

Re: How to report values of a variable from a dataset that are not pre...

Re: How to report values of a variable from a dataset that are not pre...