Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 86
Accepted Solution

Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Hi Forum,

 

I have a project created in SAS EG 7.1 running on Windows 7 & I have the States in Upper case (UC). When I upload the table Lasr Public folder, I find the States values have changed to a variety of Upper & lower Case combinations.

 

Does anyone know what can cause this?

 

Thanks 


Accepted Solutions
Solution
‎02-24-2016 03:22 PM
Frequent Contributor
Posts: 86

Re: Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Hi Again,

 

I haven't been able to discover why the data changed between EG & VA but I did notice there were some values in my data that were LC. I can't explain the changes when I uploaded to VA but as a workaround, I used the 'UPCASE' Function in EG for the field & the fileds are now as I need them.

 

Thanks.

View solution in original post


All Replies
Solution
‎02-24-2016 03:22 PM
Frequent Contributor
Posts: 86

Re: Text Field Changes from LC to UC between SAS EG & Upload to SAS VA

Hi Again,

 

I haven't been able to discover why the data changed between EG & VA but I did notice there were some values in my data that were LC. I can't explain the changes when I uploaded to VA but as a workaround, I used the 'UPCASE' Function in EG for the field & the fileds are now as I need them.

 

Thanks.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 225 views
  • 0 likes
  • 1 in conversation