Ladies and Gentlemen: I forgot to put the option (compress=yes) in my original code when creating dataset. Is there a way to compress those SAS datasets in a batch mode? There are too many of them to do it manually? I found this: *----------------------------------------------------------------------; * Copying datasets adding compression ; *----------------------------------------------------------------------; %let path=.; options compress=yes ; libname in "&path"; libname out "&path"; proc copy inlib=in outlib=out noclone datecopy memtype=data ; run; But I'm not sure this works or not, or it is the correct way for doing so. Thanks -
... View more
I ran the code. It is able to get the file name and the number of observation correct, but all other variables in the individual TSV file is missing. Could you please tell me how would I best modify the code so that it would accommodate .TSV file. The thing is the tab separated file contains "" for each value in the file. Excel can real the file no problem, but maybe not SAS... Thanks -
... View more
Ladies and Gentlemen: Just wondering if there a way to combine a lot of individual .TSV files (tab delimited text file) into a SAS data with one additional variable called 'SOURCE_FILE_NAME?' For example, HAVE1.TSV has the following variables: drug_name drug_id company_id company_name drug A drug B I hope to combine thousands of files like HAVE1,TSV (they all have the same variable name) into WANT and add additional variable SOURCE_FILE_NAME. In this case, it would be HAVE1. SOURCE_FILE_NAME drug_name drug_id company_id company_name HAVE1 drug A HAVE1 drug B The complication is that each file may contain more than one observation. Is there a way to do so? Thank you!
... View more
Hi, Hai: I modify the libname = 'mydata', but the program report: Syntax error, expecting one of the following: a name, ;, DEFAULT, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 200-322: The symbol is not recognized and will be ignored
... View more
Suppose that the data are stored in d:\sasdata\ and the libname for it is mydata. How would I accommodate the code? I tried to modify the code into: where libname eq 'mydata' and upcase(memname) eq: 'DATA'; But it doesn't seem to work...
... View more
Dear All: I have around 50 tables that I hope to combine into one using: data data_combo; set data1-data50; run; These tables contain common variable names. But I got the following error message: Multiple lengths were specified for the variable VARIABLEXXX by input data set(s). This may cause truncation of data. How could I avoid such problem by just specify in the data_combo, the length of the variable is set as the largest of the all the tables that are going to be combined into DATA_COMBO? Right now, I have to do a PROC CONTENTS to see the variable length for all of the table and then manually specify the maximum length
... View more
Thank you for your help, but the download function is deactivated for the first link, and the second link does not contain dataset for those used in the SAS Documentations...
... View more
Dear All: I hope to go through some of the examples in the SAS documentation. Unfortunately, some of the data, the code says "...more lines...", making it impossible to replicate the results in the documentation. The same is true for a lot of SAS User Group Papers. Is there a central place to download all such data so that users can go through the procedure illustrated in the documentation if they want? For example, I cannot find the data for Example 79.1 Modeling Salaries of Major League Baseball Players on page 6753 of the procedures. Thank you -
... View more
Thank you, Ksharp and sunilzood! It works like charm on my data. Could you explain a little bit of the more about the y=scan(x,4,'./'); Especially, the 4 and ./ part, since there are multiple slashes... Thank you!
... View more
Hi, everyone: Just wondering how to extract the red portion of the following strings? client/data/20/0000893220-98-000530.txt client/data/810084/0001193125-08-059176.txt client/data/914208/0000950129-07-000703.txt client/data/1036213/0001036213-98-000015.txt client/data/1103345/0001103345-05-000031.txt client/data/1161175/0000950123-10-012321.txt The red string always fall between the third slash and the .txt portion. I understand I need to use anypunct and anynum to solve this problem. However, after several try, I still get 0. Thank you!
... View more
Dear All: May I ask how to transform the following have table to the want table right below? HAVE table: patient tcell_[year1] tcell_[year2] tcell_[year3] tcell_[year4] tcell_[year5] A 23 34 213 45 435 C 132 213 123 345 435 D 13 123 123 435 123 E 343 1231 4325 435 345 WANT table: patient year tcell A 1 23 A 2 34 A 3 213 A 4 45 A 5 435 C 1 132 C 2 213 C 3 123 D 1 13 D 2 123 D 3 123
... View more
