About User12

ballardw · ‎08-31-2017

As @novinosrin says, no. But the "fix" is insted of subquery create a separate query that generates just the macro variables you attempt from the subquery. But that may not be needed at all. proc sql noprint; select distinct names into :names1-:names9999 from sample ; quit; If you do not 9999 distinct names on the names1-namesXXX are created. The automatic SAS macro variable &sqlobs will have the count of returned items in the last previous query. So %let NameCount = &sqlobs; immediately after the Proc SQL will capture that count. If you suspect you need more than 9999 macro variables (a real bad sign IMHO) increase the count.

Oligolas · ‎06-12-2017

Hi, if you already compared a with c, you do not need to compare c with a. Regarding the 100 variables... is this an issue you still require assistance on? if so, are these 100 variables always available in all datasets? if you have those 100 variables in a and let's say only 85 of them in b (15 variables of 'a' are'nt available in 'b'), what should be the result of the comparison? Can you perhaps provide 3-4 datasets for testing?

Peter_C · ‎05-31-2017

To generate code without the block-commented code, would this approach work? Before the first line of the code add this statement: %MACRO COMMENTREMOVAL ; After all the statements, add statements %MEND COMMENTREMOVAL ; FILENAME MPRINT TEMP ; OPTION MPRINT MFILE LRECL= 3000 ; %COMMENTREMOVAL ; RUN ; OPTION NOMFILE ; DATA _NULL_ ; INFILE MPRINT ; INPUT ; LIST ; RUN ; I think this should echo to the log, a file of the code generated. It will not include the block-commented code. It has the downside that the code would need to be executed to generate this file of "clean" code.

User12 · ‎01-10-2017

I am taking data from a front end java app its up and running multiple people can submit data at a time over there

maverickkub · ‎08-30-2016

Hi. Can you be more specific? If you are trying to group categorties together that is not possible in VA.However if there is a category which has different data vaules you can create a custom category to edit and manipulate those data values however you want.

maverickkub · ‎08-29-2016

Thanks So much Varsha.This led me to another thing which I am going to post.

User12 · ‎08-27-2016

hi Pamela_JSRCC the calculated variables are created by me and the values are stored in numeric format as all other calculated variables now i have to find out min value of the calculated variable and i have the dataset only in VA.

User12 · ‎08-22-2016

I have already tried to use display rules but i couldn't find out a way to automate them

User12 · ‎08-15-2016

Thanks for the suggestion

MichelleHomes · ‎08-15-2016

Great to hear! Please mark this question as solved. Kind Regards, Michelle

Online Status	Offline
Date Last Visited	‎12-12-2018 11:29 AM

USING :INTO in SUBQUERIES

Re: Identifying Duplicates datasets

Re: Identifying Duplicates datasets

Re: Removing Comments

Re: Removing Comments

Re: Identifying Duplicates datasets

Identifying Duplicates datasets

Re: Removing Comments

Re: Removing Comments

Removing Comments

Re: Access Volatile Teradata Table

Re: Identifying Duplicates datasets

Re: SAS VA 7.3>> IS there a way to divide my date variable

Re: USING :INTO in SUBQUERIES

Re: Identifying Duplicates datasets

Re: Removing Comments

Re: Import Data from Web services

Re: Grouping variables in SAS VA 7.3

Re: 3 FAQs on date calculations in SAS Visual Analytics

Re: Minimum and maximum value of calculated numeric variable

Re: VA7.3 >> Applying different color coding in VA

Re: SAS VA 7.3>> IS there a way to divide my date variable

Re: VA REporting In 7.3 >>I am creating a report in SAS VA 7.3 . Here...