BookmarkSubscribeRSS Feed
iSAS
Quartz | Level 8

We need to convert the program into proc sql programming. Could someone assist us on this?

 

The data will contain country holidays. From the data source file given, fulfill the following requirements:

 

  1. Create database, tables (staging tables and audit tables)
  2. Define indexes, constraints, triggers, functions, procedures and other as needed. (I’m not sure if this is applicable to SAS?)
  3. Only load the current year holidays.
  4. Aside from the holidays from the file, all the weekends (Saturdays and Sundays) will be entered in the result table as a weekend holiday, which can be identified differently from the holiday picked up from the file.
  5. Design the tables thinking that there will be several country files.

 

 

The proc sql script for the database design and the data itself should be able to address the following questions:

 

  1. How many holidays are there for each country?
  2. How many weekend holidays are there, at the same time falling as a declared holiday?
  3. When was a certain record added, updated or deleted?
  4. If all dates are loaded, what are repeating holidays?
4 REPLIES 4
andreas_lds
Jade | Level 19

What have you tried so far?

iSAS
Quartz | Level 8
So far, I just imported the source file in sas and filtered dates w/ year 2018. No index, etc. were made. Adding weekend tables and designing tables for multiple countries haven't been done yet
PaigeMiller
Diamond | Level 26

@iSAS wrote:

We need to convert the program into proc sql programming. Could someone assist us on this?


Sure, you do the work, and if you get stuck, we'll be happy to assist. 

 

As implied by @andreas_lds, show us your code and we can help.

--
Paige Miller
RW9
Diamond | Level 26 RW9
Diamond | Level 26

"We need to convert the program" - what program?

 

1 & 2 sound like database activities, not a SAS way of thinking.

 

For SQL a good reference:

https://www.w3schools.com/sql/

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

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

View all other training opportunities.

Discussion stats
  • 4 replies
  • 748 views
  • 0 likes
  • 4 in conversation