BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
PatrykSAS
Obsidian | Level 7

Hello,

I've made a simple piece of code on SAS Guide which I add below. It works fine but I need to move my program to SAS Data Integration. I've chosen user written code, I created new columns in mapping, added formats and of course the code in code section. I didnt receive any errors, my table is just empty (no rows). I add some screenshots of what I've done.

 

* Table with public bank holidays we will not count a workdays where month.day.year *;
data bankdays;
  attrib begin format=date. ;
  infile datalines dlm=':';
  input begin :anydtdte18. holiday $30.;
datalines;
01.01.2018 : nowyrok
01.06.2018 : trzechkroli
04.01.2018 : wielkanoc
04.02.2018 : 2wielkanoc
05.01.2018 : swietopracy
05.03.2018 : konstytucji
05.20.2018 : zieloneswiatki
05.31.2018 : bozecialo
08.15.2018 : wojskapolskiego
11.01.2018 : zmarlych
11.11.2018 : niepodleglosci
12.25.2018 : bozenarodzenie
12.26.2018 : 2bozenarodzenie
01.01.2019 : nowyrok
01.06.2019 : trzechkroli
04.21.2019 : wielkanoc
04.22.2019 : 2wielkanoc
05.01.2019 : swietopracy
05.03.2019 : konstytucji
06.09.2019 : zieloneswiatki
06.20.2019 : bozecialo
08.15.2019 : wojskapolskiego
11.01.2019 : zmarlych
11.11.2019 : niepodleglosci
12.25.2019 : bozenarodzenie
12.26.2019 : 2bozenarodzenie
01.01.2020 : nowyrok
01.06.2020 : trzechkroli
04.12.2020 : wielkanoc
04.13.2020 : 2wielkanoc
05.01.2020 : swietopracy
05.03.2020 : konstytucji
05.31.2020 : zieloneswiatki
06.11.2020 : bozecialo
08.15.2020 : wojskapolskiego
11.01.2020 : zmarlych
11.11.2020 : niepodleglosci
12.25.2020 : bozenarodzenie
12.26.2020 : 2bozenarodzenie
01.01.2021 : nowyrok
01.06.2021 : trzechkroli
04.05.2021 : 2wielkanoc
05.03.2021 : konstytucji
06.03.2021 : bozecialo
11.01.2021 : zmarlych
11.11.2021 : niepodleglosci
01.06.2022 : trzechkroli
04.18.2022 : wielkanoc
05.03.2022 : konstytucji
06.16.2022 : bozecialo
08.15.2022 : wojskapolskiego
11.01.2022 : zmarlych
11.11.2022 : niepodleglosci
12.26.2022 : 2bozenarodzenie
01.06.2023 : trzechkroli
04.10.2023 : 2wielkanoc
05.01.2023 : swietopracy
05.03.2023 : konstytucji
06.08.2023 : bozecialo
08.15.2023 : wojskapolskiego
11.01.2023 : zmarlych
12.25.2023 : bozenarodzenie
12.26.2023 : 2bozenarodzenie
;
run;

proc sort data=bankdays; 
  by begin;
run;

mapping.JPGcode.JPG

Can you help me with solution how to create a coding part in SAS DI?

 

1 ACCEPTED SOLUTION

Accepted Solutions
DJongman
Obsidian | Level 7
Above your code you see a number of variables, including an _output variable, which refers to a work table name.
If you replace the table name 'bankdays' in your code with &_output, DI will create a table.

View solution in original post

2 REPLIES 2
DJongman
Obsidian | Level 7
Above your code you see a number of variables, including an _output variable, which refers to a work table name.
If you replace the table name 'bankdays' in your code with &_output, DI will create a table.
PatrykSAS
Obsidian | Level 7
Now I understand, thanks for the hint

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 2 replies
  • 441 views
  • 0 likes
  • 2 in conversation