Hi,
I am trying to convert a numeric year to a character year field.
put(VW_client_Social.BroadCastYear,yyyy4.) aS BroadCastYear_chr
works just fine in SAS EG but when I try the same expression in VA 7.1 , I get this error -
ERROR: The format YYYY was not found or could not be loaded.
ERROR: Character expression requires a character format.
3 Th
Thanks,
saspert.
if I change yyyy4. to year4, Sas eg runs fine but returns 1965 as the output
while SAS VA gives the below error -
ERROR: Character expression requires a character format.
Date manipulation in SAS Visual Analytics needs to be done differently than Base SAS. There is no put function available. You need to use the TreatAs function. See this recent post for ideas https://communities.sas.com/t5/SAS-Visual-Analytics/How-to-calculate-age-from-birthdate-using-SAS-VA...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.