![]() ![]() It will make a new file each time that value changes. What the filevar option does is it tells SAS to look at a variable and use that for the file location, instead of whatever is on the file statement - so there is a dummy a there (unrelated to the name of your dataset). For this to work how you want it must be sorted by var1 (at least grouped by it, if not sorted). You could do the export, copy the export code from the log into a program file, and just change the file statement as I do above (and add the creation of that variable code) in order to get it to work. (obviously with real variable names and appropriate $ and whatnot). ![]() You can't do that directly in proc export, but since you're writing out a CSV you could do it yourself! data _null_ įile_w_var1 = cats('c:\folders\filename',VAR1,'.csv') Consider the website This is called FQDN (Fully Qualified Domain Name) Each domain consists of domain components, the dot separates these components. Now, if this value changes, and you want a new file for each set of rows with a common value for var1, then it's different. Before going for DNS configuration in Linux, one should first understand the basics of DNS and how it works. macro variable you can insert into your export: PROC EXPORT DATA= WORK.A One question would be, when you say ' the value of a variable ' what do you mean? If you mean "the value of one variable on one row", even if that's actually present on all rows, you can do it pretty easily: proc sql You can't directly use a data step variable in this manner, because PROC EXPORT doesn't interact with the data step (even if it makes use of it in some cases). In order to do this, you'll need to pull that value out into a macro variable.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |