About danfavero

danfavero · ‎03-02-2018

I am importing as text exactly to keep all the 16 decimal places '0.1234567890123456'. However, when I create a numeric variable converting the text to numeric, I only can keep 14 decimal places 0.12345678901234. I would like to confirm whether SAS has such a limitation or I can find any numeric format to keep all the 16 decimal places. Thanks

danfavero · ‎03-02-2018

Hello Everyone, I have the following value in a variable '0.1234567890123456'. I need to create a numeric variable to keep exactly the same number as the text and tried a variety of formats. However, the closest I got was a numeric field with the number 0.12345678901234 (14 decimal places instead of 16) Any hint to keep all 16? Thanks!

danfavero · ‎01-23-2018

I have macro which creates multiple datasets and not always the same datasets are created. How can I keep only existing datasets names into a SAS variable and SET all of them together? For example: Data A; A=1; Run; Data C; C=1; Run; /*Here we will have an error as the dataset B does not exist*/ DATA All_Data; Set a b c; run; /*My idea was storage all the existing datasets (A and C) and do something like this*/ DATA All_Data; Set &existing_datasets.; run; How do I read the existing datasets and store their names into a variable? Thanks in advance.

danfavero · ‎09-30-2014

Dear All, I would like to know how can I add a letter to the PUT statement below: data _null_; infile test ; file '/sas/sasdata/FOLDER/FILE.txt'; input; /*Here I need to add the letter D + the content so it would be like PUT 'D' || _infile_; but it doenst work */ put _infile_; run; I believe it is pretty basic put I'm struggling to find a solution.

danfavero · ‎09-22-2014

Does anyone know by any chance how to export a txt file with double quotes and when the text field is blank it be exported as ""? For example: field1 field2 field3 abc 123 XXX def 456 ghi 654 YYY I would like to export a txt file like this: field1;field2;field3 "abc";123;"XXX" "def";456;"" "ghi";654;"YYY"

danfavero · ‎07-09-2014

Yes Jaap, I really need to protect sensitive data, I would like to not have to create separate files with sensitive and non-sensitive information. However I couldnt find anything efficient to do that.

danfavero · ‎07-09-2014

Unfortunately I dont have the access to SAS Metadata Server and "Using Libname Sintax" goes exactly to the spelunking issue that you mentioned. I'm trying to find a solution to hide sensitive data from the users and the best thing I could think was creating views displaying only the allowed data, it is simple and would save space. Anyways thank you very much. If anybody can give me any other suggestion I would really appreciate!

danfavero · ‎07-09-2014

Dear all, I created a view to a table and would like to restrict the user access only to the view blocking the access to the table. Can anybody give me a hint of how to do it?

danfavero · ‎11-24-2011

I've been facing problems scheduling my projects in Sas Guide 4.1 since it has asked my username and password during the process. Does anybody know how to set up sas guide without it ask for password?

Online Status	Offline
Date Last Visited	‎03-02-2018 06:50 PM

Re: Keeping Decimal Places

Keeping Decimal Places

How to store existing datasets names into variables?

Concatenating a letter when exporting

How to export a txt with double quotes

Re: Grant access to a view not to the table

Re: Grant access to a view not to the table

Grant access to a view not to the table

Login Problems - Scheduling Project

Re: Grant access to a view not to the table

Re: Grant access to a view not to the table

Re: Keeping Decimal Places

Keeping Decimal Places

How to store existing datasets names into variables?

Concatenating a letter when exporting

How to export a txt with double quotes

Re: Grant access to a view not to the table

Re: Grant access to a view not to the table

Grant access to a view not to the table

Login Problems - Scheduling Project