Search found 218 matches

by paues
Sat May 30, 2026 2:29 am
Forum: Programming
Topic: Merging datasets
Replies: 4
Views: 470

Re: Merging datasets

I think that I have the second case sorted with the code that I posted. But the first case still eludes me. In the end I want to create a quarterly dated page with a range from 1993Q1 to 1997Q4 with the series name_a , ..., name_i . The quarterly values for each series is in the four last columns of...
by paues
Sat May 30, 2026 2:17 am
Forum: Data Manipulation
Topic: Simple pageunstack gone wrong
Replies: 3
Views: 332

Re: Simple pageunstack gone wrong

And then loop over the pool name and create the missing series? Something like this: pageload .\test.txt pageunstack name dateid @ value if @isempty(@wlookup("value", "group")) then %crossids = name.@crossids for %crossid {%crossids} copy value value{%crossid} next endif delete n...
by paues
Fri May 29, 2026 9:46 pm
Forum: Data Manipulation
Topic: Simple pageunstack gone wrong
Replies: 3
Views: 332

Simple pageunstack gone wrong

I want to import the attached (minimal) text files and unstack them into dated pages with two series: a and b . The text files differ with respect to the value column. The first file (test.txt) has variation in both the name and time dimension (i.e. all unique values), the second (test2.txt) has var...
by paues
Wed May 27, 2026 11:06 am
Forum: Programming
Topic: Merging datasets
Replies: 4
Views: 470

Re: Merging datasets

This seems to handle the second case: mode quiet close @all import(page=key) .\key.txt @freq u 1 %name = @wright(@wlookup("*"), 1) rename {%name} name %name = "name" rename series* key* %keys = @wlookup("key*") %objects = @wdelim( _ @wreplace( _ "vintage year "...
by paues
Wed May 27, 2026 4:55 am
Forum: Programming
Topic: Merging datasets
Replies: 4
Views: 470

Merging datasets

I'm trying to do either a one-to-many or a many-to-one merge of two datasets (attached). The program file where I try to do it is below. mode quiet close @all import(page=key) .\key.txt @freq u 1 %name = @wright(@wlookup("*"), 1) rename {%name} name %name = "name" rename series* ...
by paues
Thu May 21, 2026 10:24 pm
Forum: Programming
Topic: @logmode?
Replies: 1
Views: 436

@logmode?

Is there some way to read the current log mode? (Though I haven't tried personally, I get the impression that it is possible to be writing to several logs at once, which probably complicates matters.)
by paues
Mon May 18, 2026 11:52 pm
Forum: Programming
Topic: Weird behavior relating to scope and local subroutines
Replies: 15
Views: 40901

Re: Weird behavior relating to scope and local subroutines

Progress? Has the bug been looked into yet?
by paues
Sat May 16, 2026 10:05 pm
Forum: Programming
Topic: Get date format for active page?
Replies: 7
Views: 1507

Re: Get date format for active page?

Indeed. But then once in a while, it doesn’t. And then it’s harder to build something dependable on it.
by paues
Sat May 16, 2026 8:17 am
Forum: Programming
Topic: Get date format for active page?
Replies: 7
Views: 1507

Re: Get date format for active page?

I want to be able to take a date string specified in the format of current page and then unambiguously convert that string to a date value.
by paues
Thu May 14, 2026 10:55 pm
Forum: Programming
Topic: Get date format for active page?
Replies: 7
Views: 1507

Re: Get date format for active page?

By "machine based", do you mean that it depends on the locale of the machine?
by paues
Thu May 14, 2026 10:53 pm
Forum: Programming
Topic: Get date format for active page?
Replies: 7
Views: 1507

Re: Get date format for active page?

I was thinking date format . On a typical quarterly page, I'd like to get back "YYYY[Q]Q". I have often found code like this %old_date_format = @word( _ "YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY YYYY " _ + "YYYY[S]S YYYY[Q]Q YYYY[M]MM " _ + "DD/MM/YYYY DD/...
by paues
Tue May 12, 2026 11:45 pm
Forum: Programming
Topic: Get date format for active page?
Replies: 7
Views: 1507

Get date format for active page?

Is it possible to get the date format of the current page? So that I know that @dateval gives me the correct value.
by paues
Sun May 10, 2026 4:56 am
Forum: Programming
Topic: Valid names for options?
Replies: 1
Views: 1176

Valid names for options?

Are the requirements for valid option names (“hasoptions” and “equal options”) the same as for object names?
by paues
Fri May 08, 2026 10:25 pm
Forum: Bug Reports
Topic: shell not working
Replies: 0
Views: 2560

shell not working

When I enter shell in the command prompt, I get the following error message: Unable to create process: Katalognamnet är felaktigt. . It translates to "Fault path name". I think that the error code is ERROR_BAD_PATHNAME. It seems to occur when @datapath refers to a nonexistent folder, which...
by paues
Thu May 07, 2026 11:13 am
Forum: Programming
Topic: How to break out of called program from within subroutine?
Replies: 1
Views: 1537

How to break out of called program from within subroutine?

Is there some way in the setup below to break out of child.prg from the subroutine childsub and return to parent.prg? The desired solution would show the dialog box "after child" but none of the other two. parent.prg exec .\child.prg @uiprompt("after child") child.prg call childs...

Go to advanced search