About leela214

leela214 · ‎03-08-2019

I just experienced similar problem that I had experienced in 2017. I have used the solution that I have received and worked last time, which is clear browser cache. But, it didn't work. I tried several time. The variable names will stuck in the same position(I only get to see the first few variable names). As I moved the scroll bar on the bottom, I will be able to see all the way to the last column of my dataset. But, the variable names will remain the same position(the first few variable names). The same happens if I used a .sas7bdat dataset or proc import a excel or csv file into sas studio. I will appreciate any help I can get! Difficult to get works done when I couldn't look at the output dataset and able to know which columns belong to which variable.

leela214 · ‎03-05-2018

Thank you so much! It work. I tried using the option, 't' -trim in other function too, but didn't work too. I'm glad you were able to solve my question!

leela214 · ‎03-05-2018

I would like to find siteid in the site_affected. If it's in the list then I can do something afterward. However, I was not able to use the find, index function to achieve this. I have tried if index(site_affected, siteid) gt 0 then do; date = 01/JAN/1990; date2 = 02/JAN/2990; end; siteid site_affected 1071 1059; 1061; 1100; 1105; 1190; 1003; 1017; 1022; 1063; 1071; 1144 date and dates are empty from the code. Will appreciate any input!

leela214 · ‎01-23-2018

It worked! Thank you for this. Is there anything I need to watch out for or be careful of when I use the vvalue function? It's way too good to be truth. If this can convert numeric to char, why would we need put function for converting numeric to char?

leela214 · ‎01-23-2018

Thank you for letting me know that I need to set the formats. I am very new to sas so I wouldn't say I'm declining to do it. It's more like I didn't know/how so I just did what I do know instead. I was taught that proc import is easier and faster when I want to import data into sas. Thank you for taking the time to read my post!

leela214 · ‎01-22-2018

the same variable in different datasets could be in different type. sometimes numeric, sometimes character. So, I want to add a step in my macro to check for variable type and convert it if necessary. your solution did help converting the variable but is there a simpler way? Thank you for your code! It did work!

leela214 · ‎01-22-2018

The source is csv. But, the same variable in different dataset could be in different type. sometimes numeric, sometimes character. So, I want to add a step in my macro to check for variable type and convert it if necessary.

leela214 · ‎01-22-2018

I have tried using vtype but it didn't work as well. I tried using vtype in the if then statement like you've kindly suggested but it didn't work. So, I created an variable to use in the if then statement, didn't work too... It would be nice if it did! Would be happy to know how I can fix this in order for it to work. random_no in here is character so it should go int to the else statement but it did't.

leela214 · ‎01-15-2018

Is there any way I could find out if a variable is character or numeric? If it's numeric then I need to convert it to character. If it's character then converting will not be needed. I tried the if vartype(varname,18) = N then varname_1 = compress(put(varname,best12.)); else varname_1 = varname; But it didn't work. I will appreciate any suggestion! Thank you!

leela214 · ‎12-13-2017

clear the browser cache worked! But, thank you for looking into this for me!

leela214 · ‎12-12-2017

Hi Reeza, The data is imported from a csv file. But I used the same codes that I used before for a different csv file, and it worked fine before yesterday. Both time, I imported the csv file into SAS studio with eh same code. The only difference is it's two different csv files. The first csv file that I have to do work on works fine, no problem, but this occur before yesterday. The second csv file that I work on yesterday ran into this problem. The problem persists till today.

leela214 · ‎12-12-2017

Everything was working fine up till yesterday. The variable names on top are not in their correct position with their own data column. If I scrolled the bar on the bottom to the right, I will see more columns but the variable names on top does not move. Before yesterday, each variable names has its own column. I will appreciate any suggestion to help solving this issue! I'm using SAS Studio, SAS version or release date is 9.04 (The second image I scrolled the bar to the middle)

Online Status	Offline
Date Last Visited	‎03-08-2019 11:58 PM

Variable names not align with the data columns below

Re: find variable in another variable

find variable in another variable

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Check variable type then convert it to character

Re: Variable names not align with the data columns below

Variable names not align with the data columns below

Re: find variable in another variable

find variable in another variable

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Re: Check variable type then convert it to character

Check variable type then convert it to character

Re: Variable names not align with the data columns below

Re: Variable names not align with the data columns below

Variable names not align with the data columns below