cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-737557%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ESet%20Property()%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E5%88%97%E3%81%AE%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%A0%E9%A0%86%E5%BA%8F%E3%82%92%E4%BD%9C%E6%88%90%E3%81%99%E3%82%8B%E3%81%AB%E3%81%AF%E3%81%A9%E3%81%86%E3%81%99%E3%82%8C%E3%81%B0%E3%82%88%E3%81%84%E3%81%A7%E3%81%99%E3%81%8B%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737557%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E3%81%93%E3%82%93%E3%81%AB%E3%81%A1%E3%81%AF%E3%80%81%E8%A6%AA%E6%84%9B%E3%81%AA%E3%82%8B%E7%9A%86%E3%81%95%E3%82%93%3C%2FP%3E%3CP%3E3%20%E3%81%A4%E3%81%AE%E5%88%97%E3%82%92%E5%90%AB%E3%82%80%20Demo.jmp%20%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CP%3E%E5%88%97%E5%90%8D%E3%80%81%E3%83%87%E3%83%BC%E3%82%BF%E5%9E%8B%3C%2FP%3E%3CP%3ET%E3%80%81%E3%82%AD%E3%83%A3%E3%83%A9%E3%82%AF%E3%82%BF%E3%83%BC%3C%2FP%3E%3CP%3E%E5%80%A4%E3%80%81%E6%95%B0%E5%80%A4%3C%2FP%3E%3CP%3ESN%E3%80%81%E3%82%AD%E3%83%A3%E3%83%A9%E3%82%B5%E3%83%BC%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E4%BB%A5%E4%B8%8B%E3%81%AE%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%80%81%E5%88%97%E3%80%8CT%E3%80%8D%E3%81%AB%E6%98%87%E9%A0%86%E3%81%A7%E3%80%8CLT%E3%80%8D%E3%80%81%E3%80%8CRT%E3%80%8D%E3%80%81%E3%80%8CHT%E3%80%8D%E3%81%A8%E3%81%97%E3%81%A6%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%A0%E6%B3%A8%E6%96%87%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E8%80%83%E3%81%88%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%2F%2Fdt%20%3D%20Open(%22Demo.jmp%22)%3B%20%0A%2F%2Fplease%20open%20Demo.jmp%20manually%0Adt%20%3D%20Current%20Data%20Table()%3B%0Adt%20%26lt%3B%26lt%3B%20Recode%20Column(%20%3AT%2C%20Update%20Properties(%201%20)%2C%20Target%20Column(%20%3AT%20))%3B%0A%3AT%20%26lt%3B%3CSET%20property%3D%22%22%3E%3C%2FSET%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3EHere%20is%20the%20error%20info%2C%20and%20I%20need%20your%20suggestion%2C%20thanks.%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3EName%20Unresolved%3A%20Update%20Properties%20in%20access%20or%20evaluation%20of%20'Update%20Properties'%20%2C%20Update%20Properties(%201%20)%20%2F*%23%23%23*%2F%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CLINGO-LABS%20id%3D%22lingo-labs-737557%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%E8%87%AA%E5%8B%95%E5%8C%96%E3%81%A8%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E4%BD%9C%E6%88%90%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E3%82%A6%E3%82%A3%E3%83%B3%E3%83%89%E3%82%A6%E3%82%BA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FCODE%3E%3CLINGO-SUB%20id%3D%22lingo-sub-737571%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20Set%20Property()%20%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E5%88%97%E3%81%AE%E3%82%AB%E3%82%B9%E3%82%BF%E3%83%A0%E9%A0%86%E5%BA%8F%E3%82%92%E4%BD%9C%E6%88%90%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95%E3%81%AF%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737571%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EJMP%20%E3%81%A7%E5%AF%BE%E8%A9%B1%E7%9A%84%E3%81%AB%E5%AE%9F%E8%A1%8C%E3%81%97%E3%80%81%E6%8B%A1%E5%BC%B5%E3%83%AD%E3%82%B0%E3%81%8B%E3%82%89%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E5%8F%96%E5%BE%97%E3%81%99%E3%82%8B%E3%81%8B%E3%80%81%E5%88%97%E3%83%97%E3%83%AD%E3%83%91%E3%83%86%E3%82%A3%E3%81%AE%E3%82%B3%E3%83%94%E3%83%BC%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%97%E3%81%A6%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%82%92%E5%8F%96%E5%BE%97%E3%81%97%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1711093143788.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1711093143788.png%22%20style%3D%22width%3A%20367px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62506i51C42F793A6D3728%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1711093143788.png%22%20alt%3D%22jthi_0-1711093143788.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_1-1711093156396.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_1-1711093156396.png%22%20style%3D%22width%3A%20907px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F62507iA173F0A6258539B2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22jthi_1-1711093156396.png%22%20alt%3D%22jthi_1-1711093156396.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EData%20Table(%22Demo%22)%3AT%20%26lt%3B%26lt%3B%20Set%20Property(%0A%09%22Value%20Order%22%2C%0A%09%7BCustom%20Order(%7B%22LT%22%2C%20%22RT%22%2C%20%22HT%22%7D)%2C%20Common%20Order(0)%2C%20Numerical%20Order(0)%2C%0A%09Use%20Locale%20Comparisons%20for%20Characters(0)%7D%0A)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%E5%88%97%E3%81%AE%E3%82%B3%E3%83%94%E3%83%BC%20%2F%20%E5%88%97%E3%81%AE%E3%82%B3%E3%83%94%E3%83%BC%20%E3%83%97%E3%83%AD%E3%83%91%E3%83%86%E3%82%A3%20%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%AF%E9%80%9A%E5%B8%B8%E3%80%81%E5%B0%91%E3%81%97%E5%A4%89%E6%9B%B4%E3%81%99%E3%82%8B%E5%BF%85%E8%A6%81%E3%81%8C%E3%81%82%E3%82%8A%E3%81%BE%E3%81%99%20(%E3%81%93%E3%82%8C%E3%81%AF%E5%88%97%E3%81%AE%E3%82%B3%E3%83%94%E3%83%BC%20%E3%83%97%E3%83%AD%E3%83%91%E3%83%86%E3%82%A3%E3%81%8B%E3%82%89%E3%81%AE%E3%82%82%E3%81%AE%E3%81%A7%E3%81%99)%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EAdd%20Column%20Properties(%0A%09Set%20Property(%0A%09%09%22Value%20Order%22%2C%0A%09%09%7BCustom%20Order(%7B%22LT%22%2C%20%22RT%22%2C%20%22HT%22%7D)%2C%20Common%20Order(0)%2C%20Numerical%20Order(0)%2C%0A%09%09Use%20Locale%20Comparisons%20for%20Characters(0)%7D%0A%09)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

How to use Set Property() to make a custerm order for a column?

Hi, Dears,

I have a Demo.jmp which includes 3 columns:

Column Name, Data Type

T, Character

Value,Numeric

SN,Characer

 

I'd like to make a custerm order on column "T" as "LT","RT","HT" ascending with the script below:

//dt = Open("Demo.jmp"); 
//please open Demo.jmp manually
dt = Current Data Table();
dt << Recode Column( :T, Update Properties( 1 ), Target Column( :T ));
:T <<Set Property( "Value Order",{"LT", "RT", "HT"});

 

Here is the error info, and I need your suggestion, thanks.

Name Unresolved: Update Properties in access or evaluation of 'Update Properties' , Update Properties( 1 ) /*###*/

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to use Set Property() to make a custerm order for a column?

Do it interactively in JMP and get the script from enhanced log OR  by using Copy Column Properties

jthi_0-1711093143788.png

jthi_1-1711093156396.png

Data Table("Demo"):T << Set Property(
	"Value Order",
	{Custom Order({"LT", "RT", "HT"}), Common Order(0), Numerical Order(0),
	Use Locale Comparisons for Characters(0)}
);

Copy Column / Copy Column properties scripts usually require a bit modification (this is from Copy Column Properties)

Add Column Properties(
	Set Property(
		"Value Order",
		{Custom Order({"LT", "RT", "HT"}), Common Order(0), Numerical Order(0),
		Use Locale Comparisons for Characters(0)}
	)
)
-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: How to use Set Property() to make a custerm order for a column?

Do it interactively in JMP and get the script from enhanced log OR  by using Copy Column Properties

jthi_0-1711093143788.png

jthi_1-1711093156396.png

Data Table("Demo"):T << Set Property(
	"Value Order",
	{Custom Order({"LT", "RT", "HT"}), Common Order(0), Numerical Order(0),
	Use Locale Comparisons for Characters(0)}
);

Copy Column / Copy Column properties scripts usually require a bit modification (this is from Copy Column Properties)

Add Column Properties(
	Set Property(
		"Value Order",
		{Custom Order({"LT", "RT", "HT"}), Common Order(0), Numerical Order(0),
		Use Locale Comparisons for Characters(0)}
	)
)
-Jarmo

Recommended Articles