About Panagiotis

Panagiotis · ‎10-12-2018

No worries! I was in the middle of typing that exact response! I have made that mistake before. Best way to learn is to make a mistake and then fix it. Nice work! - Peter

Panagiotis · ‎10-11-2018

Hi @IsabelMaria, You might of not set up the shared folder. Try this video: Setting Up Shared Folders for SAS University Edition Here is one on Accessing Your Existing Data: for SAS University Edition. She runs through checking your shared folder and how to find the path to your folder. Let me know if this helps. - Peter

Panagiotis · ‎10-10-2018

Something like this: Course-Case-Studies and Challenges? I also recommend the free self paced SAS Programming 1 Essentials e-Learning Course. Or you can find a public class and take it with an instructor.

Panagiotis · ‎10-10-2018

I forgot to mention, if you want to review proc import and the ODS statement take a look at the free SAS Programming 1 Essentials e-learning course. Proc import is taught in chapter 2 "Accessing Data", and in chapter 6 "Exporting Data" the ODS statement is taught. SAS Programming 1: Essentials - Scroll to where it says Self-Paced e-Learning and it should say free. Click start and review the entire course or the chapters you need! - Peter

Panagiotis · ‎10-10-2018

Quick question, your subject says importing/exporting CSV files but your question says exporting HTML. I answered them both, I wasn't sure which you wanted. 1. If you want to import/export CSV files the easiest is to proc import and proc export Proc Import Documentation Proc Export Documentation Quick example of proc import proc import datafile="Location/of/file.csv" dbms=csv out=SASoutputTableName/*Creates the SAS table from the CSV file*/ replace /*If out table exists replace it*/; /*More statements you can use (optional). See documentation*/ getnames=;/*Yes or No*/ guessingrows=;/*Used to guess the column type and length*/ run; 2. If you are looking to export to an html file look at ODS html. ODS HTML Documentation Quick example for a sample SAS table you should have ods html body="C:\Where\You\Want\The\HTMLFile\Testfile.html"/*<--Change this location*/ style=htmlblue; proc means data=sashelp.cars; var mpg_city; class type; run; ods html close;

Panagiotis · ‎10-01-2018

Vladimir check out this post: https://communities.sas.com/t5/Programming-1-and-2/Lesson-Videos-Not-Loading-Properly/m-p/497905#M51 You could have the same issues. Let me know. - Peter

Panagiotis · ‎09-28-2018

Not sure if you can do it in SQL, but here are two options that might work. 1. Creates a macro variable and uses that as a footnote with the total. Not sure if this will work for you since you want a row. proc sql noprint; select sum(mpg_city) as total into :total /*Create macro variable total with the total count*/ from sashelp.cars; quit; %put &=total; /*View macro variable in the log. See there are leading spaces*/ %let total=&total; /*Set macro variable to itself and removing leading spaces*/ %put &=total; /*View macro variable in the log to ensure it's correct*/ footnote "The total MPG_City is: &total"; /*Add macro variable to footnote*/ proc sql ; select make, count(make) as count from sashelp.cars group by make order by make; quit; footnote; 2. This will combine a few things. I got this from here: Insert a Row at the end of the data with totals so it's not my solution. Pretty cool way of doing it, I learned something new. /*Create the total row*/ proc means noprint data=sashelp.cars ; output out=summary(keep=mpg_city) sum=mpg_city; run; /*Create the necessary table using your proc sql*/ proc sql; create table test as select make, count(make) as count from sashelp.cars group by make order by make; quit; /*Combine the tables*/ data want ; set test summary(in=in2); /*concatenate the tables. In= option creates a temp variable called in2*/ if in2=1 then Make='TOTAL'; /*In2 will =1 when SAS brings in the row from summary. This will allow us to change the column name we want to "Total"*/ run;

Panagiotis · ‎09-27-2018

How many times have you started working with data that is completely ready for analysis? Once, twice, always, NEVER? Well hopefully not never, but typically data is not ready for analysis and it can be your job to prepare it. Now, you might hear all sorts of different statistics regarding data preparation, but the typical stat you will hear is the 80/20 rule. The rule states that 80% of your time will be spent preparing data and the other 20% will be spent on analysis. Some surveys even conclude that data preparation can be the least enjoyable part of the project, which is crazy! I see the data preparation stage as a puzzle that needs to be solved, and I love puzzles! In this case study you will focus on preparing 2014 global tourism data using the knowledge gained from the SAS Programming 2 course. The current tourism data is not in a format ready for analysis, and to prepare the data correctly you will need to follow the requirements in the case study. Requirements include: reorganizing the data creating new columns converting character columns to numeric converting character case dropping unnecessary columns create and applying a custom format merging data Try to think of this problem as a puzzle that needs to be solved. Take your time, work on one part at a time and move on to the next! When working on this case study you might be thinking "what do I do if I get stuck?" That's an excellent question! Let's discuss the ways you can attempt the case study to best suit your specific needs: If you feel comfortable with the topics in the SAS Programming 1 course and want to treat this as a real-world problem, read the Introduction, Data Layout and Requirements sections of the PDF and begin! During the process feel free to use your notes, Google, or SAS Documentation. When you are done look at the Data Validation section in the PDF to compare your results to the results provided. If you think you might need a bit of assistance in the case study use the Assignment Guide section to help guide you. The guide will not give you the solutions, but more of a road map on how to solve problem. If you are new to SAS and want to use the case study as more of a demo feel free to do so. You can use the Assignment Guide and Hints section to give you a suggested solution to each specific problem. I recommend after your run through the case study as a demo to go back and attempt it on your own. If you have any questions regarding the case study, if you complete the case study and come up with different solutions and want to show them off, or if you want to post additional visualizations or analysis of the data create a post in the SAS Programming 1 and 2 Forum. We would love to hear from you! To attempt this case study, you will need to download the following: SAS Programming 2 Data Manipulation Techniques Case Study PDF cs_tourism.sas SAS program. Run the program and it will create the country_info and tourism tables necessary for the case study. Both these tables will be created in your WORK library. log_scanner.sas SAS program. This program will be used in the case study bonus. Be curious. What questions can you answer with your newly prepared data?

Panagiotis · ‎09-27-2018

Just by looking at your code, I am assuming you have some experience in SQL? It looks like you are trying to use the WHERE statement like you would in SQL. In SAS the MERGE statement needs the BY Statement. The by statement will tell SAS what columns to merge on. The column that you are merging on must have the same name in both tables (which yours looks like it does) and be sorted in both tables. Without really understanding the data and your goal,I can only get you started. Your code should look something like this: data BREAST_ED_REASONS_GS_092718; MERGE raw.BREAST_DIAG_PRTY1 raw.ICD10_CLASSIFICATIONS; BY DIAG_CD; RUN; But here is some documentation for you to look at: SAS Paper: SAS® DATA Step Merge – A Powerful Tool (this is pretty in depth and should really help). SAS Documentation: Match-Merging (quick examples) SAS Documentation: SAS® 9.4 SQL Procedure User's Guide, Fourth Edition - Joins (Using PROC SQL)

Panagiotis · ‎09-27-2018

Analyze United States Airport Claims Data Have you ever been to an airport in the United States and your luggage was lost or you experienced an incident that involved theft, property damage, personal injury or even death? If so, you can file a claim and a record of that incident will be documented by the United States Transportation Security Administration (TSA). In this case study you will apply your knowledge from the SAS Programming 1 course to Access, Explore, Prepare, Analyze and Export over 200,000 TSA Claims from 2002 – 2017. You will run through the SAS programming process to investigate these claims that contain information like incident date, date received, airport, airport location, claim type, and claim site. Using this information you can answer questions like: Which year had the most claims? What type of claims happen most often? Which state has the most claims? How are claims typically settle? When working on this case study you might be thinking "what do I do if I get stuck?" That's an excellent question! Let's discuss the ways you can attempt the case study to best suit your specific needs: If you feel comfortable with the topics in the SAS Programming 1 course and want to treat this as a real-world problem, read the Introduction, Data Layout and Requirements sections of the PDF and begin! During the process feel free to use your notes, Google, or SAS Documentation. When you are done look at the Results section in the PDF to compare your results to the results provided. If you think you might need a bit of assistance in the case study use the Assignment Guide section to help guide you. The guide will not give you the solutions, but more of a road map on how to solve problem. If you are new to SAS and want to use the case study as more of a demo feel free to do so. You can use the Assignment Guide and Hints section to give you a suggested solution to each specific problem. I recommend after your run through the case study as a demo to go back and attempt it on your own. If you have any questions regarding the case study, if you complete the case study and come up with different solutions and want to show them off, or if you want to post additional visualizations or analysis of the data create a post in the SAS Programming 1 and 2 Forum. We would love to hear from you! To attempt this case study, you will need to download the: SAS Programming 1: Essentials Case Study PDF TSAClaims2002_2017.csv file Be curious. What other questions can you answer with this data?

Panagiotis · ‎09-24-2018

Hello everyone, There has been an update to the Enterprise Guide course setup on 9/24/2018. If you have downloaded the course data after this date, you can disregard this update. If you have downloaded the course data prior to 9/24/2018 you will encounter the issue when using the "@path/<datalocation>" you will not find the data. To fix this issue you have two options: You can download the new course setup data and follow the same instructions as you did previously. OR If you do not want to re-setup the data, you will need to fix the path macro variable to point to your data folder. To do this, you will need to: 1. Open the project you have saved from the course setup. After you open the project, your project tree should look something like this: 2. Select the Autoexec process flow. Then go to File -> New -> Program. Right click the new SAS Program and name the program "path". Make sure path is located after the first two SAS Programs. When Enterprise Guide autoexecs, it will run each program in sequential order. The path program needs to be last. It should look like this: 3. Make sure the SAS Program "path" is open and type the following in the editor and run the program: %let path=%superq(path)/data/; 4. That's it! Next make sure to save the new project by going to File -> Save All. What we needed to do was update the location of the path macro variable. Path was pointing to the location where the data folder was located, but we need to tell SAS to go inside the data folder to find your files. - Peter

Panagiotis · ‎09-24-2018

@mazensleiman, The path macro variable is being created during setup. If you type the following and run the statement, you will see where path is pointing to on your machine: %put &=path; On my setup Path is pointing to the data folder in the temporary location that contains all the data that is being created for the course when you run that autoexec program. Path will point to the data folder, but you need to add the "/data/" to get you inside the folder allowing you to access the np_info.xlsx Excel workbook. Try typing: libname np xlsx "&path/data/np_info.xlsx"; After you run this libname statement, it should connect you to the Excel workbook. Next go to your servers window on the left side of Enterprise Guide and : 1. Select local and press the refresh button. 2. Expand libraries and find NP. 3. Expand the NP library You should see the following three tables in the NP library called PARKS, SPECIES, VISITS. Your proc contents should select one of those tables. I'm guessing you are working on the activity for accessing data? If so, your proc contents should not be using the Excel workbook name, but one of the worksheet names inside that workbook. SAS is treating each worksheet like a SAS table. If my assumption is correct and you are working on the activity, it asks you to read the PARKS table in the NP library. Type: proc contents data=np.parks; run; Let me know if that works. - Peter

Panagiotis · ‎09-21-2018

No problem! Path will get you to the main folder, the /data/ will go inside the data folder where the Excel file is located.

Panagiotis · ‎09-21-2018

Try adding /data/ between path and the Excel file: libname np xlsx "&path/data/np_info.xlsx"; - Peter

Panagiotis · ‎09-21-2018

@mazensleiman, If the code in red is the exact code you wrote, you have a typo in the file extension. It should be .sas7bdat, not .sas7dbat. It's a subtle difference, but you can tell because the log indicates the file extension has an error. You should also need to use a slash like your first example. Hope that helps! - Peter

Online Status	Offline
Date Last Visited	‎05-02-2024 11:20 AM