Stack Overflow
Stack Overflow

Questions tagged [4gl]

A programming language with a specific domain intended, such as business or science, in which the basic units are of a higher abstraction or power.

Following on the heels of 3GL languages such as C, COBOL and Pascal, the promise of the 4GL was to solve the problem at a higher level of abstraction. A 4GL would be designed with a specific problem domain in mind, such as commerce.

Many 4GLs did not go on to fulfill their initial promise, as 3GLs continued to expand in power and scope, and standardized libraries became more pervasive. The line today between a 3GL and a 4GL is blurry; most modern languages could be considered 4GLs.

Simply tagging your post should be avoided. It's better to tag your post with a tag of your specific 4GL-language. Or at least add the language tag to the 4GL-tag.

Examples:

Informix 4gl can be tagged .

Progress 4GL/ABL -->

Ingres -->

etc.

175 questions
0
votes
1 answer

How to aggretage col1 per ID and val1 per ID and values in col1 in SAS Enterprise Gude or PROC SQL?

I have table in SAS Enterprise Guide like below: ID | COL1 | VAL1 | ----|------|------| 111 | A | 10 | 111 | A | 5 | 111 | B | 10 | 222 | B | 20 | 333 | C | 25 | ... | ... | ... | And I need to aggregate above…
dingaro
  • 2,156
  • 9
  • 29
0
votes
2 answers

How to connect to open edge data base using .pf file?

I'm new to open edge progress ABL. How to connect to the open edge database using .pf file
Naruhina
  • 53
  • 4
0
votes
1 answer

How to take max value from one column for each value in second column in table with many other columns in SAS Enterprise Guide?

I have table in SAS Enterprise Guide like below: COL1 - date COL2 - numeric COL1 | COL2 | COL3 | COL4 | COL5 --------- |-------|-------|------|------- 01APR2021 | 11 | XXX | XXX | XXX 01MAY2021 | 5 | XXX | XXX | XXX 01MAY2021 |…
dingaro
  • 2,156
  • 9
  • 29
0
votes
1 answer

How to delete variables with huge percent of missings in table in SAS?

I have table in SAS with missing values like below: col1 | col2 | col3 | ... | coln -----|------|------|-----|------- 111 | | abc | ... | abc 222 | 11 | C1 | ... | 11 333 | 18 | | ... | 12 ... | ... | ... | ... | ... And I…
dingaro
  • 2,156
  • 9
  • 29
0
votes
2 answers

How to import settings/variables from a json file into a procedure?

I'm trying to make it so that properties are easily adjustable using a .ini file. The problem currently is that currently these properties are defined using the "&global-define". With this the properties are not easily adjustable. I want to put all…
Goodie
  • 11
  • 2
0
votes
1 answer

Execute ACTION from STD on Sage X3

Using Sage X3 v12 (2021R3), I try to execute on a TRT the $APRES_CHOI action from STD and SPE. My process is the following : Object called ZDK, I'm opening an action AZDK1 that opening a custom selection popup (with screens and…
DamienAuvray
  • 45
  • 1
  • 7
0
votes
1 answer

How to count distribution in numbers and percent of binary column in table?

i have table in SAS Enterprise Guide like below: Below table DOES NOT have duplicates in ID column. ID | TARGET ----|-------- 123 | 0 456 | 0 777 | 1 889 | 0 122 | 1 And I would like to aggregate above table with sample data (original table…
unbik
  • 178
  • 9
0
votes
1 answer

Max date and difference in days in Table in SAS Enterprise Guide?

I have table in SAS Enterprise Guide like below: Data type: ID - numeric DT - date OF_1 - character OF_2 - character Values are not sorted in original table, but it could be if it is important for…
dingaro
  • 2,156
  • 9
  • 29
0
votes
1 answer

How to aggregate character data by assigning weights to them in SAS Enterprise Guide or SAS PROC SQL?

I have Table in SAS Enterprise Guide like below. Data type: ID - numeric GROUP - character (only PRI or CON values) ID GROUP 8945 CON 9567 PRI 9567 PRI 284 CON 284 CON 284 PRI And I need to create new character column "COL1"…
dingaro
  • 2,156
  • 9
  • 29
0
votes
1 answer

How to aggregate table to take minimum VALUE for each combination of 2 other columns in SAS Enterprise Guide?

I have table in SAS Enterprise Guide like below: Data types: ID - numeric DT - date EVENT - character VALUE - numeric Values are not sorted in my real dataset, but it can be sorted if it is important for solution. ID | DT | EVENT |…
unbik
  • 178
  • 9
0
votes
1 answer

How to check max difference in dates between events and create new column in SAS Enterprise Guide?

I have table in SAS Enterprise Guide like below. Data types and meaning: ID - numeric - ID of client DT - date - date of change OFFER_1 - charcter - current offer OFFER_2 - character - offer after change Values in original dataset are not sorted,…
unbik
  • 178
  • 9
0
votes
1 answer

How to choose more important value from one column for value in corresponding column in SAS Enterprise Guide?

I have table in SAS Enterprise Guide like below: VAL1 - character ID - numeric VAL2 - character (with only 3 options: P, C, S) VAL1 ID VAL2 P1 123 P P1 123 P P1 123 S S2 44 C S2 44 S GG 44 P P1 58 S P1 58 S And I need to…
unbik
  • 178
  • 9
0
votes
2 answers

How to count how many time some value appeard with defined ID in PROC SQL in SAS Enterprise Guide?

I have Table in SAS Enterprise Guide like below: Data type: ID - numeric SERVICE - character ID SERVICE 123 P1 123 P1 123 G 444 AB 56 c2 And I need to know how many time each ID bought each SERVICE, so as a result I need…
unbik
  • 178
  • 9
0
votes
1 answer

Why sometimes the create operation cannot trigger the on create trigger in progress?

This code is executed first in the project ON CREATE OF customer DO: ... END. And the code of "CREATE customer." is executed elsewhere in the project, but it does not trigger the code in "ON CREATE".
wymmdn
  • 1
0
votes
1 answer

Genero 4GL "Unable to open resource for writing" Error When Saving XML

I am using the standard XML library that comes with Genero 4GL. I am trying to save the XML document to a specific directory based on a variable in a properties file. I can see that it is getting the correct path, AND I can verify that the…
snowfi6916
  • 697
  • 4
  • 9
  • 21
1 2 3
…
11 12