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

Hi all SAS Users,

 

Today I found that in my data, there is one dataset that the compressed increases pages of data (dataset want), so I decided to set it be no compress

My code is as below

proc transpose data=want out=currency (rename=(col1=ex_rate _name_=CURCDD)) (compress=no);
	by datadate;
	var AUD--ZWD;
run;

The log is as below

68         
69         proc transpose data=want out=currency (rename=(col1=ex_rate _name_=CURCDD)) (compress=no);
                                                                                       _
                                                                                       22
                                                                                       200
ERROR 22-322: Syntax error, expecting one of the following: ;, DATA, DELIM, DELIMITER, INDB, LABEL, LET, NAME, OUT, PREFIX, 
              SUFFIX.  
ERROR 200-322: The symbol is not recognized and will be ignored.

Could you please help me to sort it out?

Warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

Put all of the dataset options into the same group.

(rename=(col1=ex_rate _name_=CURCDD)
 compress=no
)

View solution in original post

1 REPLY 1
Tom
Super User Tom
Super User

Put all of the dataset options into the same group.

(rename=(col1=ex_rate _name_=CURCDD)
 compress=no
)

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 521 views
  • 2 likes
  • 2 in conversation