About Ramsha

Ramsha · ‎07-19-2018

This works, thank you so much!

Ramsha · ‎07-19-2018

If I have two datasets with the same city for example, however they differ by case sensitivity: for example: list1 is NEW YORK but list2 it is New York in a given observation. Is there a way to make the merge/match be case insensitive? I have the below code but am trying to see if there is a way to disregard the case. proc sql; create table final as select L.*, R.* from list1 as L left join list2 as R on (substr(L.City1, length(L.City1)-1) = substr(R.City2,length(R.City2)-1) ; quit;

Ramsha · ‎07-19-2018

Hey man- chill, its all good- I'm new to this and just learning. I make new threads because the main idea of the topics change and I know when people google, they just want a reference.

Ramsha · ‎07-19-2018

Ramsha · ‎07-19-2018

City=scan(txtstr,-1,','); run; proc print data=test; run;

Ramsha · ‎07-19-2018

Ramsha · ‎07-19-2018

This is awesome, however how would I read the line as a very long text string? Do I have to give it some command?

Ramsha · ‎07-19-2018

Hi, this is just a continuation from the last few questions I asked since the topic evolved/changed to this. I was wondering if there was a way to read data right to left?

Ramsha · ‎07-19-2018

This actually helps alot thank you! The code is not running but I think I have more of a general idea for direction!

Ramsha · ‎07-19-2018

Also maybe using $varying informat?

Ramsha · ‎07-19-2018

Ramsha · ‎07-19-2018

I think reading input from right to left will avoid the issue of length. So the last 3 would be country, last 5 numbers and 2 characters would be state and zip and so on... I'm not exactly sure how to read that though.

Ramsha · ‎07-19-2018

Hello, This table below is part of a bigger csv file that I am working with. Some of the observations are in the wrong variable because I believe they lacked proper commas in the original file. How would I manually write input lines for this table? In my previous posts I thought it was interchangeable with an excel file but now I understand the importance of it being a csv file since I guess it gives you more freedom to work with formatting. Below is the table and some of the code I have started off with. Thank you! Data test; infile "/folders/myshortcuts/myfolder/list.csv" dsd delimiter=none; input Street City State_ZIP Country; run; proc print data=test; run;

Ramsha · ‎07-19-2018

Hello, thank you so much! Now I understand the issue. I previously thought csv and excel files were the same. So I started writing the code but I am a beginner and do not know the procedure for infile. Can you please tell me how I should code this to be in that format above in the question? I started with this...but of course I know my syntax is wrong. data places; infile "/folders/myshortcuts/myfolder/places.csv" dsd delimiter=none; input Street $ City $ State_ZIP $ Country $; run; proc print data=places; run;

Ramsha · ‎07-18-2018

Yea I believe they are originally csv files but opened in excel so I initially imported as an excel file using the snippet tool. I just have loads of these files so I just need an efficient way to data repair. The code just looked cleaner using proc import excel and the tables generated looked to be the same. So would there be an easier cleaner way with using a csv methodology? Thanks alot in advance- you're been a great help!

Online Status	Offline
Date Last Visited	‎07-21-2018 12:19 AM

Re: Case insensitive within proc sql match/merge?

Case insensitive within proc sql match/merge?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Read data right to left with varying length?

Re: Beginner: How to write input variables for these datalines?

Re: Beginner: How to write input variables for these datalines?

Re: Read data right to left with varying length?

Re: Is it possible to change an imported csv file to a txt file in SAS...

Re: Is it possible to change an imported csv file to a txt file in SAS...

Re: Beginner: How to write input variables for these datalines?

Re: How to edit imported excel file?

Re: Read data right to left with varying length?

Re: Case insensitive within proc sql match/merge?

Case insensitive within proc sql match/merge?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Re: Read data right to left with varying length?

Read data right to left with varying length?

Re: Beginner: How to write input variables for these datalines?

Re: Beginner: How to write input variables for these datalines?

Re: Beginner: How to write input variables for these datalines?

Re: Beginner: How to write input variables for these datalines?

Beginner: How to write input variables for these datalines?

Re: How to edit imported excel file?

Re: Is it possible to change an imported csv file to a txt file in SAS...