I want to write SAS code that can read in csv file every time it is read, number of columns maybe different.
In addition, I need to use different variables to look up different values.
let's say first time I have 3 columns, it's a look up table, use var1 - var2 to look up RF01
next time when I read in the file, it has 5 columns, use var1 - var3 to look up RF01 and RF02
So, given this situation, the column number is not fixed, and also look up column value is different too.
Any ideas?
One Clarification.Var1-Var2 are two variables whcihis being used to lookup RF01. when file has 5 columns , we need to use four vairbales to look up.
Any example to explain this would be helpful
1st time, table is like this:
var1 var2 RF01
us fin IR
eu tech FX
ca svc sprd
2nd time, table is like this
var1 var2 var3 RF01 RF02
us fin swp crv01 FX
eu corp sptn crv02 sprd
gb bnk edotn crv04 ir
Why not use proc import to import csv file.
but about your querying. I don't know which criterion you used to judge variable should be var: or RF: ?
Ksharp
Will different iterations of this process also add any rows to your data?
I think the PROC IMPORT solution Ksharp mentioned is a good start but if you have rows added to your data there may be an issue with a variable column changing data types from numeric to string based on the content.
Suppose the first time you read the data with column 10 the values are numeric. Then in a later version added rows in column 10 now contain some text values. Proc import is likely to make that variable string.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: