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

I made a pivot table in excel using SAS Add in, when I connect excel in SAS base data set the data field changes the format, in SAS the format is mmddyy10. already in excel appears as numeric, someone tell me a solution?

Thank you

 

 

PROC SQL;
CREATE TABLE SEG4.TB_SMS_SENT_CPF AS
SELECT DATA_EVENTO format=mmddyy10. as DATA_EVENTO

1 ACCEPTED SOLUTION

Accepted Solutions
1 REPLY 1
tomrvincent
Rhodochrosite | Level 12
Try date9.

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!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

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